Workload Group shortcut added to Active Job Info

One of the SQL table functions I use the most is the ACTIVE_JOB_INFO, which is used to list all of the active jobs in any partition.

In IBM i TR4 and 7.3 TR10 a new parameter, DETAILED_INFO, was added to the Table Function. This controlled the number of columns that were returned in the results. When it was introduced there were the following options

— Default
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO()) ;

— All columns returned
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘ALL’)) ;

— QTEMP info returned only
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘QTEMP’)) ;

— Minimum info
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘NONE’)) ;
Read more »

Verified by MonsterInsights