469,299 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Restore DB2 backup to an old system date

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
1 1618
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.

Similar topics

3 posts views Thread by James | last post: by
3 posts views Thread by butatista | last post: by
4 posts views Thread by Hardy | last post: by
4 posts views Thread by africantract | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.