What is the purpose of each Detector for Db2 data set?

Products

• Detector for DB2 for z/OS

Issue/Introduction

What are the purpose of Detector for Db2 for z/OS (PDT) data sets?
What is the information stored in each data set?
 
VCAT.PREFIX.PDTDS.DTRW002.SSID.DATA
VCAT.PREFIX.PDTDS.DTR0001.SSID.DATA
VCAT.PREFIX.PDTDS.DTR0002.SSID.DATA
VCAT.PREFIX.PDTDS.DTR0003.SSID.DATA
 
VCAT.PREFIX.PDTCPR.PROFILE.SSID.DATA

 
Also, which one holds the Detector Exception Cache information?

Resolution

The purpose of each Detector data set is documented in hlq.CDBASRC(PDTDSALC) member.

DTR0001: Standard SQL collection data.
DTR0002: Exception SQL collection data.
DTRW002: Exception SQL collection work file.
DTR0003: Error SQL collection data.

PDTCPR: Detector Profile, there is one data set for each Detector Profile defined, in this case the Detector Profile name is PDTCPR.

The Exception cache is allocated in Xmanager storage, you can monitor the use of the cache with a Modify command.

F <xmanager>,PSTAT(DTR),DB2(ssid)


See the details in the following link:
PSTAT(DTR) Command -- Monitor the Exception Cache Pool