Backup ok but restore not working

[Fabius]

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

[Philip Nelson]

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