-DISPLAY UTILITY command (Db2)

The -DISPLAY UTILITY command 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 for -DISPLAY UTILITY

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

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 for -DISPLAY UTILITY

None is required.

Syntax

Option descriptions for -DISPLAY UTILITY

Use at least one of the following options but do not use the same option more than once.

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

One set of messages is returned for each job identified by the command.

Usage notes for -DISPLAY UTILITY

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.
Trace information for commands issued with group scope: If this command is issued with options that specify group scope in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.

Output for -DISPLAY UTILITY

Message DSNU100I indicates the beginning of the output of the command.

Examples for -DISPLAY UTILITY

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
              STATUS = STOPPED
              JOBNAME = STATSJB
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
                      JOBNAME = STATSJB
                      TIME STARTED = 2014-01-09-10:23:20
 DSNU100I -DB1G DSNUGDIS USER = SAMPID
                      MEMBER = DB2G
                      UTILID = CHKIX1
                      PROCESSING UTILITY STATEMENT 8
                      UTILITY = CHECK
                      PHASE = UNLOAD  COUNT = 0
                      STATUS = STOPPED
                      JOBNAME = CHECKJB
                      TIME STARTED = 2014-01-09-10:30:30
 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
                JOBNAME = REORGJB
                TIME STARTED = 2014-01-09-10:23:20
DSNU347I -DB1G DSNUGDIS - 974
                DEADLINE = NONE
DSNU384I -DB1G DSNUGDIS - 975
                MAXRO = DEFER
                LONGLOG = CONTINUE
                DELAY = 1200 SECONDS
DSNU285I -DB1G DSNUGDIS - 976
                SWITCHTIME = 2014-01-09-14:32:15
                NEWMAXRO = 30 SECONDS
DSNU383I -DB1G DSNUGDIS - CURRENT ITERATION NUMBER = 4 977
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