Miscellaneous LOB data report and trace
The miscellaneous LOB data report shows general information about large objects.
Report: Trace:
MISCELLANEOUS AVERAGE TOTAL MISCELLANEOUS TOTAL
-------------------- -------- -------- -------------------- --------
MAX STO LOB VAL (KB) 0.00 0 MAX STO LOB VAL (KB) 0
MAX STO XML VAL (KB) 0.00 0 MAX STO XML VAL (KB) 0
ARRAY EXPANSIONS 0.00 0 ARRAY EXPANSIONS 0
SPARSE IX DISABLED 0.00 0 SPARSE IX DISABLED 0
SPARSE IX BUILT WF 0.00 0 SPARSE IX BUILT WF 0
NO DM CALL RIDL/LPF 0.30 3 NO DM CALL RIDL/LPF 5
FETCH 1 BLOCK ONLY 0.10 1 FETCH 1 BLOCK ONLY 2
- MAX STO LOB VAL (KB)
-
Maximum storage used for LOB values.
Field Name: QXSTLOBV
- MAX STO XML VAL (KB)
-
Maximum storage used for XML values.
Field Name: QXSTXMLV
- ARRAY EXPANSIONS
-
The number of times a variable array has been expanded beyond 32 KB (DB2 field: QXSTARRAY_EXPANSIONS).
Field Name: AXSTAEXP
- 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