468,257 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

restore to another machine fialed

Hi Everyone

NEW USER Q.
I am trying to restore a database backup image to another machine.
Both machines are installed with same DB2 7.2 installation package.

Version: 7, Release: 2, Modification: 5, Service Level: WR21294
Querying the system...
Windows 2000 Version

After restoring and rollforwarding to point in time which are both
successfully, I have this error message when tring to connect
database:

SQL1091C The release number of the database is not valid.
SQLSTATE=08004

My process for restore is this:
1. Copy over backup image and all transaction logs to another machine

on this second machine
2. restore:
db2 RESTORE DATABASE KOUKIA USER db2admin USiNG password FROM
d:\\\\db2bkup TAKEN AT 20040920225100 NEWLOGPATH d:\db2bkup\SQLOGDIR
WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING

3.rollforward:
db2 ROLLFORWARD DATABASE KOUKIA USER db2admin USiNG password TO
2004-09-20-23.00.00

4. Stop rollforward pending status
db2 ROLLFORWARD DATABASE KOUKIA USER db2admin USiNG password complete
On the first machine, I set up online backup.

HELP !

Regards

Andy J
Nov 12 '05 #1
0 1088

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by EggsAckley | last post: by
3 posts views Thread by cerbdog | last post: by
3 posts views Thread by Bill E. | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.