IFCID 223 - Lock Avoidance Detail

This topic shows detailed information about "Record Trace - IFCID 223 - Lock Avoidance Detail".

This record shows lock avoidance information for each successful test.

Record trace - IFCID 223 - Lock Avoidance Detail

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

LOCK RES TYPE:  ROW LOCK                              
DBID: DSNDB06             OBID: SYSUSER               
TABLE_SPACE_TYPE: N                                   
RESOURCE ID: X'00000313'                              
PARTITION:      0       PAGE NUMBERING: ABS
QW0223U   X'008500331ACA3460'                         
QW0223O   X'008500331ACA33A0'                         
QW0223CL  X'00'

LOCK RES TYPE

The resource type being accessed.

Field Name: QW0223KT

DBID

The database ID.

Field Name: QW0223KD

OBID

Object id of the page set or table record.

Field Name: QW0223KP

TABLE_SPACE_TYPE

The type of the table space:

L: Non-EA large table
N: Non-large table
R: Partitioned by range (PBR) universal table spaces (UTS) that use relative page numbers
V: EA-enabled large table

Field Name: QW0223TY

RESOURCE ID

The ID of the small resource.

Field Name: QW0223KR

PARTITION

Start of change Shows the partition number or 0 if non-partitioned. End of change

Field Name: QW0223PT

PAGE NUMBERING

Indicates how page numbers are shown for partitioned tables:

REL: Indicates that relative page numbers are shown in the partition.
ABS: Indicates that absolute page numbers are shown in the partition.
N/A: Not applicable.

Field Name: QW0223P1

Feedback