Start of change

-DISPLAY BLOCKERS (Db2)

The Db2 command DISPLAY BLOCKERS displays locks and claims that active threads hold against the databases that are specified in the command.

Abbreviation: -DIS BL

Environment

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2COMMANDS), an IMS or CICS terminal, or a program using the instrumentation facility interface (IFI).

Authorization

The DISPLAY privilege allows users to obtain information for any database. The resulting DISPLAY BLOCKERS output lists the databases for which the primary authorization ID or any of the secondary authorization IDs has the DISPLAYDB privilege. An error message is produced if the set of privileges for a specified database does not include one of the following privileges or authorities:
  • DISPLAYDB privilege
  • DISPLAY privilege
  • DBMAINT authority
  • DBCTRL authority
  • DBADM authority
  • System DBADM authority
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority
For implicitly created databases, the database privilege or authority can be held on the implicitly created database or on DSNDB04.

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. A logged-on z/OS user ID must be defined in RACF or a similar security server.

Syntax

Read syntax diagramSkip visual syntax diagramDISPLAY BLOCKERS(,database-name*dbname1: dbname2dbname**dbname*dbname**dbstring1*dbstring2*)DETAIL

Option descriptions

(database-name,…)
Identifies one or more databases that you want to display information for. The dbname and dbstring variables can have any of the forms that are listed in the following table, where dbname1 and dbname2 represent any 1- to 8-character string, and dbname represents any 1- to 7-character string:
Table 1. Forms of dbname and dbstring
Form Displays the information of...
dbname1:dbname2 All databases with names, in UNICODE order, that are between dbname1 and dbname2 inclusive
dbname* All databases with names that begin with the string dbname
*dbname All databases with names that end with the string dbname
*dbname* All databases with names that contain the string dbname
*dbstring1*dbstring2* All databases with names that contain the strings dbstring1 and dbstring2
(*)
Displays information about all databases that are defined to the Db2 subsystem for which the privilege set of the process has the required authorization.
DETAIL
Displays additional report information about each lock or claim. If DETAIL is not specified, a basic summary report is produced that displays a maximum of 5,000 locks and claims. When DETAIL is specified, the report displays a maximum of 1,000 locks and claims.

Output

Message DSNT369I indicates the beginning of the command output. For a detailed description of the output, see DSNT369I.

Examples

Displaying summary information about locks and claims that are held against specified databases
The following command displays a basic summary report about locks and claims that are held against the Db2 catalog and directory databases.
-DISPLAY BLOCKERS (DSNDB06,DSNDB01)
The output is similar to this output:
DSNT360I  -DB2A ***********************************
DSNT369I  -DB2A *  DISPLAY BLOCKERS SUMMARY REPORT
                *    2020-02-18-15.21.10.467383
DSNT360I  -DB2A ***********************************
DSNT397I  -DB2A
--------------------------------------------------------------------
REPORT: DISPLAY BLOCKERS REPORT
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
L 02 DSNDB06   0006  SYSUSER   000F  0.013498 S           DB2A
C 80 DSNDB06   0006  DSNKDX02  008E  0.013285 S           DB2A
C 80 DSNDB06   0006  DSNAUH01  0070  0.013285 S           DB2A
C 80 DSNDB06   0006  SYSTSPKD  0812  0.013285 S           DB2A
C 80 DSNDB06   0006  SYSUSER   000F  0.013285 S           DB2A
L 06 DSNDB06   0006  SYSTSPKD  0812  0.012858 S           DB2A
--------------------------------------------------------------------
INFO: DIAGNOSTIC AND INFORMATIONAL MESSAGES
--------------------------------------------------------------------
T DBNAME    MEMBER    INFORMATIONAL DESCRIPTION
- --------  --------  ------------------------------------------
I DSNDB01             NO LOCKS OR CLAIMS FOR THE DATABASE
--------------------------------------------------------------------
DSN9022I  -DB2A DSNZACMD '-DISPLAY BLOCKERS' NORMAL COMPLETION
Displaying summary information about locks and claims that are held against specified databases
The following command displays a basic summary report about locks and claims that are held against the Db2 catalog and directory databases. This report also includes errors that were encountered during command processing because the required IRLM PTF is missing.
-DISPLAY BLOCKERS (DSNDB06,DSNDB01)
The output is similar to this output:
DSNT360I  -DB2A ***********************************
DSNT369I  -DB2A *  DISPLAY BLOCKERS SUMMARY REPORT
                *    2020-02-18-15.22.15.384976
DSNT360I  -DB2A ***********************************
DSNT397I  -DB2A
--------------------------------------------------------------------
ERRORS: ERRORS PROCESSING DISPLAY BLOCKERS
--------------------------------------------------------------------
T DBNAME    MEMBER    ERROR DESCRIPTION
- --------  --------  ------------------------------------------
E           DB2B      MISSING PH16439 - REPORT INCOMPLETE
E           DB2A      MISSING PH16439 - REPORT INCOMPLETE
E           DB2A      MISSING PH16439 - AGE VALUES MAY BE UNKNOWN
--------------------------------------------------------------------
REPORT: DISPLAY BLOCKERS REPORT
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
L 02 DSNDB06   0006  SYSUSER   000F  UNKNOWN              DB2A
C 80 DSNDB06   0006  DSNKDX02  008E  0.238874 S           DB2A
C 80 DSNDB06   0006  DSNAUH01  0070  0.238874 S           DB2A
C 80 DSNDB06   0006  SYSTSPKD  0812  0.238874 S           DB2A
C 80 DSNDB06   0006  SYSUSER   000F  0.238874 S           DB2A
L 06 DSNDB06   0006  SYSTSPKD  0812  UNKNOWN              DB2A
--------------------------------------------------------------------
INFO: DIAGNOSTIC AND INFORMATIONAL MESSAGES
--------------------------------------------------------------------
T DBNAME    MEMBER    INFORMATIONAL DESCRIPTION
- --------  --------  ------------------------------------------
I DSNDB01             NO LOCKS OR CLAIMS FOR THE DATABASE
--------------------------------------------------------------------
DSN9022I  -DB2A DSNZACMD '-DISPLAY BLOCKERS' NORMAL COMPLETION
Displaying detailed information about locks and claims that are held against a specified database
The following command displays a detailed report that includes additional information about locks and claims that are held against the MYDB database.
-DISPLAY BLOCKERS (MYDB) DETAIL
The output is similar to this output:
DSNT360I  -DB2A ***********************************
DSNT369I  -DB2A *  DISPLAY BLOCKERS DETAILED REPORT
                *    2020-02-18-15.29.50.162304
DSNT360I  -DB2A ***********************************
DSNT397I  -DB2A
--------------------------------------------------------------------
REPORT: DISPLAY BLOCKERS REPORT
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
C 80 MYDB      011E  MYTSP     0002  0.177792 S   13      DB2A
               CONNID:  BATCH
               CORRID:  HELLOW5
               AGE:     0.177792 S
               USERID:  SYSADM
               LUWID:   USIBMSY.SYEC1DB2.D6C8DA91FD72=13
               DURATION: CM
               ACQUIRED: 2020-02-18-15.29.49.309431494140
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
L 12 MYDB      011E  MYTSP     0001  0.177676 S   13      DB2A
               CONNID:  BATCH
               CORRID:  HELLOW5
               AGE:     0.177676 S
               USERID:  SYSADM
               LUWID:   USIBMSY.SYEC1DB2.D6C8DA91FD72=13
               PKGNAME: 'MYPKG12345678901234567890.MYPROG.1AD91B511A8'
                        '174F1'
               STATE:   04
               DURATION: 40
               ACQUIRED: 2020-02-18-15.29.49.309514505126
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
L 02 MYDB      011E  MYTSP     0002  0.176087 S   13      DB2A
               CONNID:  BATCH
               CORRID:  HELLOW5
               AGE:     0.176087 S
               USERID:  SYSADM
               LUWID:   USIBMSY.SYEC1DB2.D6C8DA91FD72=13
               STATE:   02
               DURATION: 40
               ACQUIRED: 2020-02-18-15.29.49.310727817626
--------------------------------------------------------------------
T LT DBNAME    DBID  NAME      OBID  AGE (SHORT)  TOKEN   MEMBER
- -- --------  ----  --------  ----  -----------  ------  --------
L 10 MYDB      011E  MYTBL12*  0003  0.175989 S   13      DB2A
               CONNID:  BATCH
               CORRID:  HELLOW5
               AGE:     0.175989 S
               USERID:  SYSADM
               LUWID:   USIBMSY.SYEC1DB2.D6C8DA91FD72=13
               OBJNAME: MYTBL12345678901234567890
               STATE:   02
               DURATION: 40
               ACQUIRED: 2020-02-18-15.29.49.310776630126
--------------------------------------------------------------------
DSN9022I  -DB2A DSNZACMD '-DISPLAY BLOCKERS' NORMAL COMPLETION
End of change