Hi,

I'm working on DB2 UDB 8.1 for AIX 5.3. I tried to do either db2 drop database mydb or connect to mydb command after I restored mydb from an online backup image using redirected restore. I got the following error:

SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031

so I list the database directory as following:
$ db2 list database directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = JAVAPROD
Database name = JAVAPROD
Local database directory = /db2/longspace/db2prod1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0

Database 2 entry:

Database alias = SAMPLE
Database name = SAMPLE
Local database directory = /home/db2prod1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0

It seems mydb(javaprod) still exists. Does anyone can tell me on how to drop the javaprod from the db2 command line successfully?

Thanks!
Lan

Issue
db2 uncatalog database javaprod

Cheers
Sathyaram

It seems I was able to do uncatalog and catalog the database. but I still can't drop the database. Any idea?

Thanks!
Lan