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

Explanation

This message is displayed in one of the following circumstances:

• As part of the output from the DISPLAY UTILITY command
• When the REORG INDEX or REORG TABLESPACE utility estimates that the SWITCH phase will not start by the deadline that is specified in the DEADLINE option

In either case, this message is described as part of the DISPLAY UTILITY output in DSNU100I.

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.