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 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 got work rtc 2.0.0.1 with db2 exp-c 9.7:
db2set DB2_OPTPROFILE=YES
create database JAZZ using codeset UTF-8 territory en PAGESIZE 8192
update db cfg for jazz using cur_commit disabled
connect to jazz
grant dbadm on database to user db2admin
revoke connect on database from public
repotools -createTables
jazz is connecting as user db2admin
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.
I had the same problem so this thread has been really helpful Thanks for your initial post.
Thanks, this helped me as well. But I had one small problem, which was not mentioned here.
When I try to "Grant All" in DB2 Control Center (as described in above posts), then I'm not allowed, because Control Center connects with "SYSTEM" user.
I neede to right click the database (JTS or CCM) and "Connect...." and then use the user I had installed DB2 with (or the user I had run the "create database" command with).
Morten.
When I try to "Grant All" in DB2 Control Center (as described in above posts), then I'm not allowed, because Control Center connects with "SYSTEM" user.
I neede to right click the database (JTS or CCM) and "Connect...." and then use the user I had installed DB2 with (or the user I had run the "create database" command with).
Morten.
page 2of 1 pagesof 2 pages