What is the purpose of Detector data sets?

Document ID : KB000123088
Last Modified Date : 17/12/2018
Show Technical Document Details
Question:
What is the purpose of Detector 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?.
Answer:
The purpose of each Detector data set is documented in R190.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 PTXMAN,PSTAT(DTR),DB2(ssid)

You can see the details in the following link:

PSTAT(DTR) Command -- Monitor the Exception Cache Pool

https://docops.ca.com/ca-detector-for-db2-for-z-os/19-0/en/using/using-mvs-modify-commands-to-control-collection/pstat-dtr-command-monitor-the-exception-cache-pool