Setting up DB2

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:
  1. The storage group can be named something other than JAZZSTG.
  2. The storage group name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.stogroup property.
  3. 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:
  1. The database can be named something other than JAZZDB.
  2. The database name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.dbname property.
  3. bpx is the buffer pool name
  4. The buffer pool name is used later for the Jazz Team Server teamserver.properties com.ibm.team.repository.db.db2.dsn.bufferpool properties.
  5. 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 ;  

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug