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

Backup ok but restore not working

P: n/a
Hello, i'm trying to transfer a DB2 database from a PC to another.
Following suggestion that Mr. Jan M. Nelken and Mr. Pierre Saint-Jacques
give me on this newsgroup i first made a backup of database, the i
transferred the full structure of subdirectories of backup to other PC and
tried to Create database from backup copy as explained in DB2 manual.
I used the visual interface from command center.
I inserted manually the location of backup file, and the restore process
started but one hor later the process is still running !
The restore process writes only 3 Mbytes of data ( the backup file is about
24 Mbytes ).
I stopped the process using task manager then i restart the PC.
The database is listed but obviously it is not working.
So i tried to backup and restore the sample database supplied with DB2 but i
had the same problems ...
I have DB2 5.2 running on Win NT 4.0 and the same DB2 running on WIN 2000
server.
Some suggestions ?
Best regards
Fabio
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Fabius wrote:
Hello, i'm trying to transfer a DB2 database from a PC to another.
Following suggestion that Mr. Jan M. Nelken and Mr. Pierre Saint-Jacques
give me on this newsgroup i first made a backup of database, the i
transferred the full structure of subdirectories of backup to other PC and
tried to Create database from backup copy as explained in DB2 manual.
I used the visual interface from command center.
I inserted manually the location of backup file, and the restore process
started but one hor later the process is still running !
The restore process writes only 3 Mbytes of data ( the backup file is
about
24 Mbytes ).
I stopped the process using task manager then i restart the PC.
The database is listed but obviously it is not working.
So i tried to backup and restore the sample database supplied with DB2 but
i had the same problems ...
I have DB2 5.2 running on Win NT 4.0 and the same DB2 running on WIN 2000
server.
Some suggestions ?
Best regards
Fabio


Fabio,

Unless you have a good reason not to, you should use DB2 V8.2. V5.2 went
out of support years ago, and V6 and V7 are also out of support. I'm even
surprised that V5.2 runs on Win2K !!!

However, casting the mind back years ago, I could never get a V5.2 backup to
restore without creating an empty database first. So I'd give that a try.

db2 "create database dbname on c:\db2data" (or wherever)
db2 "restore database dbname from c:\backupdir taken at timestamp without
rolling forward"

HTH
Phil
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.