IQL reports at collection level within Sysview for Db2
search cancel

IQL reports at collection level within Sysview for Db2

book

Article ID: 116896

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Running Sysview Performance Management Option for Db2 for z/OS (IDB2) IQL reports to find which collections are running in CICS.
What does collection ".............." reference in the reports?

Resolution

It is possible that the collection name was not supplied and the field displayed is nulls or maybe the records themselves. 

Running the BTACTTRL report with a GLOBALS WHERE clause: 
where (CONN-TYPE(,4,4) = 'CICS' OR CONN-TYPE(,4,1) = 'CTOR') 

Will provide a full display of the record that seems to lack a collection name, which will help determine more about these records.