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:
- Create a Jazz™ Team
Server database. From the command line tool, type:
CREATE DATABASE rtcdb
GO
- 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
- 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
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.