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