IQL reports at collection level

Products

• 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

Issue/Introduction

Running IQL reports to find which collections are running in CICS: what collection ".............." is referencing in the reports.
Here is an example:
SUBSYS   NAME      CONNECTION COLLECTION
-----           ----------     ------------------
2PA          PRACICS  ATM
2PA          PRECICS  EMS
2PA         PRDCICS   ..................
2PA         PRFCICS   ..................
2PA         PRGCICS .  ..................
D2PA PRLCICS SGN D2PA PRECICS SRE D2PA PRACICS UAS

Environment

Release:
Component: CIDB

Resolution

lt’s 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.