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

book

Article ID: 15399

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/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.



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.

Resolution

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.