Using Sysview for Db2 (IDB2) IUIBATCH program to check if an IQL Exception Request is active


Article ID: 220526


Updated On:


CA Database Management for DB2 for z/OS - Performance Suite


Using IDB2's Batch UI (PGM=IUIBATCH), is there a way to check the status of an IQL Exception Request?   


The current design of the IUIBATCH program does not offer a STATUS parameter.


Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS


The best way to check (via the Batch UI) if an IQL Exception request is active is to use COMMAND=RESUME.  Using RESUME, the following messages can be returned and evaluated: 

If the IQL Exception Request is in a FROZEN state the message 'DBG052I DBG55052I Report has been restarted' is returned.  

If the Request is STOPPED or NOT ACTIVE the message 'DBG036W DBG55036W Request 'xxxxxx' is not found' is returned. 

If the Request is already ACTIVE the message 'DBG038W  DBG55038W Request is Already Active' is returned.