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