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.

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.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