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

This section describes how to edit and configure the teamserver.properties file so that z/OS can connect to DB2.

About this task
Locate the configuration directory in @confPath@/jazz. By default, the teamserver.properties file in that directory is configured to use a Derby database.
  1. Rename the teamserver.properties file teamserver_derby.properties.
  2. Rename the teamserver_db2z.properties file teamserver.properties.
  3. Complete editing the teamserver.properties file according to the instructions in this topic.
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, 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@/jazz/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: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.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, and dbname properties according to your configuration.
Specifically, edit the following:
  1. In the following line:
    com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/
    location:user=jazzDBuser;password={password};
    replace:
    • ipAddress with your ipaddr.
    • ipPort with your tcpport.
    • location 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 the following line:
    com.ibm.team.repository.db.jdbc.password=jazzDBpswd
    replace jazzDBpswd with the password for your DB2 user.
  3. In the following line:
    com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB
    replace JAZZDB with the name of the database you created.
  4. In the following 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: To create several Jazz databases in the same DB2 subsystem, you must differentiate the table owners for the Jazz tables. To do so, 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 prefix set in com.ibm.team.repository.db.schemaPrefix will be added to the owner 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@ with the path that you selected for @workPath@; for example, these properties:
  • com.ibm.team.fulltext.indexLocation=@workPath@/workitemindex
  • com.ibm.team.repository.tmpdir=@workPath@/contentservice
  • com.ibm.team.scm.tmpdir=@workPath@/contentservice
  • com.ibm.team.scm.vcs.tmpdir=@workPath@/versionedcontentservice
Note: Jazz Team Server for System z will create these directories.
Tip: The Jazz database contains LOB (large object) columns in its tables. The LOB columns are associated with a buffer pool that is created by DB2 during table creation. The default buffer pool for a LOB tablespace is defined in zparm TBSBPLOB. You can set the value to an 8K buffer pool if you do not want 4K page sizes. For additional information see "Alternatives in defining LOBs" in the IBM Redbook LOBs with DB2 for z/OS: Stronger and Faster at http://www.redbooks.ibm.com/redbooks/pdfs/sg247270.pdf.