Hi,

I'm facing some issues when trying to drop the database. Command used:

drop database "AAB"

The following error occurred.

SQL1013N the database alias name or database name "AAB " could not be found. SQLSTATE=42705

I do not know why database name "AAB " has spaces in between it. It should be created as "AAB". Can anyone advise if the syntax and command to drop database with spaces in between it?

Best Regards,
plavinio

A database name is 8 byte in lengths. So DB2 will pad it with spaces in the message. This is nothing you have to worry about.

The actual questions are:
- is your database catalog in the database directory? if not, you may have to catalog it
- if the database is already cataloged, do the files exist in the file system? if not, just uncatalog the database

Hi Knut,

Thanks for the reply. I have managed to fix the issue by executing the following command.

db2 catalog database AAB
db2 drop database AAB

It works successfully

Best Regards,
Plavinio