Set up a supported DB2® or
the bundled DB2 Workgroup Server
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
(DBA) for help.
To set up a DB2 database:
- Create the database in the DB2 Command
Window. The example commands create a new database
called JAZZ. These commands run in the DB2 Command
Window. The Command Window can be opened from the application Start
menu under the DB2 Command Line
Tools menu.
Note: To ensure proper handling of Unicode content, the database
character set must be UTF-8 encoding. Because the AUDITABLE_LINKS
table does not fit in the default page size of 4K on Windows, set the page size to at least 8K.
Tip: If the database is not running, the command db2start starts DB2.
- Locate the file teamserver.properties in
the directory JazzInstallDir/server/conf/jazz and
rename it to teamserver.derby.properties.
- Locate the file teamserver.db2.properties in
the directory JazzInstallDir/server/conf/jazz 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. On Windows,
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: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: In the DB2 Command
Window, run 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. On Linux,
the file /etc/services contains the mapping between
port names and numbers, and on Windows,
the file C:\windows\system32\drivers\etc\services contains
the mapping. 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.
Note: The DB2 user must have permissions to
create tables, tablespaces, and modify the database configuration. DB2 users are created by the operating
system.
- 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 for System z 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. On Windows, if a new path is specified,
it must be specified by using double backslashes, for example: com.ibm.team.repository.db.db2.content.tablespace.location=c:\\db2\\jazz\\content_tablespace.