| re: Backup ok but restore not working
Fabius wrote:
[color=blue]
> 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[/color]
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
| 
