Miscellaneous LOB data report and trace

The miscellaneous LOB data report shows general information about large objects.

Figure 1. Miscellaneous LOB data report and trace

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