Regarding intervals where there is no SQL activity, why do some intervals appear in the Datastore with plan PSAPLN01 activity, whereas others do not?

Document ID : KB000015399
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Regarding intervals where there is no SQL activity, this document explains why some intervals appear in the Datastore with plan PSAPLN01 activity, whereas other intervals do not.

Question:

Regarding intervals where there is no SQL activity, why do some intervals appear in the Datastore with plan PSAPLN01 activity, whereas others do not?

Environment:
z/OS 1.11 and above.
Answer:

PSAPLN01 entries that appear in Detector are created by Subsystem Analyzer module SA$CDB. Whenever a Table name lookup is needed, this module inquiries 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

2) Or, if 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 Datastore.