RID list processing (BSTATDR)
------------------------ -------- ------- ------- -------
MAX RID BLOCKS ALLOCATED 3 0.13 0.01 0.01
CURRENT RID BLOCKS ALLOC 2 0.08 0.01 0.01
TERMINATED - NO STORAGE 0 0.00 0.00 0.00
TERM'D-EXCEED RDS LIMIT 0 0.00 0.00 0.00
TERM'D-EXCEED DM LIMIT 0 0.00 0.00 0.00
TERM'D-EXCEED PROC LIMIT 0 0.00 0.00 0.00
TIMES OVWFL NO RID STRG 0 0.00 0.00 0.00
TIMES OVWFL NO RID INTLMT 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT STRG 0 0.00 0.00 0.00
TIMES HYBRD JOIN INT INTL 0 0.00 0.00 0.00
TIMES MIAP SKIPPED PRE_OT 0 0.00 0.00 0.00
The following table describes the fields in the RID list processing section.
Field | Description |
|---|---|
MAX RID BLOCKS ALLOCATED | Maximum number of RID blocks in use (QISTRHIG) This value is the maximum number of RID blocks in use at any one time. Tuning Tip: If this number is at the RID pool size, check for failures. Increase the DSNZPARM parameter MAXRBLK in DSNZPARM to the maximum possible to support list prefetch and multiple index access paths. |
CURRENT RID BLOCKS ALLOC | Current number of RID blocks in use (QISTRCUR) This value is a snapshot of the number of RID blocks in use. Tuning Tip: If this number is at the RID pool size, check for failures. Increase the DSNZPARM parameter MAXRBLK in DSNZPARM to the maximum possible to support list prefetch and multiple index access paths. |
TERMINATED - NO STORAGE | Number of RID pool failures--storage exceeded (QISTRSTG) This counter is incremented every time a RID pool failure occurred due to a lack of storage. Tuning Tip: Increase the DSNZPARM parameter MAXRBLK in DSNZPARM to the maximum possible to support list prefetch and multiple index access paths. |
TERM'D-EXCEED RDS LIMIT | Number of RID pool failures--RID limit (QISTRLLM) This counter is incremented every time a RID pool failure occurred due to a single set of index entries occupying more than 50% of the RID pool. Tuning Tip: This number should be as close to zero as possible since the query degrades to a table space scan if a failure occurs. Increase the size of the RID pool in DSNZPARM MAXRBLK on installation panel DSNTIPC. |
TERM'D-EXCEED DM LIMIT | Number of RID pool failures--data manager limit (QISTRPLM) This counter is incremented when a very large RID list is encountered. The maximum RID list is 16 million RIDS. Tuning Tip: To avoid this, change the SQL statement so a different access path is chosen. If a failure does occur, the query is run as a table space scan. |
TERM'D-EXCEED PROC LIMIT | Number of RID pool failures--too many concurrent users (QISTRMAX) This counter is incremented every time a RID pool failure occurred because there were too many concurrent users. Tuning Tip: Increase the DSNZPARM parameter MAXRBLK in DSNZPARM to the maximum possible to support list prefetch and multiple index access paths. |
TIMES OVWFL NO RID STRG | Number of times the RID list overflowed due to no storage available |
TIMES OVWFL NO RID INTLMT | Number of times the RID list overflowed due to internal limits |
TIMES HYBRD JOIN INT STRG | Number of times RID appending hybrid-join was interrupted due to storage limitations |
TIMES HYBRD JOIN INT INTL | Number of times RID appending hybrid-join was interrupted due to internal limits |
TIMES MIAP SKIPPED PRE_OT | Number of times multi-index access was not performed |