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

By default, Jazz™ Team Server 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 is not used. Change:
# 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 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 must 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 lines:
  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. Optional: Insert the following line:
    com.ibm.team.repository.db.schemaPrefix=xx
    replace xx with a prefix of your choice. This optional step 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 differentiate the table owners, the Jazz Team Server uses the com.ibm.team.repository.db.schemaPrefix directive to add a prefix to the Jazz DB2 objects. Adding the prefix ensures that they are unique within a DB2 subsystem. The owner includes the prefix set in com.ibm.team.repository.db.schemaPrefix along with an underscore. For example, the table WORKITEMS_SNAPSHOT.WORKITEM_CHNGS is created as X1_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS, in a given database when com.ibm.team.repository.db.schemaPrefix=X1.

Feedback