When you run the Jazz™ Team
Server for System z® with DB2® for z/OS®, you must create a DB2 storage group and a DB2 database. You must also authorize Jazz Team Server for System z users to that storage group and
database.
The following steps must be performed 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 machine. 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
for System z 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. (The Jazz Team Server for System z requires an 8K page size.)
- You must create your DB2 database with UNICODE as
the CCSID. If you do not, the Create database task will fail,
and this message is displayed: CRJAZ0249I The database codepage
was set to "E" but should be "U". Recreate the database with the
correct codepage.
- You can define multiple Jazz DB2 databases in a DB2 subsystem to contain separate Jazz repositories. This is done in conjunction
with the Jazz Server teamserver.properties file
directive com.ibm.team.repository.db.schemaPrefix,
as discussed in Customizing Jazz Team Server for System z properties files for DB2 for z/OS.
- Authorizing a Jazz Team
Server for System z user
-
The Jazz Team Server
for System z requires a
user ID and password to access the Jazz Team
Server for System z 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 for System z. It is used only to provide authority
for the Jazz Team Server for System z 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 for System z user. GRANT SYSADM TO jazz ;
COMMIT ;