Creating database tables for assets in DB2 manually

Edit online

These are the instructions for manually configuring IBM® DB2® and creating tables for IBM Rational® Asset Manager in DB2.

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.

DB2 must already be installed and running. Also, make sure that you know the location of the SQL scripts that are included with the installation media (typically, path to installation media\ db_scripts\DB2). Finally, ensure that you also know the installation directory for DB2 (typically C:\Program Files\IBM\SQLLIB for Windows®, opt/ibm/DB2/V10.1 for Linux® and /opt/IBM/db2/V10.1 for AIX®.

About this task

You can optionally use batch scripts to simplify this process. See Creating and populating database tables for assets in DB2 with batch files.

Procedure

To configure DB2 and create the database tables:

Start the DB2 Control Center.
Select the instance of the database.
Create and add a new database.
1. Click Tools > Command Editor.
2. In the command editor, type (in uppercase):
```
ATTACH TO <DATABASE_INSTANCE>
```
  (where <DATABASE_INSTANCE> is the name of the database instance you selected in step 2)
3. Click Execute.
4. Clear the previous command from the command editor and type (in uppercase):
```
CREATE DATABASE <DATABASE_NAME> AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US
```
  (where <DATABASE_NAME> may be any name you choose; for example, RAMDB)
5. Click Execute.
6. Click Add, select the database you just created, and click OK.
Use the server setup application to populate the database. To learn more about the server setup application, see Installing Rational Asset Manager server by using Installation Manager.
Verify that the tables were created.
1. Click Object View and open the database instance.
2. Click Tables to verify that the tables contain data.

What to do next

If you do not already have an existing Rational Team Concert server create the database for lifecycle management. See Creating databases for asset lifecycles in DB2.
If you already have Rational Team Concert:

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 IBM Rational Asset Manager application files. See Deploying the IBM Rational Asset Manager server applications on Tomcat 6 or 7.