Start of change

DSNU100I csect-name USERID = user-id MEMBER = member-name UTILID = util-id PROCESSING UTILITY STATEMENT statement-number UTILITY = utility-name PHASE = utility-phase COUNT = object-count NUMBER OF OBJECTS IN LIST = list-size LAST OBJECT STARTED = last-started STATUS = STOPPED JOBNAME = job-name TIME STARTED = time-started

Explanation

This message displays output from the DISPLAY UTILITY command.

The DISPLAY UTILITY output begins with one of the following messages, depending on the status of the first utility that is reported:

DSNU100I - A stopped utility
This message is displayed if the utility is stopped.
DSNU105I - An active utility
This message is displayed if the utility is active.
DSNU106I - A terminating utility
This message is displayed if the utility is in the process of terminating.

The initial DSNU100I, DSNU105I, or DSNU106I message can be followed by additional instances of these messages depending on the qualifying utility jobs.

The initial status messages are followed by one or more of the following messages:

The following sections explain each of the messages that might be issued as a result of running the DISPLAY UTILITY command:

DSNU100I - A stopped utility

Message DSNU100I is displayed for each instance of a stopped utility. 

DSNU100I  csect-name USERID = user-id
                MEMBER = member-name           
                UTILID = util-id                
                PROCESSING UTILITY STATEMENT statement-number
                UTILITY = utility-name         
                PHASE = utility-phase   COUNT = object-count
                NUMBER OF OBJECTS IN LIST = list-size
                LAST OBJECT STARTED = last-started
                STATUS = STOPPED                               
                JOBNAME = job-name             
                TIME STARTED = time-started

The specified utility job stopped during processing for one of the following reasons:

  • The utility is REORG INDEX or REORG TABLESPACE, and the UNLOAD(PAUSE) option was specified. This option causes the utility to stop after it unloads the data. Therefore, the utility is stopped in the RELOAD phase.
  • A Db2 subsystem failure or cancellation occurred. For example, a cancellation occurs if you issue the STOP DB2 command.
csect-name
The name of the control section that issued the message.
user-id
The user ID that ran the utility job.
member-name
The name of the Db2 member in a data-sharing environment. In a non-data-sharing environment, member-name is blank.
util-id
The utility ID.
statement-number
The utility statement number.
utility-name
The name of the utility.
utility-phase
The phase in which the utility is to be restarted if the utility job step is restarted with the RESTART(PHASE) option. This value applies only to utilities that have phases.
object-count
The number of objects that were processed in a utility phase. The object-count field is relevant only to the following utilities:
CHECK INDEX, LOAD, REBUILD INDEX, REORG INDEX, and REORG TABLESPACE:
The object-count field indicates the number of records that were processed. For the LOG phase of REORG INDEX and REORG TABLESPACE, this value indicates the number of log records that were processed. For the SWITCH phase of REORG INDEX and REORG TABLESPACE, this value is 0.
COPY, MERGECOPY, RECOVER (RESTORE phase), and RUNSTATS:
The object-count field indicates the number of pages that were processed.
RECOVER (PRELOGA, LOGAPPLY, LOGUNDO phases):
The object-count field indicates the number of log records that were applied at the last commit interval.
STOSPACE:
The object-count field indicates the number of table spaces or indexes that were processed.

For all other utilities, ignore the object-count field.

In a data sharing environment, the count is current when the command is issued from the same member on which the utility is executing. When the command is issued from a different member, the count might lag substantially. For some utilities in some build phases, the count number is not updated when the command is issued from a different member.

list-size
If the utility is processing a list of objects, the total number of objects in the list. This value might not be accurate in the UTILINIT phase, which occurs before the list size is determined.
last-started
If the utility is processing a list of objects, the item number of the last object for which processing started. This value might not be accurate in the UTILINIT phase, which occurs before the list size is determined.

For the RECOVER utility in the RESTORE phase, last-started is a count of objects that were either started or completed at the last commit point. For the RECOVER utility in the log processing phases (PRELOGC, PRELOGA, LOGAPPLY, LOGCSR, and LOGUNDO), last-started is the count of objects being processed. For RESTART in the RESTORE phase, last-started is a count of objects that were either started or completed during the restart invocation.

job-name
The name of the job that invoked the utility. If a stored procedure invoked the utility, this value is the job name in the JCL that started the WLM-managed stored procedure address space.
time-started
The date and time when the utility started. The format is YYYY-MM-DD-HH:MM:SS.
Related information:

DSNU105I - An active utility

Message DSNU105I is displayed for each instance of an active utility. 

DSNU105I  csect-name USERID = user-id
                MEMBER = member-name             
                UTILID = util-id                  
                PROCESSING UTILITY STATEMENT statement-number
                UTILITY = utility-name           
                PHASE = utility-phase   COUNT = object-count
                NUMBER OF OBJECTS IN LIST = list-size 
                LAST OBJECT STARTED = last-started
                STATUS = ACTIVE                                  
                JOBNAME = job-name               
                TIME STARTED = time-started

In addition to being part of the DISPLAY UTILITY output, message DSNU105I can also be displayed when you run the REORG INDEX or REORG TABLESPACE utility. In these cases, this message is displayed when either of these utilities estimates that the SWITCH phase will not start before the deadline that is specified in the DEADLINE option. The information in the message reflects the state at the time that this event occurred.

csect-name
The name of the control section that issued the message.
user-id
The user ID that ran the utility job.
member-name
The name of the Db2 member in a data-sharing environment. In a non-data-sharing environment, member-name is blank.
util-id
The utility ID.
statement-number
The utility statement number.
utility-name
The name of the utility.
utility-phase
The phase in which the utility was executing when this message was issued. This value applies only to utilities that have phases.
object-count
The number of objects that were processed in a utility phase. The object-count field is relevant only to the following utilities:
CHECK INDEX, LOAD, REBUILD INDEX, REORG INDEX, and REORG TABLESPACE:
The object-count field indicates the number of records that were processed. For the LOG phase of REORG INDEX and REORG TABLESPACE, this value indicates the number of log records that were processed. For the SWITCH phase of REORG INDEX and REORG TABLESPACE, this value is 0.
COPY, MERGECOPY, RECOVER (RESTORE phase), and RUNSTATS:
The object-count field indicates the number of pages that were processed.
RECOVER (PRELOGA, LOGAPPLY, LOGUNDO phases):
The object-count field indicates the number of log records that were applied at the last commit interval.
STOSPACE:
The object-count field indicates the number of table spaces or indexes that were processed.

For all other utilities, ignore the object-count field.

In a data sharing environment, the count is current when the command is issued from the same member on which the utility is executing. When the command is issued from a different member, the count might lag substantially. For some utilities in some build phases, the count number is not updated when the command is issued from a different member.

list-size
If the utility is processing a list of objects, the total number of objects in the list. This value might not be accurate in the UTILINIT phase, which occurs before the list size is determined.
last-started
If the utility is processing a list of objects, the item number of the last object for which processing started. This value might not be accurate in the UTILINIT phase, which occurs before the list size is determined.

For the RECOVER utility in the RESTORE phase, last-started is a count of objects started. If the DISPLAY UTILITY command is executed from a different data sharing member from the member where RECOVER is executed, the count of objects processed remains zero until a commit interval is reached. For the RECOVER utility in the log processing phases (PRELOGC, PRELOGA, LOGAPPLY, LOGCSR, and LOGUNDO), last-started is the count of objects that are being processed. For RESTART in the RESTORE phase, last-started is a count of objects that were either started or completed during the restart invocation.

job-name
The name of the job that invoked the utility. If a stored procedure invoked the utility, this value is the job name in the JCL that started the WLM-managed stored procedure address space.
time-started
The date and time when the utility started. The format is YYYY-MM-DD-HH:MM:SS.
Related information:

DSNU106I - A terminating utility

Message DSNU106I is displayed for each instance of a utility that is in the process of terminating when the DISPLAY UTILITY command is issued. The utility is terminating in response to a TERM UTILITY command request.

If the utility has already terminated, no message is issued.

DSNU106I  csect-name utility-name UTILITY, 
                MEMBER = member-name 
                UTILID = util-id TERMINATING
csect-name
The name of the control section that issued the message.
utility-name
The name of the utility.
util-id
The utility ID.
member-name
The name of the Db2 member in a data-sharing environment. In a non-data-sharing environment, member-name is blank.
Related information:

DSNU107I - Invalid member name

Message DSNU107I is displayed if an invalid member name was specified in the MEMBER option of the DISPLAY UTILITY command. Db2 ignores the invalid member name and continues to process the next member name that was specified.

DSNU107I  csect-name  MEMBER NAME member-name IS NOT A MEMBER OF THIS DATA SHARING GROUP.
csect-name
The name of the control section that issued the message.
member-name
The invalid member name.

DSNU108I - Invalid use of the MEMBER option

Message DSNU108I is displayed when the DISPLAY UTILITY command is issued with the MEMBER option and data sharing is not active. If data sharing is not active, MEMBER is not a valid option. Db2 ignores the MEMBER option and its parameters and continues processing.

DSNU108I  csect-name  DATA SHARING ENVIRONMENT IS NOT ACTIVE, MEMBER KEYWORD NOT APPLICABLE.
csect-name
The name of the control section that issued the message.

DSNU111I - Subtask information

If the utility is using subtasks to process work in parallel, message DSNU111I provides an estimate of how much processing the utility subtask has completed. This message immediately follows a DSNU105I message. One DSNU111I message is displayed for each subtask.

In a data-sharing environment, this message is issued only when the DISPLAY UTILITY command is entered on the same member where the utility is executing. 

DSNU111I  csect-name - SUBPHASE=subphase-name COUNT=object-count
csect-name
The name of the control section that issued the message.
subphase-name
The activity that the subtask was performing at the time that the DISPLAY UTILITY command was issued.
object-count
The number of records that were processed by the utility subtask.

DSNU116I - RECOVER utility LOGAPPLY phase

This message applies only to the RECOVER utility. If the RECOVER utility is in the LOGAPPLY phase, message DSNU116I provides information about how much processing RECOVER has completed in this phase.

DSNU116I csect-name - RECOVER LOGAPPLY PHASE DETAILS: 
                      STARTING TIME = start-time
                      START RBA = start-rba START LRSN = start-lrsn
                      END RBA = end-rba     END LRSN = end-lrsn
                      LAST COMMITTED RBA/LRSN = last-committed
                      ELAPSED TIME = elapsed-time
csect-name
The name of the control section that issued the message.
start-time
The time that the LOGAPPLY phase started.
start-rba and end-rba
The relative byte address (RBA) of the first and last log records in the range of log records that are to be applied. The range accounts for all objects in the list of objects to be recovered. In a data-sharing environment, these values are a series of zeros.
start-lrsn and end-lrsn
In a data-sharing environment, the log record sequence number (LRSN) of the first and last log records in the range of log records that are to be applied. The range accounts for all objects in the list of objects to be recovered.
last-committed
The RBA or LRSN of the last log record that was applied at the last commit point in the LOGAPPLY phase.

This value might not increase if multiple DISPLAY UTILITY commands are issued consecutively because the log records are sorted by object and page number.

elapsed-time
The time that has elapsed since the start of the LOGAPPLY phase. The elapsed time is expressed in the format hh:mm:ss.
Related information:

DSNU347I - Deadline information for REORG INDEX or REORG TABLESPACE

Message DSNU347I displays the most recently specified value of the DEADLINE option for the REORG INDEX or REORG TABLESPACE utility. A previous invocation of the ALTER UTILITY command might have specified a value for DEADLINE. If not, the most recently specified value is the value that was specified with the invocation of REORG INDEX or REORG TABLESPACE.

This message is displayed if all of the following conditions are true:

  • The utility is REORG INDEX or REORG TABLESPACE.
  • The SHRLEVEL REFERENCE or SHRLEVEL CHANGE option was specified.
  • The utility is active, as indicated by the DSNU105I message.

In addition to being part of the DISPLAY UTILITY output, message DSNU347I can also be displayed when you run REORG INDEX or REORG TABLESPACE. In these cases, this message is displayed when either of these utilities estimates that the SWITCH phase will not start before the deadline that is specified in the DEADLINE option. The information in the message reflects the state at the time that this event occurred.

DSNU347I csect-name 
         DEADLINE = yyyy-mm-dd-hh.mm.ss.mmmmmm
csect-name
The name of the control section that issued the message.
yyyy-mm-dd-hh.mm.ss.mmmmmm
The timestamp value of the DEADLINE option.
Related information:

DSNU383I - LOG phase information for REORG INDEX or REORG TABLESPACE

Message DSNU383I provides information about the LOG phase for the REORG INDEX or REORG TABLESPACE utility. It provides an estimate of how far the utility has proceeded in the indicated utility job step.

This message is displayed if all of the following conditions are true:

  • The utility is REORG INDEX or REORG TABLESPACE.
  • The SHRLEVEL CHANGE option was specified.
  • The utility is active, as indicated by the DSNU105I message.
  • The utility is in the LOG phase.

In addition to being part of the DISPLAY UTILITY output, message DSNU383I can also be displayed when you run REORG INDEX or REORG TABLESPACE. In these cases, this message is displayed when either of these utilities estimates that the SWITCH phase will not start before the deadline that is specified in the DEADLINE option. The information in the message reflects the state at the time that this event occurred.

DSNU383I csect-name CURRENT ITERATION NUMBER = nnnnnn 
WRITE ACCESS ALLOWED IN CURRENT ITERATION = www 
ITERATION BEFORE PREVIOUS ITERATION: 
   ELAPSED TIME = ha:ma:sa
   NUMBER OF LOG RECORDS PROCESSED = nnnnna 
PREVIOUS ITERATION:  
   ELAPSED TIME = hb:mb:sb 
   NUMBER OF LOG RECORDS PROCESSED = nnnnnb 
CURRENT ITERATION: 
   ESTIMATED ELAPSED TIME = hc:mc:sc 
   ACTUAL ELAPSED TIME SO FAR = hd:md:sd   
   ACTUAL NUMBER OF LOG RECORDS BEING PROCESSED = nnnnnd 
CURRENT ESTIMATE FOR NEXT ITERATION:
   ELAPSED TIME = he:me:se  
   NUMBER OF LOG RECORDS TO BE PROCESSED = nnnnne
csect-name
The name of the control section that issued the message.
nnnnnn
The current iteration number.
www
An indication of whether write access is allowed in the current iteration of log processing. Possible values are YES or NO.
ha:ma:sa
The elapsed time for the iteration before the previous iteration. If the current iteration number is 1 or 2, this value is 00:00:00
nnnnna
The number of log records that were processed in the iteration before the previous iteration. If the current iteration number is 1 or 2, this value is 0.
hb:mb:sb
The elapsed time for the previous iteration. If the current iteration number is 1, this value is 00:00:00.
nnnnnb
The number of log records that were processed in the previous iteration. If the current iteration number is 1, this value is 0.
hc:mc:sc
The estimated elapsed time for the current iteration.
hd:md:sd
The elapsed time for the current iteration.
nnnnnd
The actual number of log records that are being processed for the current iteration.
he:me:se
The currently estimated elapsed time for the next iteration.
nnnnne
The currently estimated number of log records to be processed for the next iteration.
Related information:

DSNU384I - MAXRO, LONGLOG, and DELAY information for REORG INDEX or REORG TABLESPACE

Message DSNU384I displays the most recently specified values of certain options for the REORG INDEX or REORG TABLESPACE utility. A previous invocation of the ALTER UTILITY command might have specified a value for each option. If not, the most recently specified value is the value that was specified with the invocation of REORG INDEX or REORG TABLESPACE.

This message is displayed if all of the following conditions are true:

  • The utility is REORG INDEX or REORG TABLESPACE.
  • The SHRLEVEL CHANGE option was specified.
  • The utility is active, as indicated by the DSNU105I message.

In addition to being part of the DISPLAY UTILITY output, message DSNU384I can also be displayed when you run REORG INDEX or REORG TABLESPACE. In these cases, this message is displayed when either of these utilities estimates that the SWITCH phase will not start before the deadline that is specified in the DEADLINE option. The information in the message reflects the state at the time that this event occurred.

DSNU384I csect-name -  
         MAXRO = maxro-value SECONDS 
         LONGLOG = longlog-value 
         DELAY = delay-value SECONDS
csect-name
The name of the control section that issued the message.
maxro-value
The most recently specified value of the MAXRO option. Possible values are an integer or DEFER.
longlog-value
The most recently specified value of the LONGLOG option. Possible values are CONTINUE, TERM, or DRAIN.
delay-value
The most recently specified value of the DELAY option. The value is an integer.

For more information about these option values, see the option descriptions in the REORG INDEX or REORG TABLESPACE syntax information.

Related information:

DSNU285I - SWITCHTIME and NEWMAXRO information for REORG INDEX or REORG TABLESPACE

Message DSNU285I displays the specified values of SWITCHTIME and NEWMAXRO for the REORG INDEX or REORG TABLESPACE utility.

This message is displayed if all of the following conditions are true:

  • The utility is REORG INDEX or REORG TABLESPACE.
  • Utility execution includes a LOG phase, and message DSNU384I is issued.
  • The utility is active, as indicated by the DSNU105I message.

In addition to being part of the DISPLAY UTILITY output, message DSNU384I can also be displayed when you run REORG INDEX or REORG TABLESPACE. In that case, message DSNU285I is displayed when the utility estimates that the SWITCH phase will not start by the deadline that is specified in the DEADLINE option. The information in the message reflects the state at the time that this event occurred.

DSNU285I csect-name -
         SWITCHTIME = switchtime-value 
         NEWMAXRO = newmaxro-value SECONDS
csect-name
The name of the control section that issued the message.
switchtime-value
The specified value of the SWITCHTIME option. Possible values are a timestamp in the format yyyy-mm-dd-hh.mm.ss.mmmmmm, or NONE.
newmaxro-value
The specified value of the NEWMAXRO option. Possible values are an integer, or NONE.
Related information:

DSN9022I - Normal completion

When the DISPLAY UTILITY command ends normally, message DSN9022I is issued.

In a non-data-sharing environment, this message is presented in the following format:

DSN9022I - DSNUGCC  '-DISPLAY UTILITY' NORMAL COMPLETION

In a data-sharing environment, this message is presented in the following format:

DSN9022I -DB1G DSNUGCC '-DIS UTIL' NORMAL COMPLETION
Related information:

System action

In most cases, processing continues with the following exceptions:

  • For each DSNU100I message, Db2 waits for directions to either restart or terminate the utility.
  • For each DSNU105I message that was issued because REORG INDEX or REORG TABLESPACE estimated that the SWITCH phase will not start before the specified deadline, reorganization terminates with message DSNU374I.
  • For each DSNU106I message, the utility stops and releases all resources that are associated with the utility. After the utility terminates, Db2 can reuse the utility ID.

Operator response

For each DSNU100I message, if you need to release the resources that are claimed by the stopped utility, terminate the utility by issuing the TERM UTILITY command.

User response

The appropriate user response varies depending on the messages that are issued.

  • For each DSNU100I message, restart or terminate the utility job step. To restart the job step, follow the directions in Restarting an online utility. You must have authority to run the indicated utility and to complete any other utility functions in the utility job step. To terminate the utility, issue the TERM UTILITY command. You must be the originator or have SYSOPR or SYSADM authority.
  • For each DSNU105I message that was issued by REORG INDEX or REORG TABLESPACE, take the actions that are listed in DSNU374I.
  • For each DSNU107I message, correct the member name and reissue the DISPLAY UTILITY command.
  • For the DSNU108I message, make sure that data sharing is active before issuing the DISPLAY UTILITY command with the MEMBER option.
  • In all other cases, no action is necessary.

If you issue a subsequent DISPLAY UTILITY command, any additional processing is reflected in the output. The output also includes any updates to the DEADLINE, MAXRO, LONGLOG, or DELAY options that were made by an ALTER UTILITY command.

Severity

For DSNU107I and DSNU108I:

4 (warning)

For all other DISPLAY UTILITY output messages:

0 (informational)

End of change