HIGH GETPAGES

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

What are the causes for High Getpage Activity?

Answer:

High getpage activity means that DB2 is reading a lot of 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.