Monitoring the progress of restore operations

Monitoring of restore operations can be achieved using the LIST UTILITIES command, or the db2pd -barstats command.

About this task

Using the LIST UTILITIES command:

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

Using the db2pd -barstats command:

Starting in Version 11.1.4.4, the db2pd -barstats command can be used to provide backup and restore monitoring and performance information. See Monitoring backup and restore performance with db2pd -barstats.