Detector Interval 00:00:00 not in their corresponding daily Detector data store
Article ID: 214559
Updated On:
Products
Issue/Introduction
Customer designed Detector data stores to stop the collections each day at 00:00 and start the new Detector collections over a new Detector data store.
Found the following sequence of messages in the Xmanger output:
---- MONDAY, 15 MAR 2021 ----
...
23.59.01 STC16998 PXM0107 MODIFY TEXT = STOP(DTR) DB2(DBPA)
00.00.01 STC16998 ---- TUESDAY, 16 MAR 2021 ----
00.00.01 STC16998 PDT0731 DETECTOR TERM CLEANUP QUEUED DB2=DBPA ID=0000349
00.00.02 STC16998 PDT0170 DETECTOR COLLECTION INTERVAL END TIME=00:00 INTERVAL=01:00 DB2=DBPA VCAT=SYXP.CASOL
DATASTORE=DSTOR01 REL=20
00.00.02 STC16998 PDT0103 DETECTOR TERM COMPLETE FOR DB2=DBPA COUNT=0006
00.00.33 STC16998 PXM0105 CA/XMANAGER MODIFY IN PROGRESS XMID=2000
The Modify command was issued at MONDAY, 15 MAR 2021 but the Detector collection
interval was stored in the Detector data store started at TUESDAY, 16 MAR 2021.
Environment
Release : 20.0
Component : CA Detector for DB2 for z/OS
Resolution
From the Xmanager log, we see that the modify command was issued to stop the Detector collection for DBPA Subsystem, however Detector collection did not stop until Tuesday early morning as it had to finish the cleanup process before termination.
Detector completed the cleanup, externalized the data to the interval and terminated itself. Since the cleanup took little more than a minute, the next interval was entered, so externalization happened into the new interval where the SQL activity was completed. When PLEXINTV(Y) is specified, the interval is always rounded. This does not indicate a problem. Detector is working as designed. Detector does not terminate without cleaning up the storage acquired by it for SQL processing.
Feedback
