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…)
SQL server mode jobs are the jobs named QSQSRVR that run in the QSYSWRK subsystems. One of the more common concerns that has been raised with QSQSRVR jobs is the difficulty to manage them, and in particular, the inability to configure the subsystem in which they run.(more…)
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…)
In a 2010 7.1 announcement, there was a one-sentence statement that I thought would be good to expand upon:
IBM i 7.1 workload management enhancement enables clients to limit to the number of cores on which a selected workload can run concurrently.
So what is this, why would you want to use it and how do you get it?(more…)
In this blog, I’m going to review some of these little-known features through the IBM Navigator for i Web interface.(more…)