These are the
instructions for manually creating databases for lifecycle management
for IBM® Rational® Asset Manager in Microsoft SQL Server. These databases are 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
have the databases.
SQL
Server must already be installed and running.
Use SQL Server
Authentication available as part of Mixed mode (Windows Authentication
and SQL Server Authentication).
Procedure
To set up SQL Server databases by using the command tool sqlcmd:
- Start the command line tool. At a command prompt type sqlcmd
-U login_id -P password.
- Create a Change and Configuration Management (CCM) database.
From the command line tool, type:
CREATE DATABASE ccmdb
GO
- Change the ownership of the CCM 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 ccmdb. From
the command line tool, type:
USE ccmdb;
exec sp_changedbowner 'ramDBuser'
GO
- Change the row version system for the database. From the
command line tool, run this command. For CCM and QM databases, replace jts with ccm and qm:
Note: Ensure that the connection to the database
is open before running this command.
ALTER DATABASE jts SET READ_COMMITTED_SNAPSHOT ON
GO
- Change the collation of the CCM database. From the command
line tool, type:
SQL_Latin1_General_CP1_CS_AS
- Repeat the above steps to create a Jazz™ Team Server (JTS) database named 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), 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 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.