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.
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.
Perform the following steps before you try to run the database creation or recovery script again:
- Execute the DB2 command …db2 list db directory
- 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>
- Â Execute your database creation or recovery script again.