Observation: Index and Data Page Offset
The offset from the index pages to the data pages exceeds the limit for a clustering index, which indicates clustering for the index is degrading. To improve the probability that the Db2 optimizer will use clustering index:
-
Execute REORG to restore clustering
-
Run RUNSTATS to update statistics
-
Rebind affected plans.