How about specifying the "without rolling forward" option when you
restore.

You could also do a "db2 rollforward database <dbname> stop" to the
current DB.

I suppose this should work.


Regards

Anand


-----Original Message-----
From: Balrinder Singh Balwant Singh
[mailto:db2udbdba-ezmlmshield-x39135978.[Email address protected]
Sent: Wednesday, February 28, 2007 8:02 AM
To: LazyDBA Discussion
Subject: RollForward

Hi,



I Need Some advise here, what happen is I did a restore on my DR server
and the restore seems to eb successful. But when I connect to the DB,
and do 'db2 list tablespaces' I noticed that some of the tablespaces
shows "Roll Forward Pending Offline" and some are "Offline".



Please advise me what can I do to solve this.



Thank You In Advance.



Regards,

Bal.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page