Where does Subsystem Analyzer obtain GETPAGE and TB_GETPAGE statistics within the SS Analyzer DB Table Activity Display
search cancel

Where does Subsystem Analyzer obtain GETPAGE and TB_GETPAGE statistics within the SS Analyzer DB Table Activity Display

book

Article ID: 13777

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Where does Subsystem Analyzer for Db2 for z/OS (PSA) obtain GETPAGE and TB_GETPAGE statistics within the SS Analyzer DB Table Activity Display?
Does this come from RUNSTATS?

Resolution

When Db2 RUNSTATS is executed, Db2 obtains optimum access paths to all objects. RUNSTATS is run after table/index is created.
GETPAGE activity is collected by PSA via its intercepts to Db2 DSNB1GET. PSA reports the GETPAGE information from the Db2 control
block that tracks Getpages.