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

Products

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

Issue/Introduction

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

Environment

Release : 20.0

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

Cause

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

Resolution

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.