Where does PSA gets GETPAGE and TB_GETPAGE statistics in SS Analyzer DB Table Activity Display from?

Document ID : KB000013777
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Where does PSA gets the GETPAGE and TB_GETPAGE statistics in  SS Analyzer DB Table Activity Display  from? Does this come from RUNSTATS?  I would think this is a bug?

 

18.0    >   ------- SS Analyzer DB Table Activity Display ------ 03-28-17 14:24 .      

Command ====>                                                   Scroll ==> PAGE .      

                                                                   LINE 1 OF 65 .      

DB2 SSID ===> DB20                                        Database ==> DCRF     .      

View Type ==> A  * -Activity, B -Access Type, C -Access Ratios                  .      

                                                                                .      

Interval Date => 03-20-17   Interval Time => 14:00:00   Elaps Time => 07-24     .      

------------------------------------------------------------------------------- .      

                                                                                .      

S -Index Activity, A -SQL Activity, D -Table Detail                             .      

                                                                                .      

   TABLENAME          TSNAME   TSTY PCTGP  GETPAGE    TB_GETPAGE IS_GETPAGE ICT .      

   ------------------ -------- ---- ------ ---------- ---------- ---------- --- .      

_  C_IP_X_AU          SCIPXAU  PART  21.8%    7143134    7143134          0   0 .      

_  C_IP_X_LOC         SCIPXLC  PART  21.4%    7009364    7009364          0   0 .      

_  C_BEVT_COMN        SCBVTCM  SEGM  13.2%    4314078    4314078          0   0 .      

_  C_PHYS_ADDR        SCPHADDR PART   8.4%    2766972    2766972          0   0 .      

_  C_AU               SCAU     PART   6.9%    2269558    2269558          0   0 .      

_  C_IP               SCIP     PART   6.6%    2173414    2173414          0   0 .                        .

Answer:

When DB2 Runstats is executed, DB2 tries to obtain optimum access paths to all it's objects. RUNSTATS is run after table/index is created. Get page is collected by Subsystem Analyzer(PSA) via its intercepts to DB2 DSNB1GET.PSA just reports the Getpage information from the DB2 control block that tracks Getpages.