how to monitor restore process during rollforward ?

[t2581]

Hi,
we are daily restore db "PRICE" with rollforward from server A
into PRICE on server B

Usually we restore from backup with timestamp of ~ 02:00 AM and
applying logs till 7 AM (30-50 logs),restore process last 1 1/2 hr.

Sometimes we need to restore till 10-11 am (80-90 log files).
Restore at this case could last up to 5 hrs.

db2diag.log shows only
Restore Complete.
Rollforward has been initiated

Is any way to see name log files already resrored,during rollforward ?
Thanks

Alex

[Ian]

t2***@hotmail.com wrote:

Is any way to see name log files already resrored,during rollforward ?
Thanks

Have you seen ROLLFORWARD DATABASE ... QUERY STATUS?

[Artur]

db2pd -d <your_db> -recovery

Database Partition 0 -- Database BAZA1 -- Active -- Up 0 days 00:09:05

Recovery:
Recovery Status 0x04000401
Current Log S0000015.LOG
Current LSN 000014E703E0
Job Type ROLLFORWARD RECOVERY
[...]

You can use this command when the rollforward is running. The command
ROLLFORWARD DATABASE ... QUERY STATUS is useful when you already
restored some logs, suspended rollforward, and want to check the name
of the next log to be restored (in order to complete or point to
additional logs).

[Artur]

To monitor rollforward process you can use db2 problem determination
command:

db2pd -d <your_db> -recovery

Database Partition 0 -- Database BAZA1 -- Active -- Up 0 days 00:09:05

Recovery:
Recovery Status 0x0400040
Current Log S0000015.LOG <<<<<<< here
Current LSN 000014E703E0
Job Type ROLLFORWARD RECOVERY
Job ID 3
Job Start Time (1127557712) Sat Sep 24 12:28:32 2005
[...]
You can use this command when the rollforward is running. The command
ROLLFORWARD DATABASE ... QUERY STATUS is useful when you already
restored some logs, suspended rollforward, and want to check the name
of the next log to be restored (in order to complete or point to
additional logs).