IFCID 218 - Lock Avoidance Summary

This topic shows detailed information about Record Trace - IFCID 218 - Lock Avoidance Summary.

This record indicates whether a successful lock avoidance test occurred during a given unit of work. The record is externalized at the agent at each commit or rollback.

Record trace - IFCID 218 - Lock Avoidance Summary

The field labels shown in the following sample layout of Record Trace - IFCID 218 - Lock Avoidance Summary are described in the following section.


LOCK AVOID DURING UNIT OF WORK: YES      NO. PAGE SET SUBRECORDS:     4
DBID: INSQDB   PSID: EVENTS   LOCK AVOID DURING UNIT OF WORK: YES
DBID: DSNDB06  PSID: SYSDBAUT LOCK AVOID DURING UNIT OF WORK: NO

LOCK AVOID DURING UNIT OF WORK

Indicates whether there was a successful lock avoidance test during this unit of work.

Field Name: QW0218CT

NO. PAGE SET SUBRECORDS

The number of page set subrecords contained in this record. The fields DBID, PSID, and LOCK AVOID DURING UNIT OF WORK are repeated for each page set that has a lock avoidance test.

Field Name: QW0218N

DBID

The database ID.

Field Name: QW0218PD

PSID

The page set ID.

Field Name: QW0218PP

LOCK AVOID DURING UNIT OF WORK

Indicates whether there was a successful lock avoidance test for this page set during this unit of work.

Field Name: QW0218PC