-DISPLAY BLOCKERS command (Db2)

The DSNT369I message displays output from the DISPLAY BLOCKERS command. The output consists of information about the specified set of databases.

The output from this command has the following general structure. In your output, some of these lines might be included more than once and some might not be included at all. Which lines are included depends on the output being displayed.

DSNT360I - ***********************************************************
DSNT369I - *  DISPLAY BLOCKERS SUMMARY REPORT
           *  report-time
DSNT360I - ***********************************************************
DSNT397I -

T    LT         DBNAME  DBID  NAME   OBID  AGE (SHORT)   TOKEN  MEMBER
---- ---------  ------  ----  ----   ----  -----------   -----  ------  
type subtype    dbname  dbid  name 1 obid  age-short   token  member

Without the DETAIL option, the command displays a maximum of 5,000 locks and claims.

Displaying blockers for a database

When the DISPLAY BLOCKERS command is issued with database input, the output that follows line DSNT397I has the following general format. Each character string is displayed with a maximum length of eight characters.

T    LT         DBNAME  DBID  NAME   OBID  AGE (SHORT)   TOKEN  MEMBER
---- ---------  ------  ----  ----   ----  -----------   -----  ------  
type subtype    dbname  dbid  name   obid  age (short)   token  member

DETAIL option

When you specify the DETAIL option, the output begins with the following lines instead:

DSNT360I - ***********************************************************
DSNT369I - *  DISPLAY BLOCKERS DETAILED REPORT
           *  report-time
DSNT360I - ***********************************************************
DSNT397I -

The output that follows line DSNT397I includes the following additional information.

                CONNID: conn-id
                CORRID: corr-id
                AGE: age
                USERID: userid
                LUWID: luw-identifier
                OBJQUALIFIER: object-qualifier
                OBJNAME: object-name 1
                PKGNAME: package-name 1
                STATE: state
                DURATION: duration
                PAGE/RID: page-or-rid
                ACQUIRED: timestamp

1. An object name or package name that exceeds eight characters in length is displayed in its entirety. Up to three lines of output might be required to display a full name. If more than one line is required, the name is enclosed in single quotation marks (').

With the DETAIL option, the command displays a maximum of 1,000 locks and claims.

For more information about error and information messages that could be included in your output, read the INFO column information in BLOCKING_THREADS table function.

report-type

The type of report, SUMMARY or DETAILED.

report-time

The date and time when the report was generated.

T type

The type of blocker held by the thread. type can have one of the following values:

L

Lock

C

Claim

I

Indicates that the row is for informational purposes.

E

Indicates that an error occurred.

LT subtype

The subtype of the lock or claim that is held by a blocking thread. For locks, the possible values are:

00

Page lock

01

Database lock

02

Page set lock

03

Data set lock (partition)

05

Index compression lock

06

Lock-specific partition

07

Page set or data set open

08

Utility I/O damage assessment

09

Page set piece locks

0A

Database exception table (DBET) entry locks

0D

Buffer manager (BM) SYSLGRNG recording lock or group buffer pool (GBP) conversion dependent lock

0E

Utility serialization lock

0F

Mass delete lock for table

10

Table lock for segmented table space

12

Package lock

18

Row lock

1F

Distributed data facility (DDF) communications database (CDB) P-lock

22

Resource limit facility (RLF) P-lock

27

DBET logical page list (LPL) or group buffer pool recovery pending (GRECP) locks

30

LOB lock

32

LPL recovery lock

36

Serialization lock for adding partitions

39

Load database definition (DBD) lock

3A

Compression dictionary build lock

3B

Compression dictionary load lock

41

Utility catalog access lock

For claims, the possible values are:

20

WR claim

40

RR claim

60

RR, WR claim

80

CS claim

A0

CS, WR claim

DBNAME dbname

The name of the database that contains the lock

DBID dbid

The database identifier (DBID) for the database

NAME name

The name of the object (table, index, or table space) that contains the lock.

OBID obid

The object identifier (OBID).

AGE (SHORT) age-short

AGE age

The elapsed time between the beginning of the thread and the execution of the DISPLAY BLOCKERS command, with the following abbreviated keywords: D for days, H for hours, M for minutes, and S for seconds. Microseconds are represented by up to six decimal digits.

The AGE (SHORT) value is displayed in a shortened format that consists of the two most significant duration values. For example, if a lock has been held for 3 days, 17 hours, 23 minutes, 19 seconds, and 12.49038 microseconds, the displayed AGE value is 3 D 17 H. The locks are still ordered by AGE value from longest to shortest, even if multiple locks have the same shortened AGE value.

In the DETAIL output, the entire AGE value is displayed with a maximum length of 27 bytes.

TOKEN token

The token that is assigned to the thread or blanks for a thread with no token.

MEMBER member

The name of the Db2 data sharing member if applicable. Blanks are displayed if Db2 subsystem is not a data sharing member.

CONNID: conn-id

A connection identifier for the thread. conn-id can have one of the following values:

BATCH

The thread is from a batch region.

TSO

The thread is from a TSO terminal.

UTILITY

The thread is from a utility.

IMS identifier

The thread is from an IMS terminal.

CICS identifier

The thread is from a CICS® terminal.

CONSOLE

The thread is from the console.

The connection name of the thread at the requesting location

The thread is a distributed database access thread that uses system-directed access and or application-directed access from a Version 3 or later Db2 requester.

SERVER

The thread is a distributed database access thread that uses application-directed access from a non-Db2 requester.

CORRID: corr-id

A correlation identifier of the thread that is associated with the space name. corr-id can have one of the following values:

job name

The JCL job name. This value is displayed if the thread is from a batch region.

TSO logon identifier

The TSO logon user ID. This value is displayed if the thread is from a TSO terminal.

pst#.psbname

This value is displayed if the thread is from an IMS terminal.

entry ID.thread number.tran id

This value is displayed if the thread is from a CICS terminal. See Troubleshooting Db2 from CICS.

CONSOLE

This value is displayed if the thread is from the console.

0nn

This value is displayed if the thread is for a system agent. nn is a number.

028.DBAAnn

This value is displayed if the thread is a distributed database access thread that is being created. nn ranges from 01 to 99. This value indicates that the database access agent (DBAA) is in its connection processing. This processing consists of establishing the DBAA thread and validating and verifying the user's ID.

All RACF® requests are serialized on a single Db2 RACF service task, which might increase the validation time when multiple DBAAs are being created concurrently.

The correlation ID of the thread at the requesting location

This value is displayed for an existing distributed database access thread that uses system-directed access or application-direct access from a Db2 requester.

extnam

The first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command that is received as part of the SQL CONNECT. This value is displayed for an existing distributed database access thread that uses application-directed access from a requester that is not Db2.

USERID: user-id

The user ID, which can have one of the following values:

TSO logon identifier

The TSO logon user ID. This value is displayed if the thread is from a TSO terminal.

AXBUSER

This value is displayed if the thread is from an IMS message-driven region and RACF is used.

sign-on ID or LTERM

The user ID that was used to sign on the terminal that is attached to IMS or the logical terminal (LTERM) value. This value is displayed if the thread is from an IMS message-drive region.

PSB name

The program specification block (PSB) name. This value is displayed if the thread is from an IMS nonmessage-driven region and RACF is not used.

user-id, term id, or tran id

The user ID, terminal ID, transaction ID, or other ID, as specified in the resource control table (RCT) if the thread is from CICS.

LUWID:luw-identifier

The logical-unit-of-work identifier of the thread. If the LUW-ID is an '*', the thread has no LUW-ID. If it is not an '*', the value is a logical-unit-of-work-id that is assigned to the thread followed by an '=' sign and a token value, which can be used in place of logical-unit-of-work-id in any Db2 command that accepts logical-unit-of-work-id as input.

STATE: state

The state of the lock that is held by a blocking thread. Possible values are:

01

Unprotected share

02

Intent shared

03

Intent exclusive

04

Shared

05

Update

06

Shared intent exclusive

07

Non-shared update

08

Exclusive

09

Intent exclusive P-lock

0A

Intent shared P-lock

0B

Shared intent exclusive P-lock

DURATION: duration

The duration of the lock or claim that is held by a blocking thread. For locks, the possible values are:

20

Manual

21

Manual+1

40

Commit

41

Commit+1

60

Allocation

80

Plan

81

Utility

FE

Interest

For claims, the possible values are:

CM

Commit

CH

Cursor hold

AL

Allocation

PAGE/RID: page-or-rid

One of the following values in hexadecimal format:

• The page number if the lock is a page lock
• The record ID if the lock is a row lock
• The data set number if the lock is a data set lock
• The partition number if the lock is a partition lock

ACQUIRED: timestamp

The time when the lock or claim was acquired

******* DISPLAY BLOCKERS ENDED      **********************
DSN9022I - DSNTDDIS 'DISPLAY BLOCKERS' NORMAL COMPLETION