SQL1005N The database alias "JTS" already exists
Tryiing to install CLM 3.0.1 on Windows, After install I am looking to NOT use tomcat and derby but go right to WAS and DB(9.7) yet getting an error
on database creation(reported previously on https://jazz.net/forums/viewtopic.php?t=10830&sid=4a4f5ffbd6948e32672b591db4f99a09 yet admin just reinstalled..: db2 => create database JTS using codeset UTF-8 territory en PAGESIZE 16384 SQL1005N The database alias "JTS" already exists in either the local database directory or system database directory. yet I cannot connect or drop said database... db2 => drop database JTS SQL1013N The database alias name or database name "JTS " could not be found. SQLSTATE=42705 The same occurs for CCM, yet I can create a QM and DW Database. db2 => list database directory System Database Directory Number of entries in the directory = 2 Database 1 entry: Database alias = DW Database name = DW Local database directory = C: Database release level = b.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 2 entry: Database alias = QM Database name = QM Local database directory = C: Database release level = b.00 Comment = Jazz Team Server Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Does derby create any entries that would possibly conflict with DB2 ? |
3 answers
Ralph Schoon (63.3k●3●36●46)
| answered Sep 30 '11, 7:33 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Fred,
I have never seen such a phenomenon. Maybe there are hints in DB2 related forums. Which OS are you using? Have you considered to give the databases a different alias? The name really does not matter. According to the post you reference it seems to be not trivial to get rid of the database if the catalog contains it when it should not. Derby does not have anything to do with the DB2 catalog, you won't get any side effect from it. You could check if there are folders for the databases in the table space folder. |
Tryiing to install CLM 3.0.1 on Windows, After install I am looking to NOT use tomcat and derby but go right to WAS and DB(9.7) yet getting an error |
Fred,
I'd suggest looking in the file system for directories that could relate to this db. in a db2 command window: db2 get dbm cfg and look for "Default database path" Then look for folders in that location named jts or JTS. You could rename those or if empty just remove them. Tryiing to install CLM 3.0.1 on Windows, After install I am looking to NOT use tomcat and derby but go right to WAS and DB(9.7) yet getting an error |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
You may created the same name of DB previously, but now it has been dropped, but the information is still in catalog...
So do following...
$ db2 list db directory
your db is listed
$ db2 drop db <your_db>
if it fails..
$ db2 uncatalog db <your_db>
$ db2 list db directory
your db is gone
Then try to create a db again