Creating a database for asset lifecycles in Microsoft SQL Server

These are the instructions for manually creating a database for lifecycle management for IBM® Rational® Asset Manager in Microsoft SQL Server. This database will be used by the included version of IBM Rational Team Concert.

Before you begin

If you are using an existing Rational Team Concert server, you can skip this task because Rational Team Concert already has a database.

SQL Server must already be installed and running.

Procedure

To set up an SQL Server database by using the command tool sqlcmd:

  1. Create a Jazz™ Team Server database. From the command line tool, type:
    CREATE DATABASE rtcdb 
    GO
  2. Change the ownership of the Jazz Team Server database to the same user that you use for the Rational Asset Manager asset management database. The following example command assigns the user name ramDBuser as the owner of database rtcdb. From the command line tool, type:
    USE rtcdb;
    exec sp_changedbowner 'ramDBuser'
    GO
  3. Change the collation of the Jazz Team Server database. From the command line tool, type:
    ALTER DATABASE rtcdb COLLATE Latin1_General_CP437_CS_AS 
    GO

What to do next

For WebSphere: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), which is not bundled with IBM Rational Asset Manager.

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 database. 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 5.5.

Feedback