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: - The storage group can be named something other than JAZZSTG.
- 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: - You can replace the JAZZDB name on the CREATE
DATABASE statement with a different name.
- 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.
- bp8kx is the buffer pool name; for example BP8K0. (TheJazz Team Server requires
an 8 K page size.)
- 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.
- 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 ;