DB2 10.5 for Linux, UNIX, and Windows

Monitoring the progress of restore operations

You can use the LIST UTILITIES command to monitor restore operations on a database.

Procedure

Issue the LIST UTILITIES command and specify the SHOW DETAIL parameter

   LIST UTILITIES SHOW DETAIL

Results

For restore operations, an initial estimate is not given. Instead, UNKNOWN is specified. As each buffer is read from the image, the actual number of bytes read is updated. For automatic incremental restore operations where multiple images might be restored, the progress is tracked by using phases. Each phase represents an image to be restored from the incremental chain. Initially, only one phase is indicated. After the first image is restored, the total number of phases will be indicated. As each image is restored the number of phases completed is updated, as is the number of bytes processed.

Example

The following is an example of the output for monitoring the performance of a restore operation:

ID                               = 6
Type                             = RESTORE
Database Name                    = SAMPLE
Partition Number                 = 0
Description                      = db
Start Time                       = 08/04/2011 12:24:47.494191
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
      Completed Work             = 4096 bytes
      Start Time                 = 08/04/2011 12:24:47.494197