Display utilities -- Field and controls
Reading the display output
The display utility output is a series of DSNU... informational
messages. Here is an example:
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
Utilities information
The list of utilities shows the following columns:
-
ID - This identifies a single job by its utility identifier. The utility
can be as simple as userid.jobname.
-
Name - The name of the utility.
-
Status - The status displayed in the returned message is the status at
the time the DB2 utility function received the command. The execution of the utility continues,
therefore the current state of the utility can be different from the state reported.
-
User - Primary authorization identifier.
-
Csect - The name of the section of a job or application that is in control
at the time this window is opened.
-
Member - Identifies utility jobs relating to specific members of the data
sharing group.
-
Statement - The processing statement number.
-
Phase- The name of the utility phase at the time the window is opened.
-
Count - The number of pages or records processed in a utility phase.