DB2 10.5 for Linux, UNIX, and Windows

Monitoring a data redistribution operation

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

Procedure

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

   list utilities show detail

Results

The following is an example of the output from this command:

ID                               = 1
Type                             = REDISTRIBUTE
Database Name                    = RDST819
Partition Number                 = 11
Description                      = RDST_V10_015 UNIFORM ADD NODES
                                   COMPACT ON SPACE REUSE RECORD LEVEL
                                   INDEXING MODE INCREMENTAL
Start Time                       = 02-20-2007 23:21:33.785819
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Estimated Percentage Complete = 8
   Summary:
      Total Work                 = 1965600
      Completed Work             = 155221
      Total Number Of Tables     = 15
      Tables Completed           = 0
      Tables In Progress         = 3

   Current Table 1:
      Description                = "NEWTON  "."RDST_V10_015A"
      Total Work                 = 655200 bytes
      Completed Work             = 55001 bytes

   Current Table 2:
      Description                = "NEWTON  "."RDST_V10_015B"
      Total Work                 = 450200 bytes
      Completed Work             = 54220 bytes

   Current Table 3:
      Description                = "NEWTON  "."RDST_V10_015C"
      Total Work                 = 978901 bytes
      Completed Work             = 46000 bytes