problems connecting RTC 2.0 beta to DB2
![]()
I am having some problems trying setup a DB2 database for RTC on RHEL 5.
I already saw the postings about removing fullyMaterializedLobData from the teamserver.properties file, and got past that point. Currently, I beleive that I am stuck with some other permissions issue. Note: The documentation say to use "db2fenc1" to create the database with the "db2 create..." command. For some reason, I received an error about permissions. I was able to use "db2inst1" to run the "db2 create" command. I don't know if this would be related or not. [root@wcary2nu server]# ./repotools.sh -createTables Here are the relevant lines from the teamserver.properties file: com.ibm.team.repository.db.vendor = DB2 More back ground information: I create the following userids/groups for the installation db2isnt1 (db2iadm1) This is the response file from the DB2 installation: [root@wcary2nu ~]# more db2exp.rsp |
7 answers
![]() I am having some problems trying setup a DB2 database for RTC on RHEL 5. Hello, According to my understanding, you are able to create the Jazz database within DB2 by using the "db2inst1" ID and its corresponding password is "db2iadm1"? But in your teamserver.properties file, you have the following set, which does not match with the id's password. com.ibm.team.repository.db.jdbc.password=db2admin I would try change it to the following, then try the repotools createtable command to see if it will work: com.ibm.team.repository.db.jdbc.password=db2iadm1 Hope this helps, Susan |
![]() I am having some problems trying setup a DB2 database for RTC on RHEL 5. Hello, According to my understanding, you are able to create the Jazz database within DB2 by using the "db2inst1" ID and its corresponding password is "db2iadm1"? But in your teamserver.properties file, you have the following set, which does not match with the id's password. com.ibm.team.repository.db.jdbc.password=db2admin I would try change it to the following, then try the repotools createtable command to see if it will work: com.ibm.team.repository.db.jdbc.password=db2iadm1 Hope this helps, Susan |
![]()
I just tried that, but it did not help. Same error message... |
![]()
I just tried that, but it did not help. Same error message... Have you already created the Jazz database, from the DB2 Command Window with the above ID? and can you access the Jazz db from DB2 with this ID? On linux, the create db command from DB2 command window would be: db2 create database JAZZ using codeset UTF-8 territory en Susan |
![]()
Thanks... I guess I forgot to restart the database. After running db2start, I was able to sort out the rest. |
![]()
I saw the same thing, and removing the "fullyMaterializeLobData=false" from the file worked for me.
I am working now, and have filed a work item (https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=76379) for this. |
![]()
You need to change the port number 50001 to 50000 as it is the default port for DB2 on Linux. You need to also remove "fullyMaterializeLobData=false;" from teamserver.properties file for DB2.
I am having some problems trying setup a DB2 database for RTC on RHEL 5. |
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.