Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes



3 answers

Permanent link
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.


I dropped and recreated the databases, and it works now. I think I had created them not as DB2ADMIN.

Susan

0 votes


Permanent link
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.


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.

0 votes


Permanent link
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>

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Dec 29 '10, 11:35 a.m.

Question was seen: 9,144 times

Last updated: Dec 29 '10, 11:35 a.m.

Confirmation Cancel Confirm