To use the IBM® DB2® database, you must configure
it to work with the Jazz™ Team
Server.
Before you begin
You must complete the following prerequisite tasks before
you can configure DB2.
- Review the DB2 documentation
to verify that your system meets the requirements and is configured
correctly.
- Install DB2 on a machine
that is the database server. DB2 and
the Jazz Team
Server can
be installed on separate machines.
- Verify that you have system administrator permissions for the
DB2 database.
Tip: On Linux®,
to get system administrator permissions for the database, run the
command sudo db2fenc1 (db2fenc1 is the DB2 user), and at the command prompt, type bash.
About this task
To set up a DB2 database:
Procedure
- Create the database in the DB2 Command
Window. The example commands create a database called JAZZ. These
commands run in the DB2 Command Window. The Command Window can be
opened from the 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 4 K on Windows, set the page size to at least 8
K.
If the database is not running, use the command db2start to
start 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. 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.
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
where the main table space can be created.
Note: If this
value is not changed from the default of content_tablespace,
the table space 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.
What to do next
You have finished setting up your database and can continue
with
Creating database tables.
Alternatively,
return to the Installation roadmaps to
review the next steps in the installation.