Regarding Detector intervals where there is no SQL activity why do some intervals appear in the datastore with plan PSAPLN01 activity

Products

• Detector for DB2 for z/OS

Issue/Introduction

Regarding Detector for Db2 for z/OS (PDT) intervals where there is no SQL activity, why do some intervals appear in the PDT datastore with
plan PSAPLN01 activity where other intervals do not.

Resolution

PSAPLN01 entries that appear in Detector are created by Subsystem Analyzer module SA$CDB.
Whenever a table name lookup is needed, this module queries the SYSIBM.SYSTABLES table
(unless the table name has already been attained during the interval).

Therefore:
1) Whenever Tables, Indexes, etc are accessed via the Subsystem Analyzer screens
or
2) A Utility job is submitted that accesses the above objects

..a PSAPLN01 entry may appear in a Detector interval.

Regarding intervals where no SQL activity takes place, nor any PSAPLN01 activity, they are not written to the PDT data store.