Why does the Subsystem Analyzer for Db2 Table Activity Display showing SPTR Table activity for Statically bound Programs

Products

• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Why does the Subsystem Analyzer for Db2 for z/OS (PSA) Table Activity Display show SPTR Table activity for Statically bound programs?

Resolution

The STPR table is internal to Db2. When the I/O collected for this particular table is encountered, it is because Db2 accessed it
on behalf of the application. Subsystem Analyzer simply reports information that it received from Db2.