Miscellaneous

Statistics - Miscellaneous

The field labels shown in the following sample layout of Statistics - Miscellaneousare described in the following section.

MISCELLANEOUS                            VALUE
------------------------  --------------------
HIGH LOG RBA              00000000001698125C05
BYPASS COL                                0.00
MAX SQL CASCADING LEVEL                   0.00
MAX STOR LOB VALUES (MB)                  0.00
MAX STOR XML VALUES (MB)                  0.00  
ARRAY EXPANSIONS                          0.00 
SPARSE IX DISABLED                        0.00 
SPARSE IX BUILT WF                        0.00 
NO DM CALL RIDL/LPF                       5.00
FETCH 1 BLOCK ONLY                     1519.00
RDS SORT PERFORMED                        0.00
RDS SORTL USED                            0.00
ZAI STABILIZED PREPARE                    0.00
SORT FEEDBACK USED                        0.00
FTB THRESHOLD                          1000.00
FTB CRITERIA MEET                       245.00
FTB TRAVERSE ABOVE THE THRESHOLD          0.00
FTB TOTAL MEMORY ALLOCATION               0.00
FTB IN THE PREVIOUS OPTIMIZATION          0.00
FTB IN THE CURRENT OPTIMIZATION           0.00

HIGH LOG RBA

The high-used RBA address of the log (Db2 field prior to Db2 11: QWSDLR).

Field Name: QWSDLRG

BYPASS COL

The total number of columns (rows x columns) for which an invalid select procedure was encountered.

Db2 bypasses invalid select procedures which can cause some degradation in performance.

Field Name: QISTCOLS

MAX SQL CASCAD LEVEL

The maximum level of indirect SQL cascading. This includes cascading because of triggers, UDFs, or stored procedures.

Field Name: QXCASCDP

This is an exception field.

MAX STOR LOB VALUES (MB)

Maximum storage used for LOB values.

Field Name: QXSTLOBV

This is an exception field.

MAX STOR XML VALUES (MB)

Maximum storage used for XML values.

Field Name: QXSTXMLV

ARRAY EXPANSIONS

The number of times an array variable is expanded beyond 32 KB.

Field Name: QXSTARRAY_EXPANSIONS

SPARSE IX DISABLED

The number of times that sparse index was disabled because of insufficient storage.

Field Name: QXSISTOR

SPARSE IX BUILT WF

The number of times that sparse-index built a physical work file for probing.

Field Name: QXSIWF

NO DM CALL RIDL/LPF

The number of times that RDS did not call data manager for RID list retrieval for multiple index access or list prefetch because runtime adaptive index processing was able to determine the outcome.

Field Name: QXRSDMAD

FETCH 1 BLOCK ONLY

The number of times that RDS fetched one block and made no subsequent requests for additional blocks.

Field Name: QXR1BOAD

RDS SORT PERFORMED

Number of times RDS Sort was performed.

Field Name: QXSTSRT

RDS SORTL USED

Number of times RDS Sort used the IBM Integrated Accelerator for Z Sort.

Field Name: QXSTSRTL

ZAI STABILIZED PREPARE

The number of times when a PREPARE request was satisfied because db2zai stabilized the statement.

Field Name: QXSTMLSFND

SORT FEEDBACK USED

The number of times when sort feedback was used.

Field Name: QXSTMLSRT

FTB THRESHOLD

FTB threshold: minimum number of index traversals.

Field Name: QISTTRAVMIN

FTB CRITERIA MEET

Total number of indexes which meet FTB criteria.

Field Name: QISTFTBCANT

FTB TRAVERSE ABOVE THE THRESHOLD

Total number of indexes which meet FTB criteria and the traverse count is above the threshold.

Field Name: QISTFTBCAN

FTB TOTAL MEMORY ALLOCATION

Total memory allocation for all FTBs for this member.

Field Name: QISTFTBSIZE

FTB IN THE PREVIOUS OPTIMIZATION

Number of indexes for which FTB existed in the previous run of in-memory optimization.

Field Name: QISTFTBNUMP

FTB IN THE CURRENT OPTIMIZATION

Number of indexes for which FTB exists in the current run of in-memory optimization.

Field Name: QISTFTBNUMC