Error creating tables with DB2
I am installing RTC 3.0 with DB2. I have created the two tables (JTS and CCM) and have modified the teamserver.properties file. When I run repotools-jts -createTables -clean I get an error. It seems to get the connection since I get
CRJAZ1364I The connection to the following database was successful: Db Product Name: DB2/NT Db product Version: SQL09070 Then it says "Creating the tables for the database "//localHost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;" with indices Then Insufficient autthority needed to test case sensitivity of the database The database tables were not created. I'm not sure what this means ... can someone help? I provided the DB2ADMIN userid/password in the teamserver.properties file, and it would seem that it can properly make the connection. Thanks in Advance. |
3 answers
I am installing RTC 3.0 with DB2. I have created the two tables (JTS and CCM) and have modified the teamserver.properties file. When I run repotools-jts -createTables -clean I get an error. It seems to get the connection since I get I dropped and recreated the databases, and it works now. I think I had created them not as DB2ADMIN. Susan |
I am installing RTC 3.0 with DB2. I have created the two tables (JTS and CCM) and have modified the teamserver.properties file. When I run repotools-jts -createTables -clean I get an error. It seems to get the connection since I get I dropped and recreated the databases, and it works now. I think I had created them not as DB2ADMIN. Susan Thanks for the post. I met the same issue and solved it via creating table with user db2admin. Thanks. |
dont forget to follow the steps when you create the table.
db2 connect to <database> db2 grant dbadm on database to user <user> db2 disconnect <database> |
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.