-DISPLAY UTILITY (DB2)
The DB2® command DISPLAY UTILITY displays the status of utility jobs, including utility jobs in a data sharing group.
The output from the command consists of informational messages only. One set of messages is returned for each job identified by the command. For utility jobs in a data sharing group, the output shows the member name of the system on which each utility job is running.
The status from the display represents the current status, except in a data sharing group when the utility is running on a member other than the one from which the command is issued. In that case, the status is current as of the last checkpoint.
Abbreviation: -DIS UTIL
Environment
This command can be issued from a z/OS® console, a DSN session, a DB2I panel (DB2 COMMANDS), an IMS™ or CICS® terminal, or a program using the instrumentation facility interface (IFI).
Data sharing scope: Group or member, depending on which option you choose.
To use the DISPLAY UTILITY command for BACKUP SYSTEM on a data sharing group, issue the command from the member on which the BACKUP SYSTEM utility is invoked. Otherwise, the current utility information is not displayed.
Authorization
None is required.
Syntax
>>-DISPLAY UTILITY--(-+-utility-id----------+-)-----------------> +-partial-utility-id*-+ '-*-------------------' >--+---------------------------+------------------------------->< | .-,-----------. | | V | | '-MEMBER(---member-name-+-)-'
Option descriptions
- (utility-id)
- Identifies a single job by its utility identifier, the value given
for the UID parameter when the job was created.
If utility-id was created by the DSNU CLIST by default, it has the form of tso-userid.control-file-name .
If utility-id was omitted when the utility job was created, utility-id has the form userid.jobname.
If utility-id contains lowercase letters or special characters, it must be enclosed in single quotation marks (').
- ( partial-utility-id* )
- Identifies a set of utility jobs. A status message is shown for
each utility identifier that begins with the characters of partial-utility-id .
For example, -DISPLAY UTILITY(ABCD*) shows the status of every utility job known to DB2 whose identifier begins with the characters ABCD.
- (*)
- Shows the status of all utility jobs known to DB2, including jobs currently running in a data sharing group.
- MEMBER ( member-name , ...)
- Restricts the display for the identified utility jobs to specific members of the data sharing group. The default is to display utility jobs running on any member. In a non-data-sharing environment, the option is ignored.
Usage notes
- DISPLAY status
- The status displayed in the returned message is the status at the time the DB2 utility function received the command. Execution has proceeded, therefore the current state of the utility can be different from the state reported. For instance, the DISPLAY UTILITY command can indicate that a particular utility identifier is active, but, when the message is received by the requester, the utility job step could have terminated so that the utility identifier is no longer known to DB2.
- Command response
- In a data sharing environment, messages DSNU100I, DSNU105I, DSNU106I show the name of the member on which the utility job is running. If you specify a single member name in the MEMBER option and that member does not belong to the group, or if you specify a list of member names in the MEMBER option and none of those members belong to the group, the command fails and a message is issued.
Output
Message DSNU100I indicates the beginning of the output of the command.
Examples
- Example: Displaying the status of all utility jobs in a single DB2 subsystem
- The following command displays status information for all utility
jobs that are currently known to a DB2 subsystem.
-DISPLAY UTILITY(*)
The output is similar to the following output.
DSNU100I - DSNUGDIS - USERID = SAMPID MEMBER = UTILID = RUNTS PROCESSING UTILITY STATEMENT 1 UTILITY = RUNSTATS PHASE = RUNSTATS COUNT = 0 STATUS = STOPPED DSN9022I - DSNUGCC '-DISPLAY UTILITY' NORMAL COMPLETION
- Example: Displaying the status of all utility jobs in a DB2 data sharing group
- The following command displays status information for all utility
jobs that are currently known to a DB2 data
sharing group.
-DB1G DISPLAY UTILITY (*)
The output is similar to the following output.
DSNU100I -DB1G DSNUGDIS USER = SAMPID MEMBER = DB1G UTILID = RUNTS PROCESSING UTILITY STATEMENT 1 UTILITY = RUNSTATS PHASE = RUNSTATS COUNT = 0 STATUS = STOPPED DSNU100I -DB1G DSNUGDIS USER = SAMPID MEMBER = DB2G UTILID = CHKIX1 PROCESSING UTILITY STATEMENT 8 UTILITY = CHECK PHASE = UNLOAD COUNT = 0 STATUS = STOPPED DSN9022I -DB1G DSNUGCC '-DB1G DISPLAY UTILITY' NORMAL COMPLETION
- Example: Displaying the status of utilities on a specific data sharing member
- The following command displays the status of utilities on data
sharing member DB1G.
-DB1G DISPLAY UTILITY (*) MEMBER (DB1G)
The output is similar to the following output.
DSNU105I -DB1G DSNUGDIS - USERID = SYSADM 973 MEMBER = DB1G UTILID = REORGCP PROCESSING UTILITY STATEMENT 1 UTILITY = REORG PHASE = LOG COUNT = 0 STATUS = ACTIVE DSNU347I -DB1G DSNUGDIS - 974 DEADLINE = NONE DSNU384I -DB1G DSNUGDIS - 975 MAXRO = DEFER LONGLOG = CONTINUE DELAY = 1200 SECONDS DSNU383I -DB1G DSNUGDIS - CURRENT ITERATION NUMBER = 4 976 WRITE ACCESS ALLOWED IN THIS ITERATION = YES ITERATION BEFORE PREVIOUS ITERATION: ELAPSED TIME = 00:00:00 NUMBER OF LOG RECORDS PROCESSED = 0 PREVIOUS ITERATION: ELAPSED TIME = 00:00:00 NUMBER OF LOG RECORDS PROCESSED = 0 CURRENT ITERATION: ESTIMATED ELAPSED TIME = 00:00:00 ACTUAL ELAPSED TIME SO FAR = 00:00:00 ACTUAL NUMBER OF LOG RECORDS BEING PROCESSED = 0 CURRENT ESTIMATE FOR NEXT ITERATION: ELAPSED TIME = 00:00:00 NUMBER OF LOG RECORDS TO BE PROCESSED = 0 DSN9022I -DB1G DSNUGCC '-DIS UTIL' NORMAL COMPLETION