Skip to Content

Observation: Data Page Relocation

The number of data pages relocated from their original page exceeds the limit for relocated pages. To improve performance, execute REORG for the tablespace in which you defined the table, run RUNSTATS, and rebind affected plans.

Warning

Important

Large changes in FARINDREF between executions of RUNSTATS indicates a high level of I/O activity on the tablespace. If FARINDREF increases steadily, consider increasing PCTFREE and FREEPAGE for the tablespace in which you defined the table.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI iStrobe Web