Customizing Jazz Team Server properties files

This section describes how to edit the teamserver.properties file to configure the database connection.
Use the DIS DDF command for your DB2® subsystem to display some of the values you need to supply. For example, you can retrieve the location, ipaddr, and port (tcpport) from the following display:
-DSN9 DIS DDF                                                   
 DSNL080I  -DSN9 DSNLTDDF DISPLAY DDF REPORT FOLLOWS: 548        
 DSNL081I STATUS=STARTD                                          
 DSNL082I LOCATION           LUNAME            GENERICLU         
 DSNL083I NS32DB             NETA.NS32DB       -NONE             
 DSNL084I TCPPORT=3500  SECPORT=3510  RESPORT=3501  IPNAME=-NONE 
 DSNL085I IPADDR=9.42.81.74                                    
 DSNL086I SQL    DOMAIN=RALNS32.rtp.raleigh.ibm.com              
 DSNL086I RESYNC DOMAIN=RALNS32.rtp.raleigh.ibm.com              
 DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE                   
To configure the server, edit the @confPath@/teamserver.properties file and locate the following lines:
com.ibm.team.repository.db.vendor = db2z
com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort
   /location:fullyMaterializeLobData=false;user=jazzDBuser;password={password};
com.ibm.team.repository.db.jdbc.password=jazzDBpswd
com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB
com.ibm.team.repository.db.db2.dsn.bufferpool=bpx
com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG
#com.ibm.team.repository.db.schemaPrefix=xx
Edit these lines to match the database configuration you created in previous steps, and also to match your DB2 configuration. Edit the location, user, password, dbname, bufferpool, and stogroup properties according to your configuration.
Specifically, edit the following:
  1. In line
    com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/
    location:fullyMaterializeLobData=false;user=jazzDBuser;password={password};
    replace:
    • ipAddress with your ipaddr.
    • ipPort with your tcpport.
    • location (in location:fullyMaterializeLobData) with the value listed in the DDF report under LOCATION.
    • jazzDBuser with the user ID you created, which has appropriate access to the DB2 database.
      Note: Do not modify password={password}.
  2. In line
    com.ibm.team.repository.db.jdbc.password=jazzDBpswd
    replace jazzDBpswd with the password for your DB2 user.
  3. In line
    com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB
    replace JAZZDB with the name of the database you created.
  4. In line
    com.ibm.team.repository.db.db2.dsn.bufferpool=bpx
    replace bpx with the bufferpool you chose when you created the database.
  5. In line
    com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG
    replace JAZZSTG with the storage group you created.
  6. In line
    #com.ibm.team.repository.db.schemaPrefix=xx
    you can remove the # and replace xx with a prefix of your choice. This is optional. It enables you to have multiple Jazz™ repositories in one DB2 subsystem.
    Note: If you wish to create several Jazz databases in the same DB2 subsystem, you will need to differentiate the table owners for the Jazz tables. In order to do that, the Jazz Team Server uses the com.ibm.team.repository.db.schemaPrefix directive to prefix the Jazz DB2 objects so that they are unique within a DB2 subsystem. The owner will be prefixed with the prefix set in com.ibm.team.repository.db.schemaPrefix along with an underscore. For example, table WORKITEMS_SNAPSHOT.WORKITEM_CHNGS will be created as X1_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS, in a given database when com.ibm.team.repository.db.schemaPrefix=X1.
In addition, replace all instances of @workPath@ in the teamserver.properties file with the path that you selected for @workPath@ in the following properties:
  • com.ibm.team.repository.content.tmpdir
  • com.ibm.team.fulltext.indexLocation
Note: Jazz Team Server will create these directories.

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug