Search the Job Log of an Active Job

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…)

Routing Work to Subsystems

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…)

Tracking IBM i System Limits, Part 2

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…)