When running the Jazz™ Team Server on DB2®, you must create a DB2 storage group
and a DB2 database.
You must also authorize the Jazz Team Server user to that storage group and database.
The following steps must be performed before running the repository
tools database builder utility, which creates the Jazz repository tables in your database
instance. None of these steps is performed by the Jazz Team Server database builder utility.
- Create 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 ;
Note: - The storage group can be named something other than JAZZSTG.
- The storage group name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.stogroup property.
- 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.
- Create a database
- The database must be appropriate to the machine. The following example
shows a DB2 SQL
create statement:
CREATE DATABASE JAZZDB STOGROUP JAZZSTG BUFFERPOOL bpx ;
Notes: - The database can be named something other than JAZZDB.
- The database name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.dbname property.
- bpx is the buffer pool name
- The buffer pool name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.bufferpool properties.
- You may 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 properties files.
- Authorize 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 Jazz Team Server teamserver.properties file.
This user ID is not used to log on to the Jazz Team Server, but it is used only to
provide authority for the Jazz Team Server to access the DB2 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 the value of field DBADM CREATE
AUTH is set to NO on panel DSNTIPP during DB2 installation,
you must grant SYSADM authorization to the Jazz Team Server
user. GRANT SYSADM TO jazz ;
COMMIT ;