SYS_LOCK_CONFLICTS

Information on the lock conflicts which occurred most recently (in chronological order).

Column name

Data type

Contents

TIME_OF_CONFLICT

TIMESTAMP (3)

Time at which the conflict occurred

OBJECT_TYPE

VARCHAR (6)

Type of object to be locked:

DBC SPACE TABLE INDEX ROW SI-VAL PLAN META

Database catalog Space Base table Index Row of a base table Value of a secondary index SQL plan Metadata area

DBC_NUMBER

SMALLINT

Identification number of the database of
the object to be locked
(for OBJECT_TYPE not equal to PLAN)

NULL value in all other cases

SPACE_ID

SMALLINT

Identification number of the space of the
object to be locked (for OBJECT_TYPE=
SPACE / TABLE / INDEX / ROW / SI-VAL)

NULL value in all other cases

TABLE_ID

SMALLINT

Identification number of the base table of
the object to be locked
(for OBJECT_TYPE = TABLE / ROW)

NULL value in all other cases

INDEX_ID

SMALLINT

Identification number of the index of the
object to be locked (
for OBJECT_TYPE = INDEX / SI-VAL)

NULL value in all other cases

ROW_ID

CHAR (8)

Internal number of the row to be locked
(for OBJECT_TYPE = ROW)

NULL value in all other cases

SI_VALUE

CHAR (8)

Internal presentation of the key value to be
locked
(for OBJECT_TYPE = SI-VAL)

NULL value in all other cases

PLAN_ID

INTEGER

Internal number of the SQL plan to be
locked (for OBJECT_TYPE = PLAN)

NULL value in all other cases

META_SCHEMA

CHAR (8)

Internal number of the schema in the
metadata area which is to be locked
(for OBJECT_TYPE = META)

NULL value in all other cases

META_TABLE

CHAR (8)

Internal number of the base table in the
metadata area which is to be locked
(for OBJECT_TYPE = META)

NULL value in all other cases

HOST_NAME

CHAR (8)

Host name from the identification of the
waiting requesting user

APPLICATION_NAME

CHAR (8)

Application name from the identification of
the waiting requesting user

CUSTOMER_NAME

CHAR (8)

Name of the requesting user from the
identification of the waiting requesting
user

CONVERSATION_ID

CHAR (8)

Identification of the waiting requesting
user with respect to UTM and SESAM-
DBAccess

TAC_NAME

CHAR (8)

Job name of the user ID or name of the
program unit which requested the lock

MODULE_NAME

CHAR (8)

Name of the compilation unit
(SQL only) in which the waiting
SQL statement was executed

NULL value in all other cases

STATEMENT_NAME

VARCHAR (18)

Internal name of the SQL statement which
is waiting for the lock

NULL value in all other cases

STATEMENT_TYPE

VARCHAR (31)

<type of statement> (e.g. INSERT)

In the case of SQL statements

CALL DML: <operation code>

In the case of CALL DML statements

SYSTEM

in the case of system jobs (e.g.
administration commands via SEND-
MSG)

LOCK_MODE

VARCHAR (31)

Level of the lock request:

For OBJECT_TYPE = SPACE:

NO-UPDATE/SHARED-READ,
SHARED-UPDATE/SHARED-READ,
EXCLUSIVE-UPDATE/SHARED-READ,
EXCLUSIVE-UPDATE/EXCLUSIVE-READ

Else:

SHARED, EXCLUSIVE

LOCK_TYPE

VARCHAR (8)

Value of the lock request:
OBJECT for object lock
ADJACENT for environment lock

REQUEST_ANNOUNCED

CHAR (1)

Lock request is to be requested:
Y
N

LOCKING_OBJECT_TYPE

VARCHAR (6)

Type of object which prevents the lock:

DBC SPACE TABLE INDEX ROW SI-VAL PLAN META

Database catalog Space Base table Index Row of a base table Value of a secondary index SQL plan Metadata area

LOCKING_HOST_NAME

CHAR (8)

Host name from the identification of the
locking requesting user

LOCKING_
APPLICATION_NAME

CHAR (8)

Application name from the identification of
the locking requesting user

LOCKING_
CUSTOMER_NAME

CHAR (8)

Name of the requesting user from the
identification of the locking requesting
user

LOCKING_
CONVERSATION_ID

CHAR (8)

Identification of the locking requesting
user with respect to UTM and SESAM-
DBAccess

LOCKING_LOCK_MODE

VARCHAR (31)

Level of the object on which the lock failed:

NO-UPDATE/SHARED-READ,
SHARED-UPDATE/SHARED-READ,
EXCLUSIVE-UPDATE/SHARED-READ,
EXCLUSIVE-UPDATE/EXCLUSIVE-READ

for OBJECT_TYPE = SPACE

else SHARED, EXCLUSIV

Table 117: SYS_LOCK_CONFLICTS view of the SYS_INFO_SCHEMA