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

CREATE STOGROUP ELMSTG VOLUMES ('*') VCAT yourHlq ;

Create the following Database for the Jazz Team Server
CREATE DATABASE JTS710 STOGROUP ELMSTG BUFFERPOOL BP16K0  
 CCSID UNICODE;  
 COMMIT;                                                

Create the following Database for the Engineering Workflow Management application
CREATE DATABASE CCM710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;   

Create the following Database for the Engineering Test Management application
CREATE DATABASE QM710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the DOORS  application
CREATE DATABASE RM710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the LQE application
CREATE DATABASE LQE710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the DCC application
CREATE DATABASE DCC710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the GC application
CREATE DATABASE GC710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the LDX application
CREATE DATABASE LDX710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the ENI application
CREATE DATABASE ENI710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

Create the following Database for the Data Warehouse
CREATE DATABASE DW710 STOGROUP ELMSTG BUFFERPOOL BP16K0 
 CCSID UNICODE;                                          
 COMMIT;

The server requires a user ID and password to access the repositories. The user ID and password are specified later in the teamserver.properties file. This user ID is not used to log on to the server. It is used only to provide authority for the server to access the Db2 for z/OS databases. Specifically, this user ID requires permissions as shown in the example. In this example, the user has the name jazz.

A user ID with SYSADM access to the databases has the appropriate access to run the server and create the required tables, indexes, and views using the repository tools -createTables command.

If your process does not allow a user ID with SYSADM access, you must grant additional permissions to the user ID. Examples of the GRANT statements are included in the following sample. (Comments are indicated by --.)

-- General 
GRANT USE OF STOGROUP ELMSTG TO jazz ;  
GRANT SELECT ON SYSIBM.SYSTABLES TO jazz ;
GRANT SELECT ON SYSIBM.SYSINDEXES TO jazz ;
GRANT SELECT ON SYSIBM.SYSDATABASE TO jazz ;
GRANT SELECT ON SYSIBM.SYSTABCONST TO jazz ;
GRANT SELECT ON SYSIBM.SYSAUXRELS TO jazz ; 
GRANT SELECT on SYSIBM.SYSKEYS TO jazz ;

-- Grant access to bufferpool.  Default bufferpool is used
-- for tablespaces and an additional grant for the default BP
-- may be needed if different from this one. 32K buffer pool
-- is needed for inline LOBs
GRANT USE OF BUFFERPOOL BP16K0 TO jazz ;  
GRANT USE OF BUFFERPOOL BE32K TO jazz ;

-- JTS – if the JTS repository will be on DB2 z/OS
GRANT DBADM ON DATABASE JTS710 TO jazz ; 

-- Engineering Workflow Management – if the Engineering Workflow Management repository will be on DB2 z/OS
GRANT DBADM ON DATABASE CCM710 TO jazz ; 

-- Engineering Test Management – if the Engineering Test Management repository will be on DB2 z/OS
GRANT DBADM ON DATABASE QM710 TO jazz ; 

-- Engineering Requirements Management DOORS Next – if the Engineering Requirements Management DOORS Next repository will be on DB2 z/OS
GRANT DBADM ON DATABASE RM710 TO jazz ;-- 

-- LQE – if the LQE repository will be on DB2 z/OS
GRANT DBADM ON DATABASE LQE710 TO jazz ;-- 

-- DCC – if the DCC repository will be on DB2 z/OS
GRANT DBADM ON DATABASE DCC710 TO jazz ;-- 

-- GC – if the GC repository will be on DB2 z/OS
GRANT DBADM ON DATABASE GC710 TO jazz ;-- 

-- LDX – if the LDX repository will be on DB2 z/OS
GRANT DBADM ON DATABASE LDX710 TO jazz ;-- 

-- ENI – if the ENI repository will be on DB2 z/OS
GRANT DBADM ON DATABASE ENI710 TO jazz ;-- 

If you plan to use Data Warehouse reporting where “DWX” 
--  equals the prefix you plan to use for the DW schemas
GRANT DBADM ON DATABASE DW710 TO jazz ; 

GRANT CREATEIN ON SCHEMA DWX_CFG TO jazz;
GRANT CREATEIN ON SCHEMA DWX_ODS TO jazz;
GRANT CREATEIN ON SCHEMA DWX_ASSET TO jazz;
GRANT CREATEIN ON SCHEMA DWX_SCHK TO jazz;
GRANT CREATEIN ON SCHEMA DWX_DW TO jazz;
GRANT CREATEIN ON SCHEMA DWX_CALM TO jazz;

COMMIT ;  
  

If you used an ID with DBADM and these additional privileges, you must also grant access to the Views after the tables are created. For details, see Creating database tables using repository tools.

GRANT SYSADM TO jazz ; 
COMMIT ;  

GRANT SYSCTRL TO jazz ; 
COMMIT ;  

In addition, as part of the data warehouse creation and server setup process, a report user is defined for the data warehouse. This user ID is defined in teamserver.properties using the property com.ibm.team.datawarehouse.report.user. This user ID is automatically granted connect and select access to the data warehouse tables as part of the configuration process.