Problem:

You want to create a database but DB2 issues the message …

SQL1005N  The database alias „<name>“ already exists in either the local
      database directory or system database directory.

Reason:

The alias name specified has already been used. If no alias is specified in the catalog database command, the database name is used as the alias.  When a database is created, the alias name is the same as the database name.

Solution:

Perform the following steps before you try to run the database creation or recovery script again:

1. Execute the DB2 command …db2 list db directory
2. Try to drop or uncatalog the database:a. db2 catalog db <name> as <other_name>

   b. db2 list db directory

   c. db2 drop db <other_name>

   d. If command <db2 DROP …> fails, execute following command:

   db2 uncatalog db <other_name>

   db2 terminate

3.  Execute your database creation or recovery script again.