ENQS
ENQS is a Data Collector command that you can issue from only the command text area of the Data Collector Command Interface panel (DOMECMDA) or from the system operator console.
Use ENQS to display:
- Enqueue conflicts
- All enqueues held or waited for by a specific:
- Job
- Db2 subsystem
Syntax of the ENQS command
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 the command is issued 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 product lists the enqueues for each Db2 address space. |
ALL | (optional) Displays all enqueues held or waited for by the specified job or Db2 subsystem (synonymous with *) |
* | (optional) Displays all enqueues held or waited for by the specified job or Db2 subsystem (synonymous with ALL) |
default | If no parameter is specified after the job name or Db2 subsystem ID, only enqueue conflicts are displayed. |
Sample output from the ENQS command
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).