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).
Note: Windows Authentication (or Windows
Integrated Security) is not supported by Rational Asset Manager or Rational Team Concert setup.
For more information, see RTC APAR PI18955: [WI 233472] DOCUMENT
THAT "INTEGRATED AUTHENTICATION" IS NOT SUPPORTED and The Support Authority: Resolving connection
errors between WebSphere Application Server and SQL Server.
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.