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

restore to another machine fialed

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.