Monitoring a rollforward operation

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

Procedure

Issue the LIST UTILITIES command and specify the SHOW DETAIL parameter
```
   LIST UTILITIES SHOW DETAIL
```
Issue the db2pd command and specify the -recovery parameter:
```
db2pd -recovery
```

Results

For rollforward recovery, there are two phases of progress monitoring: FORWARD and BACKWARD. During the FORWARD phase, log files are read and the log records are applied to the database. For rollforward recovery, when this phase begins UNKNOWN is specified for the total work estimate. The amount of work processed in bytes is updated as the process continues.

During the BACKWARD phase, any uncommitted changes applied during the FORWARD phase are rolled back. An estimate for the amount of log data to be processed, in bytes, is provided. The amount of work processed, in bytes, is updated as the process continues.

Example

The following is an example of the output for monitoring the performance of a rollforward operation using the db2pd command:

Recovery:
Recovery Status     0x00000401
Current Log         S0000005.LOG
Current LSN         0000001F07BC
Current LSO         000002551BEA
Job Type            ROLLFORWARD RECOVERY
Job ID              7
Job Start Time      (1107380474) Wed Feb  2 16:41:14 2005
Job Description     Database Rollforward Recovery
Invoker Type        User
Total Phases        2
Current Phase       1

Progress:
Address            PhaseNum Description StartTime                CompletedWork  TotalWork
0x0000000200667160 1        Forward     Wed Feb  2 16:41:14 2005 2268098 bytes  Unknown
0x0000000200667258 2        Backward    NotStarted               0 bytes        Unknown

The following is an example of the output for monitoring the performance of a database rollforward operation using the LIST UTILITIES command with the SHOW DETAIL option:

ID                               = 7
Type                             = ROLLFORWARD RECOVERY
Database Name                    = TESTDB
Member Number                    = 0
Description                      = Database Rollforward Recovery
Start Time                       = 01/11/2012 16:56:53.770404
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Estimated Percentage Complete = 50
   Phase Number                  = 1
      Description                = Forward
      Total Work                 = 928236 bytes
      Completed Work             = 928236 bytes
      Start Time                 = 01/11/2012 16:56:53.770492

   Phase Number [Current]        = 2
      Description                = Backward
      Total Work                 = 928236 bytes
      Completed Work             = 0 bytes
      Start Time                 = 01/11/2012 16:56:56.886036

The following is an example of the output for monitoring the performance of a table space rollforward operation using the LIST UTILITIES command with the SHOW DETAIL option:

ID                               = 17
Type                             = ROLLFORWARD RECOVERY
Database Name                    = TESTDB
Member Number                    = 0
Description                      = Offline Tablespace Rollforward Recovery: 3
Start Time                       = 01/11/2012 17:04:27.269171
State                            = Executing
Invocation Type                  = User
Progress Monitoring:
   Estimated Percentage Complete = 63
   Phase Number                  = 1
      Description                = Forward
      Total Work                 = 142
      Completed Work             = 90
      Start Time                 = 01/11/2012 17:04:27.269283

   Phase Number [Current]        = 2
      Description                = Backward
      Total Work                 = 0
      Completed Work             = 0
      Start Time                 = Not Started