Cannot display SQL Exec Current Stats within Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

When attempting to use Sysview Performance Management Option for Db2 for z/OS (IDB2) Option '10  SQL Exec Current Stats' in SQL Analysis there
was no display and warning message DBG55036W Request DYNSQLST is not found was displayed.

Resolution

Reviewed the IDB2 data collector output and Request DYNSQLST was started correctly. 
 

DBG04004I 18:43:25 REQUEST DYNSQLST FROM STARTUP
...
DBG04006I 18:43:37 FOLLOWING IFCIDS ARE USED BY REQUEST NAMED DYNSQLST:
316 

DBG04005I 18:43:37 START SUCCESSFUL FOR REQUEST DYNSQLST. 

 

In the output there was message DBG98004I CA SYSVIEW FOR DB2 LOW ON VIRTUAL STORAGE (<2M AVAIL). 
This might be a problem with storage available.  In the IDB2 data collector REGION=32M was specified.
Requested to change to REGION=0M and then warning message DBG55036W was no longer displayed.