Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Pool Advisor for Db2 13.1.

ENQS

ENQS is a Data Collector command that you can issue only from the command text area of the Data Collector Command Interface panel (DOMECMDA) or from the system operator console.

ENQS displays enqueue conflicts or all enqueues that a specific job or Db2 subsystem is holding or waiting for. 

Syntax of the ENQS command

GUID-665E98D7-2058-4BD0-BBC9-50276D7BB653-low.png

Parameter

Description

DCssid

Subsystem ID of the Data Collector examined for enqueues. Use this parameter only when you issue the command from the console. When you issue the command from the Data Collector Command Interface panel, it applies automatically to the currently selected Data Collector.

jobName

Name of the job to examine for enqueues

DB2ssid

Subsystem ID of the Db2 subsystem to examine for enqueues. The command lists enqueues for each Db2 address space.

ALL

((Optional) Displays all enqueues that a specific job or Db2 subsystem is holding or waiting for (synonymous with *)

*

(Optional) Displays all enqueues that a specific job or Db2 subsystem is holding or waiting for (synonymous with ALL).

default

If no parameter is specified after the job name or Db2 subsystem ID, the command displays only enqueue conflicts.

Sample output from the ENQS command

DOMECMDO/P                     Command Interface                 LINE 1 OF 128
 Command ====> _______________________________________________ Scroll ===> CSR_
 BMC24237 Press Enter to reissue the last command                              
                                                                 More:     +   
   ENQ:Job  Own Wait Type ..MAJOR  MINOR..                                     
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.BSDS01.DATA                     
   DBY1MSTR 001 000  SHR  SYSDSN   DSNDBY.DBY1.BSDS01                          
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.BSDS01.INDEX                    
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY2.DS01.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY2.DS0X.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY1.DS01.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY2.DS0X.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY1.DS01.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.BSDS02.DATA                     
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY2.DS01.DATA              
   DBY1MSTR 001 000  SHR  SYSDSN   DSNDBY.DBY1.LOGCOPY1.DS02                   
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.BSDS01.DATA                     
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY2.DS04.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY1.DS02.DATA              
   DBY1MSTR 001 000  SHR  SYSVSAM  DSNDBY.DBY1.LOGCOPY1.DS0X.DATA              
   DBY1MSTR 001 000  SHR  SYSDSN   DSNDBY.DBY1.LOGCOPY1.DS04                   
   DBY1MSTR 001 000  SHR  SYSDSN   DSNDBY.DBY1.LOGCOPY1.DS01

 You can find information about issuing commands from the Data Collector Command Interface panel in online Help (type HELP DOMECMDA).

Related topic

Command-and-syntax-reference


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*