by Dawn May | May 1, 2018 | Run SQL Scripts, Spooled files, Navigator for i, Db2 for i, IBM i Services
Job logs for ended jobs, where the job log is in a spooled file, are easy to search on the green screen. When viewing the spooled job log, you simply enter your search text in the find field and press F16. In addition, you can use F14 to limit the columns in which your search is performed, then press F16 to search.
However, when using the green screen, there is no find field when viewing the job log of an active job. Jobs with pending job logs have a similar problem.
(more…)
by Dawn May | Jul 13, 2017 | ACS, Run SQL Scripts, Navigator for i
You should already be familiar with the fact that you can launch Navigator for i from Access Client Solutions (ACS). But did you know that there are now functions, that when requested from Navigator for i, are executed with ACS?
(more…)
by Dawn May | Oct 5, 2015 | SQL, ACS, Run SQL Scripts, IBM i Services, Performance
IBM has announced IBM i 7.2 TR3 and 7.1 TR11.
(more…)
by Dawn May | Aug 31, 2015 | SQL, Run SQL Scripts, Server Jobs, Subsystems, IBM i Services, Work Management
In the blog Route Db2 Requests to a Specific Subsystem, I wrote how you can use the QSYS2.SET_SERVER_SBS_ROUTING procedure to route work for database queries using the QZDASOINIT or QRWTSRVR server jobs to customized subsystems. This is a new way to route work based upon the requesting user profile that augments the other ways you can route work to subsystems.
(more…)
by Dawn May | Jul 27, 2015 | SQL, Run SQL Scripts, IBM i Services, Work Management
This is the final article in the series of blogs reviewing the enhancements in IBM i 7.2 for improved tracking of temporary storage. This blog describes the IBM i Temporary Storage Service. It is one of the many IBM i Services that have been added to IBM i over the past few years.
(more…)
by Dawn May | Jul 13, 2015 | SQL, Run SQL Scripts, Availability, IBM i Services, IFS
My last blog was an Introduction to IBM i System Limits and Maximum Capacities. In that blog, I introduced System Health Services, which allow you to track system limits. System limits tracking support is provided via Db2 PTFs, so be sure to install the latest Db2 Group PTF when you start to explore this capability. The limits tracked vary by release and Db2 Group PTF level.
(more…)