Monitoring backup operations

Monitoring of backup 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 backup operations, an initial estimate of the number of bytes to be processed will be specified. As the backup operation progresses the number of bytes to be processed will be updated. The bytes shown does not correspond to the size of the image and should not be used as an estimate for backup image size. The actual image might be much smaller depending on whether it is an incremental or compressed backup.

Example

The following is an example of the output for monitoring the performance of an offline database backup operation:

ID                               = 3
Type                             = BACKUP
Database Name                    = SAMPLE
Partition Number                 = 0
Description                      = offline db
Start Time                       = 08/04/2011 12:16:23.248367
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Extimated Percentage Complete = 31
      Total Work                 = 123147277 bytes
      Completed Work             = 37857269 bytes
      Start Time                 = 08/04/2011 12:16:23.248377

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.