Hi,
if someone can help me on this:
i have dropped my database XYZ and now cannot issue restore command. I tried "list history all for DB XYZ" but i a getting "database alias name or database name XYZ cannot be found"
Any idea?

Thanks.

What is your DB2 version and OS? What is the file name of the backup image?

Andy

I am running DB2 version 7 on WIN2000 and the file name is 010004.001 in a dated folder 20100618.
... CATN0000/20100618/010004.001

thanks.

The timestamp is in the directory name and filename: 2010/06/18 01:00:04.

Andy

Thanks Andy. Now if you don't mind looking at my restore command and the message i am getting.

Thanks a lot.

Also I am having problem to recreate the database I dropped in order to get me restore command working.
Do you have any idea?

It's a device problem. Check db2diag.log for more information.

I am getting exceeding number of processors in one log file.
Also what it the best practice to recreate the same database you dropped?
I should let you know that I am beginer with DB2...

Thanks.

Sorry, I noticed the attachment were not clear in my previous reply.

Can you cd to D:\Backups and do ls?