By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

how to monitor restore process during rollforward ?

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?

Nov 12 '05 #2

P: n/a
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).

Nov 12 '05 #3

P: n/a
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).

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.