I've got DB2 v 9.1. I'm doing a db2 list db directory:
Database 10 entry:
Database alias = BRUCE
Database name = BRUCE
Local database directory = /db2_data/database
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Then trying to drop this BRUCE database and get this message:
SQL1013N The database alias name or database name "BRUCE " could
not be found. SQLSTATE=42705
SQL1013N Error:
If the database name appears in the system database directory
and the entry type is INDIRECT, ensure that the database exists
in the specified local database directory. If the entry type is
REMOTE, then ensure that the database exists and is cataloged on
the database directories of the server node.
The database is not in the local database directory. I'm not sure what to do from here. My goal is to remove the BRUCE database.
Thank you.
CC