Miscellaneous LOB data report and trace
The miscellaneous LOB data report shows general information about large objects.
- 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
Field Name: QXR1BOAD