IDB2 REPORT TABLE APPL_PGM+DETAIL HAS NO BP_GETPAGE RECORDS AFTTER BEING LOADED WITH SMF DATA

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

After loading IDB2 table APPL_PGM_DETAIL from SMF records, The BP_GETPAGE field has zeroes in it.  The following account trace class 1,2,3,7,8 are turned on.  This should be thread level getpages.  When looking online, the thread level getpages are populated.  

 

 

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

 

The R/HTDETL(GETPAGE)  field is being populated by the IDB2 history files whereas the loading of the table APPL_PGM_DETAIL is from SMF Records. To compare the two, use IDB2 history files to load table APPL-PGM-DETAIL instead of SMF.