I want to test my restore procedure. I'm trying to use DB2 RESTORE DB
FROM X:\...\99999.999 but it just hangs there and does nothing. I can
kill the application. I must reboot the machine. The only thing out of
the ordinary about this database is that I've set up custom tablespaces.

Ideas? It backs up just fine.

Thanks,

Gerald

Gerald Meazell wrote:
[color=blue]
> I want to test my restore procedure. I'm trying to use DB2 RESTORE DB
> FROM X:\...\99999.999 but it just hangs there and does nothing. I can
> kill the application. I must reboot the machine. The only thing out of
> the ordinary about this database is that I've set up custom tablespaces.
>[/color]

You should restore from the same directory you backed up to, not the full
path that's created by the backup.

i.e.:

backup database sample to d:\backups

-- WRONG:
restore database sample from
d:\backups\SAMPLE.0\NODE0000\CATN0000\20030923\094 327.001

-- RIGHT:
restore database sample from d:\backups


Good luck,




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Ian wrote:
[color=blue]
> -- RIGHT:
> restore database sample from d:\backups[/color]

That did it, thanks!

--
Gerald