What are the causes of high Db2 GETPAGE activity show in Detector
Article ID: 16189
Updated On:
Products
Detector for DB2 for z/OS
Issue/Introduction
What are the causes for high Db2 GETPAGE activity captured by Detector for Db2 for z/OS (PDT)?
Resolution
High GETPAGE activity means that Db2 is reading many pages to satisfy SQL requests. This generally points to an
index tuning opportunity or the fact that RUNSTATS may not have been run causing Db2 to choose the wrong access path to the data.
Feedback
Yes
No
Powered by
