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

Restore DB2 backup to an old system date

P: n/a
Scenario:

1.System date is changed to year 2008, per say Nov 2008
2. An offline backup of DB2 is taken
3. System date is made current ( year 2007 )
4. DB2 database is dropped.

Question : Can i restore the DB2 backup since the system date is old
as per the backup timestamp ?

Appreciate your ideas on this.

Thanks
Naveen
Nov 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
nb*******@gmail.com wrote:
Scenario:

1.System date is changed to year 2008, per say Nov 2008
2. An offline backup of DB2 is taken
3. System date is made current ( year 2007 )
4. DB2 database is dropped.

Question : Can i restore the DB2 backup since the system date is old
as per the backup timestamp ?
My experience is that you are likely to have problems, if you can
even do the restore.

There are some strange ("interesting") side effects when you have
objects in the system catalog that were created in the future.
Nov 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.