RID List failures
RID List failures occur if the RID pool size is constrained.
If the number of times that DB2 failed to allocate storage for
RID list processing caused by storage constraints (
is not zero, or close to zero, you should reduce the storage size that is
used by other structures.
Failures because RDS or Data Manager limits are exceeded (
RDS LIMIT and
TERMINATED-EXCEED DM LIMIT) are caused
by inaccurate or incomplete RUNSTATS statistics or by optimizer errors. Add
the clause OPTIMIZE FOR 1 ROW to the SQL statement to avoid RID list processing,
or add the necessary columns to the index to make access INDEX ONLY.
If the number of RID list failures caused by storage limits (
PROC LIMIT) is not zero, or close to zero, increase the RID pool