Set up a DB2® database to work with the Jazz™ Team Server for System z™.
This procedure assumes the following prerequisites have been met.
Consult your DB2 documentation
or a DB2 database
administrator for help.
- Review the DB2 documentation
to verify that your system meets the requirements and is configured correctly.
- DB2 is
installed and running on a machine to be used as the database server. This
machine can be a different one from that on which the Jazz Team Server runs.
- You reviewed Special
DB2 instructions.
- The user performing these instructions has system administrator authority
on the DB2 database.
Tip: To get system administrative authority on the DB2 database,
use commands similar to the following:
sudo db2fenc1
bash
To set up a DB2 database:
- Optional: You can create a new DB2 instance to use with the Jazz Team Server,
or just create a database in an existing DB2 instance. To create a DB2 instance for
the Jazz Team
Server:
- Log on with the root user.
- Define two new user IDs to the Linux® for System z. For example, db2fenc1 and db2inst1.
- From the DB2InstallPath/V9.1/instance directory,
run the following command:
./db2icrt -a server -s ese -u db2fenc1 -p db2c_db2inst1 db2inst1
- Create the Jazz Database:
- Log on with db2inst1 or your DB2 instance user ID.
- Start the DB2 manager:
db2start /D
- Run the following command:
db2 create database JAZZ on YourDatabasePath using codeset UTF-8 territory en
Important: The directory YourDatabasePath must exist
and the user ID db2inst1 must have write access.
Note: To
ensure proper handling of Unicode content, the database character set must
be UTF-8 encoding.
Tip: If the database is not running,
the command db2start starts DB2.
- Locate the file teamserver.properties in
the directory JazzInstallDir/server and rename it to teamserver.derby.properties.
- Locate the file teamserver.db2.properties in
the directory JazzInstallDir/server and rename it to teamserver.properties.
- Specify the database and connection details in the file teamserver.properties.
The default connection specification connects to a DB2 database that
runs on localhost on port 50000. The database is called JAZZ,
and both the user name and password are db2admin. If the default values
were used when setting up your database, the teamserver.properties file
might already be configured correctly. If not, change this information to
match your configuration.
- Open the file teamserver.properties in
a text editor.
- Locate the following lines:
com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin
- Edit the value of com.ibm.team.repository.db.jdbc.location
for your DB2 server
and database.
Tip: From your DB2 instance user (such as db2inst1),
enter the command db2 get dbm cfg, then find the line that
contains SVCENAME, which indicates the DB2 port name or number. If this command
displays a number, use it as the port number (in place of 50000 in the example
above). If the command returns a non-numeric name, determine what port number
was assigned for this name and use that port number. The file /etc/services contains
the mapping between port names and numbers. For more information, ask your
database administrator or consult the database documentation.
- Edit the value of com.ibm.team.repository.db.jdbc.location for
your DB2 user
name.
It is important that the user has authority to create
tables, tablespaces, and modify the database configuration.
- Specify the user password in the property com.ibm.team.repository.db.jdbc.password.
Note: Do not change the password={password} text in the com.ibm.team.repository.db.jdbc.location property.
- If necessary, change the property com.ibm.team.repository.db.db2.content.tablespace.location
to a path on your Jazz Team Server where the main tablespace can be created.
Note: If this value is not changed from the default of content_tablespace,
the tablespace is created under the database storage location.