Getpages from Sysview for Db2 do not match the Getpages from Detector for the same SQL statement
search cancel

Getpages from Sysview for Db2 do not match the Getpages from Detector for the same SQL statement

book

Article ID: 17164

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Detector for DB2 for z/OS

Issue/Introduction

Getpage counts from Sysview Performance Management Option for Db2 for z/OS (IDB2) do not match the Getpage
counts from Detector for Db2 for z/OS (PDT) for the same SQL statement.

Resolution

The IDB2  Detail and History screens, as well as the BTACTSMS report uses the GET-PAGE field.
Whereas, the PKG-GET-PAGE field is a better match for Detector.

Also, what apparently is not counted (or rather aggregated into IFCIDs) are the package level details of Getpages (or more generally per buffer pool stats)
in child threads roll up records (when parallelism is involved), but thread level data are still available. That is the source of the discrepancy between
summaries of GET-PAGE and PKG-GET-PAGE fields.