Start of change

DSNT369I *DISPLAY BLOCKERS SUMMARY REPORT* report-time

Explanation

This 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.

The output begins with the following lines:
DSNT360I - ***********************************************************
DSNT369I - *  DISPLAY BLOCKERS SUMMARY REPORT
           *  report-time
DSNT360I - ***********************************************************
DSNT397I -
After line DSNT397I, information that is related to the requested databases is displayed.
When the DISPLAY BLOCKERS command is issued, 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  name1  obid  age (short)2  token  member
  1. An object name or package name ending with an asterisk (*) indicates that the full name exceeds eight characters in length.
  2. The AGE 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 AGE value that is displayed 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.

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

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. If a value is blank or consists of binary zeroes, then the field is not displayed in the report.
                CONNID: conn-id
                CORRID: corr-id
                AGE: age1
                USERID: userid
                LUWID: luw-identifier
                OBJNAME: object-name2
                PKGNAME: package-name2
                STATE: state
                DURATION: duration
                PAGE/RID: page-or-rid
                ACQUIRED: acquired
  1. The entire AGE value is displayed with a maximum length of 27 bytes.
  2. 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.

The output ends with the following lines:
******* DISPLAY BLOCKERS ENDED      **********************
DSN9022I - DSNTDDIS 'DISPLAY BLOCKERS' NORMAL COMPLETION

Error messages and informational messages might also be included in your output. If the number of locks or claims exceeds the maximum number that can be displayed, message DSNT306I is issued.

report-time
The date and time when the report was generated
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.
subtype
The subtype of the lock or claim that is held by a blocking thread. Possible values are:

For locks:

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:

20
WR claim
40
RR claim
60
RR, WR claim
80
CS claim
A0
CS, WR claim
dbname
The name of the database that contains the lock
dbid
The database identifier (DBID) for the database
name
The name of the object (table, index, or table space) that contains the lock
obid
The object identifier (OBID)
age (short) and age
The elapsed time between the beginning of the thread and the execution of the DISPLAY BLOCKERS command, with the following abbreviated keywords:
D
Days
H
Hours
M
Minutes
S
Seconds. Microseconds are represented by up to six decimal digits.
token
The token that is assigned to the thread
member
The Db2 member name
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.
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 Db2 thread identification.
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.
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.
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.
Start of changestateEnd of change
Start of changeThe 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
End of change
duration
The duration of the lock or claim that is held by a blocking thread. Possible values are:

For locks:

20
Manual
21
Manual+1
40
Commit
41
Commit+1
60
Allocation
80
Plan
81
Utility
FE
Interest

For claims:

CM
Commit
CH
Cursor hold
AL
Allocation
acquired
The time when the lock or claim was acquired

System action

Processing continues.

User response

No action is required.

End of change