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"
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21240257