Creating databases for asset lifecycles in DB2

Create databases for lifecycle management in IBM® DB2® for IBM Rational® Asset Manager These databases are used by the included version of IBM Rational Team Concert™.

Before you begin

If you are using IBM WebSphere® Application Server and will be using the server setup application on a supported operating system other than z/OS®, you can skip this task because the server setup application can create and configure the databases for you.

If you are using an existing Rational Team Concert server, you can skip this task because Rational Team Concert already have the databases.

Ensure that you also know the installation directory for DB2 (typically C:\Program Files\IBM\SQLLIB for Windows and opt/IBM/DB2/V10.1 for Linux, AIX®, and Linux for zSeries.

The user performing these instructions must have system administrator authority on the DB2 database.

Tip: On Linux, AIX, or Linux for zSeries, to get system admin authority on the DB2 database, sudo to the DB2 user db2inst1 and run bash. Note that db2inst1 is the default instance user.

Procedure

To set up the DB2 databases:

Create the databases in the DB2 Command Window. The following example commands create a new database called CCMDB. 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.
- On Windows:, where <database_storage_drive> is the drive (for example, C:\ ) where you want to store the database files:
```
db2 create database CCMDB on <database_storage_drive> using codeset UTF-8 territory en pagesize 8192
```
  Tip: The hard drive that you create the database on must have at least 5 gigabytes of storage space available.
- On Linux, AIX, or Linux for zSeries, where <database_storage_directory> is a fully qualified path to the directory on your file system where you want to store the database files:
```
db2 create database CCMDB on <database_storage_directory> using codeset UTF-8 territory en pagesize 8192
```
  Tip: The database storage directory must already exist and have at least 5 gigabytes of storage space available.
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.
Repeat the previous step to create a new database called JTSDB.

What to do next

If you are using WebSphere Application Server:

If you have not deployed the server setup application, deploy it to your server or cluster. To do so, see deploying to a server or deploying to a cluster.

Restriction: To create and use a cluster of application servers, you must have IBM WebSphere Application Server Network Deployment (ND).

If you are installing to a WebSphere Application Server cluster and you need to install Rational Team Concert™, you will also have to create a single application server instance for Rational Team Concert.

Then, use the server setup application to configure WebSphere Application Server to connect to your databases. If you have deployed the server setup application to your server or cluster, see Deploying and configuring application files by using the server setup application.

If you are using Apache Tomcat:

Configure Apache Tomcat and deploy the Rational Asset Manager application files. See Deploying the Rational Asset Manager server applications on Tomcat 6 or 7.

Feedback