Setting up DB2 for z/OS to use with the Jazz Team Server

When you run the Jazz™ Team Server with DB2® for z/OS®, you must create a DB2 storage group and a DB2 database. You must also authorizeJazz Team Server users to that storage group and database.

About this task

You must complete the following steps before you can run the repository tools database builder utility, which creates the Jazz repository tables in your database. None of these steps is performed by the Jazz Team Server database builder utility.
Creating a storage group
The storage group must be appropriate to the system. The following example shows a DB2 SQL create statement:
CREATE STOGROUP JAZZSTG VOLUMES ('*') VCAT yourHlq ;
Notes:
  1. The storage group can be named something other than JAZZSTG.
  2. yourHlq is the high-level qualifier of your DB2 files. It must exist on your system, and the Jazz Team Server user must have full access to it.
Creating a database
The database must be appropriate to the system, and you must create it with UNICODE as the CCSID. The following example shows a DB2 SQL create statement:
CREATE DATABASE JAZZDB STOGROUP JAZZSTG BUFFERPOOL bp8kx CCSID UNICODE;
Notes:
  1. You can replace the JAZZDB name on the CREATE DATABASE statement with a different name.
  2. The database name is used later for the Jazz Team Server for System z® teamserver.properties com.ibm.team.repository.db.db2.dsn.dbname property.
  3. bp8kx is the buffer pool name; for example BP8K0. (TheJazz Team Server requires an 8 K page size.)
  4. You must create your DB2 database with UNICODE as the CCSID. If UNICODE is not the CCSID, the Create database task fails, and this message is displayed: CRJAZ0249I The database code page was set to "E" but should be "U". Recreate the database with the correct code page.
  5. You can define multiple Jazz DB2 databases in a DB2 subsystem to contain separate Jazz repositories with the Jazz Server teamserver.properties file directive com.ibm.team.repository.db.schemaPrefix. Seecustomizing_jazz_team_server_properties_files.html.
Authorizing a Jazz Team Server user

The Jazz Team Server requires a user ID and password to access the Jazz Team Server DB2 repository. The user ID and password are specified later in the teamserver.properties file. This user ID is not used to log on to the Jazz Team Server. It is used only to provide authority for the Jazz Team Server to access the DB2 for z/OS database. Specifically, this user ID requires permissions as shown here. In the following example, the user has the name jazz:

GRANT DBADM ON DATABASE jazzdb TO jazz ; 
GRANT USE OF STOGROUP jazzstg TO jazz ;  
GRANT USE OF BUFFERPOOL bpx TO jazz ;  
COMMIT ;  
In addition, if you set the value of the DBADM CREATE AUTH field to NO on panel DSNTIPP during DB2 installation, you must grant SYSADM authorization to the Jazz Team Server user.
GRANT SYSADM TO jazz ; 
COMMIT ;  

Feedback