IFCID 002 - Miscellaneous

This topic shows detailed information about Record Trace - IFCID 002 - Miscellaneous.

Record Trace - IFCID 002 - Miscellaneous

The field labels shown in the following sample layout of Record Trace - IFCID 002 - Miscellaneous are described in the following section.


                                                   MISCELLANEOUS
MX ST LOB VAL (MB)                    0  MX ST XML VAL (MB)                    0  ARRAY EXPANSIONS                      0
SPARSE IX DISABLED                    0  SPARSE IX BUILT WF                    0  RE-FRESH TABLE                        0
TRANSFER OWNERSHIP                    0  NO DM CALL RID/LPF                    0  FETCH 1 BLOCK ONLY                   19
HISTORY LOST                          0  HV RECORDING LOST                     0  ZAI STABL. PREPARE                   70
RDS SORT PERFORM.                     0  RDS SORTL USED                        0  SORT FEEDBACK                        80

QXPFSLNUM .......:                    0  QXPFSENUM .......:                    0  QXPFSENUMG ......:                    0
QXPFMAXU ........:                    0  QXPFMAXUG .......:                    0  QXPFSENUMG ......:                    0
QXN1093B ........:                    0

MX ST LOB VAL (MB)

Maximum storage used for LOB values.

Field Name: QXSTLOBV

MX ST XML VAL (MB)

Maximum storage used for XML values.

Field Name: QXSTXMLV

ARRAY EXPANSIONS

The number of times an array variable is expanded beyond 32 KB.

Field Name: QXSTARRAY_EXPANSIONS

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

REFRESH TABLE

The number of REFRESH TABLE statements.

Field Name: QXREFTBL

TRANSFER OWNERSHIP

The number of TRANSFER OWNERSHIP statements.

Field Name: QXTRNOWN

NO DM CALL RID/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

HISTORY LOST

The number of times when execution history has been lost.

Field Name: QXSTEHLST

HV RECORDING LOST

The number of times when HV recording history has been lost.

Field Name: QXSTHVLST

ZAI STABL. PREPARE

The number of times when a PREPARE request was satisfied because db2zai stabilized the statement.

Field Name: QXSTMLSFND

RDS SORT PERFORM

Number of times RDS Sort was performed.

Field Name: QXSTSRT

RDS SORTL USED

Number of times RDS Sort used the IBM Integrate Accelerator for Z Sort.

Field Name: QXSTSRTL

SORT FEEDBACK

The number of times when sort feedback was used.

Field Name:QXSTMLSRT

QXPFSLNUM