IQL reports at collection level

Document ID : KB000116896
Last Modified Date : 12/11/2018
Show Technical Document Details
Issue:
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
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.