Customizing Jazz Team Server for System z properties files for DB2 for z/OS

By default, Jazz™ Team Server for System z® uses the configuration file located in JazzInstallDir/server/conf/jazz for configuration information about the database connection.

Edit the teamserver.properties file. Change the following lines to comments so that the default Derby database will not be used. Specifically, change the following lines:
# JDBC DB location, specifying this property disables system-based selection 
# of default location
com.ibm.team.repository.db.vendor = DERBY
com.ibm.team.repository.db.jdbc.location = repositoryDB
to match these lines:
# JDBC DB location, specifying this property disables system-based selection 
# of default location
#com.ibm.team.repository.db.vendor = DERBY
#com.ibm.team.repository.db.jdbc.location = repositoryDB
Uncomment the following properties that start with #com.ibm by removing the #. Then follow the instructions later in this section to set the property values.
#
# DB2z configuration
#

# Comment out above lines, uncomment the following lines and customize 
# example location to use DB2z
#com.ibm.team.repository.db.vendor = db2z

# Location name of the DB2z sub-system. 
# ipAddress, ipPort and location be obtained by running the DB2 command -DISPLAY DDF
#com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/
#location:fullyMaterializeLobData=false;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

# DB2z Database name  
#com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB

 Note: The following two properties might appear in the teamserver.properties file, but they are not required. 
# DB2z Bufferpool name  
#com.ibm.team.repository.db.db2.dsn.bufferpool=bpx

# DB2z Storage Group name  
#com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG
Use the -DIS DDF command for your DB2® for z/OS® subsystem to display some of the values you need to supply. For example, you can retrieve the location, IP address (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

Edit the following 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:user=jazzDBuser;password={password};
    Replace:
    • ipAddress with your IP address.
    • ipPort with your TCP port.
    • location with the value listed in the DDF report under LOCATION.
    • jazzDBuser with the user ID you created that has appropriate access to the DB2 database.
    Important: 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. Make sure it supports 8K pages. Use a bufferpool such as BP8K0.
  5. In line:
    com.ibm.team.repository.db.db2.dsn.stogroup=JAZZSTG
    replace JAZZSTG with the storage group you created.
  6. Insert the following line if you choose:
    com.ibm.team.repository.db.schemaPrefix=xx
    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 want to create several Jazz databases in the same DB2 subsystem, you must differentiate the table owners for the Jazz tables. In order to do that, the Jazz Team Server for System z uses the com.ibm.team.repository.db.schemaPrefix directive to add a prefix to the Jazz DB2 objects so that they are unique within a DB2 subsystem. The owner will include the prefix set in com.ibm.team.repository.db.schemaPrefix along with an underscore. For example, the 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.