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. |
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. |
Ralph Schoon (63.3k●3●36●46)
| answered Apr 05 '11, 7:04 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,
I ran into the same issue and the post fixed it. I promoted the info to support. Thanks, Ralph |
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 |
All set.
Our DBA hadn't granted DBAdmin privs to the ID we're using. Instead the ID was given System Manager privs (or similar) which apparently has almost all the DBA privs except the ability to create tables. |
Encountering this exact error on Oracle, the fix was to give permission to the jazz user to write to the tablespace.
ALTER USER jazzuser QUOTA UNLIMITED ON jazz_tbs; |
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: |
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 found something that describes the problem and resolution: |
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 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. |
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. |
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.