Miscellaneous LOB data report and trace
The miscellaneous LOB data report shows general information about large objects.
This block provides miscellaneous data for large objects (LOBs). For formatting reasons, OMEGAMON for Db2® PE shows different labels for report and trace. The following example shows both layouts, the report on the left, and the trace layout on the right.
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.00 0 NO DM CALL RIDL/LPF 0
FETCH 1 BLOCK ONLY 0.00 0 FETCH 1 BLOCK ONLY 0
SQL DI CL2 EL TIME N/A 40.92069 SQL DI CL2 EL TIME 6.751705
- 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
- SQL DI CL2 EL TIME
-
The accumulated elapsed time spent processing SQL Data Insights functions. This time is included in Class 2 elapsed time.
Field Name: QWAC_AIDB_FNS_ELAP