IBM Navigator for I: Work Management Integration with Performance Tasks

In last week’s blog on the features of the green screen “Work with Active Jobs” interface, there was a comment regarding the nice features of the graphical tools in Navigator for i. I had written a prior blog on some of the “Cool Tips with the Work Management GUI” that covered some additional function within the work management GUI. In that post I wrote briefly about the enhanced integration between the Active Jobs GUI and the Performance GUI. 

(more…)

Find SQL Server Mode Jobs

Anyone responsible for administering, tuning or explaining the SQL Server Mode (e.g. QSQSRVR jobs) activity might find the QSYS2.FIND_QSQSRVR_JOBS() procedure a useful tool. The procedure is passed a single parameter, the qualified job name of an application job. If the target job is active and is set up to use SQL Server Mode, the procedure determines which QSQSRVR jobs are being used by the application, in the form of active SQL Server Mode connections. The procedure collects and returns work management, performance and SQL information and returns two SQL result sets: (1) Summary information and (2) Detailed SQL Server Mode job information.

(more…)