IBM Support

SQL1005N error trying to create the Tools Database

Question & Answer


Question

When attempting to create your Tools Database (TOOLSDB) the following error is returned. SQL1005N The database alias "TOOLSDB" already exists in either the local database directory or the system database directory. An attempt to drop the TOOLSDB ends successfully; however, the SQL1005N error is still returned upon recreation.

Cause

The Tools Catalog needs to be dropped in conjunction with the Tools Database.

Answer

Run the following commands:

1) Drop Tools Catalog
"db2 drop tools catalog systools in database toolsdb"
(substituting the name of your actual tools catalog if it is different than above)

2) Drop Tools Database
"db2 drop db toolsdb"

3) Stop the DAS
"db2admin stop"

4) Drop the DAS
a) On Windows:
"db2admin drop"
b) On UNIX:
"dasdrop"

5) Recreate the DAS
a) On Windows:
"db2admin create /user:username /password:password" (the DAS will be
associated with the specified user account)
b) On UNIX:
"dascrt -u DASuser" (where DASuser is the user ID under which the DAS will be
created)

6) Start the DAS
"db2admin start"

7) Recreate the tools catalog/database:
"db2 create tools catalog systools create new database toolsdb"

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - CLP","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.2","Edition":"Enterprise;Workgroup","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21240257