search cancel

Sysview/ Performance for DB2 report request will not stop


Article ID: 110750


Updated On:


Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS


A batch job issues a stop command to report request IRLMCNT2. In the morning the job ran normally, but hours later Sysview Performance for DB2 still shows the request as "ending".

Owner/Name  Status     Recs   Title -------------- ------ ------ ------------------------- PRDDBA
_ IRLMCNT2  ENDING   0,       Current Lock Contentions
Trying to stop the request manually but it comes back with the message: IRLMCNT2 ,DBG55036W Request IRLMCNT2 is not found.



Component: CIDB


The dump  didn't show that any failure occurred in the SRB routine. 
Strangely, there was  another task that was also sitting and waiting for an SRB to complete.  So there were had two processes fail to execute an SRB in that address space, but there didn't seem to be any hint as to why. 
The conclusion was that something was wrong with the address space that was being displayed and then it was cancelled but there was no evidence left over as to what the problem might have been.  If it does reoccur  the address space that couldn't be canceled should be dumped for investigation.