Dropped database restore

[chakriin5]

HI,
I have a database Test. I have a offline backup of it. I dropped it. I want to restore it now. Do I first need to create a new skeleton database to restore my backup copy. Can't I restore it, with out a skeleton database being in place. Please let me know. If u know any commands and links where I can get more information on this, please let me know..
thanks and regards
--chakri

 

[db2forum]

Hi,
You better try with CATALOG DB DATABASE NAME so that ur database will be restored if if u drop it.

and Refer to UNCATALOG DB

hope it may be useful to you


shan

 

[cotaurus]

You can restore without any skeleton:
db2 restore database mytest from <device> taken at <timestamp>
if using TSM:
db2 restore database mytest taken at <timestamp> use tsm

 

[man72]

If you still have the instance intact you can just use
the restore command to restore the DB.