Monitoring a load operation using the LIST UTILITIES command

You can use the LIST UTILITIES command to monitor the progress of load operations on a database.

Procedure

To use the LIST UTILITIES command:

Issue the LIST UTILITIES command and specify the SHOW DETAIL parameter:

   list utilities show detail

Example

The following is an example of the output for monitoring the performance of a load operation using the LIST UTILITIES command:

ID                               = 10
Type                             = LOAD
Database Name                    = TEST
Member Number                    = 1
Description                      = OFFLINE LOAD DEL AUTOMATIC INDEXING REPLACE
COPY NO BEER   .TABLE1
Start Time                       = 08/16/2011 08:52:53.861841
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Phase Number                  = 1
      Description                = SETUP
      Total Work                 = 0 bytes
      Completed Work             = 0 bytes
      Start Time                 = 08/16/2011 08:52:53.861865

   Phase Number [Current]        = 2
      Description                = LOAD
      Total Work                 = 49900 rows
      Completed Work             = 25313 rows
      Start Time                 = 08/16/2011 08:52:54.277687

   Phase Number                  = 3
      Description                = BUILD
      Total Work                 = 2 indexes
      Completed Work             = 0 indexes
      Start Time                 = Not Started