It's all about the answers!

Ask a question

Can't create DB2 tables: Exception testing case sensitivity


1
1
Steve Viens (61185) | asked Jul 02 '09, 11:10 a.m.
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



permanent link
Paul Tasillo (10665) | answered Dec 04 '09, 11:09 p.m.
JAZZ DEVELOPER
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.

permanent link
Ralph Schoon (63.1k33645) | 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

permanent link
Steve Viens (61185) | answered Jul 02 '09, 11:49 a.m.
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

permanent link
Steve Viens (61185) | answered Jul 03 '09, 8:08 a.m.
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.

permanent link
Ed Koezly (4654) | answered Aug 04 '09, 5:16 p.m.
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;

permanent link
Zeeshan Muzaffar (1622) | answered Aug 12 '09, 11:29 p.m.
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

permanent link
Robert Carter (42928589) | answered Sep 23 '09, 3:40 p.m.
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

permanent link
Marko Boger (21) | answered Oct 01 '09, 5:56 a.m.
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?

permanent link
Philippe Krief (561155) | answered Oct 05 '09, 9:21 p.m.
JAZZ DEVELOPER
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.

permanent link
Marko Boger (21) | answered Oct 06 '09, 3:46 a.m.
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


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