Can't create DB2 tables: Exception testing case sensitivity
Anyone know what I need to do here (or what to tell our DBA's to do for me)? I'm running into a case sensitivity issue when trying to create DB2 tables (UDB 9.1 on AIX).
Error = Sql Exception thrown while testing case sensitivity of the database.
The full transcript from the script exectuion is below:
$ ./repotools.sh -createTables
Repo Tools
Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Provisioning using "./conf/jazz/provision_profiles".
Rational Jazz Team Server - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09015
Db URL: jdbc:db2://t002ppmdb:60096/jazz
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database "//t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;" with indices.
Sql Exception thrown while testing case sensitivity of the database
The database tables were not created.
Error = Sql Exception thrown while testing case sensitivity of the database.
The full transcript from the script exectuion is below:
$ ./repotools.sh -createTables
Repo Tools
Rational Team Concert, Version 2.0 (I20090618-1753)
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Provisioning using "./conf/jazz/provision_profiles".
Rational Jazz Team Server - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09015
Db URL: jdbc:db2://t002ppmdb:60096/jazz
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database "//t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;" with indices.
Sql Exception thrown while testing case sensitivity of the database
The database tables were not created.
15 answers
I tried RQM 2.0.0.1 ifix with DB 9.7 WKGP edition. I ran into the same exception message from repotools.
The other posts were helpful. But it took me a while to figure out how to fix the security problem. Its in the permissions for the database in DB2. In control center, right click on the database you created. Select Authorities..
You'll see a table of permissions per-user. Add the db2admin account to the table. Hit Grant all. Click ok.
Now when you go re-run repotools -createTables you should get past the problem.
The other posts were helpful. But it took me a while to figure out how to fix the security problem. Its in the permissions for the database in DB2. In control center, right click on the database you created. Select Authorities..
You'll see a table of permissions per-user. Add the db2admin account to the table. Hit Grant all. Click ok.
Now when you go re-run repotools -createTables you should get past the problem.
I found something that describes the problem and resolution:
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
Wondering if the System ID requires System Admin authority is required after the database tables have been created? In our org we typically do not give application ID's these full System Admin (DBA) authority.
Steve
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
Wondering if the System ID requires System Admin authority is required after the database tables have been created? In our org we typically do not give application ID's these full System Admin (DBA) authority.
Steve
Hi,
I followed the steps described at following link but still getting the same problem. Could someone please help me?
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
regards
Zeeshan
Toronto Lab, IBM
I followed the steps described at following link but still getting the same problem. Could someone please help me?
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
regards
Zeeshan
Toronto Lab, IBM
I found something that describes the problem and resolution:
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
Wondering if the System ID requires System Admin authority is required after the database tables have been created? In our org we typically do not give application ID's these full System Admin (DBA) authority.
Steve
I am having this problem with RTC 2.0.0.1 Express-C and DB2 9.7 Express-C. It does show this as supported database.
Hi,
I followed the steps described at following link but still getting the same problem. Could someone please help me?
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
regards
Zeeshan
Toronto Lab, IBM
I found something that describes the problem and resolution:
http://www-01.ibm.com/support/docview.wss?rs=3488&context=SSCP65&dc=DB560&dc=DB520&uid=swg21381196&loc=en_US&cs=UTF-8&lang=en&rss=ct3488rational
Wondering if the System ID requires System Admin authority is required after the database tables have been created? In our org we typically do not give application ID's these full System Admin (DBA) authority.
Steve
I am also having the same problem.
I am using RTC 2 Standard and DB2 9.7 Express-C. The database is installed and running, the config files for the Jazz server are updated and I changed the user settings to include the Group DB2ADMNS. But the repotool does not run through and ends with the same error message as above (but in german).
Anyone have an idea?
I am using RTC 2 Standard and DB2 9.7 Express-C. The database is installed and running, the config files for the Jazz server are updated and I changed the user settings to include the Group DB2ADMNS. But the repotool does not run through and ends with the same error message as above (but in german).
Anyone have an idea?
I faced the same issue.
It seems that the problem comes from the fact that I was using DB2 9.7 instead of DB2 9.5.
I grabbed the release 9.5 from this page:
https://jazz.net/downloads/DB2/releases/9.5FP3-WSE/
And installed it...
The issue didn't show up anymore...
I hope it will help you.
It seems that the problem comes from the fact that I was using DB2 9.7 instead of DB2 9.5.
I grabbed the release 9.5 from this page:
https://jazz.net/downloads/DB2/releases/9.5FP3-WSE/
And installed it...
The issue didn't show up anymore...
I hope it will help you.
Hi, I got it to work also with DB 2 9.7. The problem was in the access rights within the setup of DB2 itself. The error message was sure not helpful to find the cause of the problem.
Within DB2, one must add the right to create tables to the DB2admin user. I found it surprising that these are not set by default.
Within DB2, one must add the right to create tables to the DB2admin user. I found it surprising that these are not set by default.
page 1of 1 pagesof 2 pages