Create databases for lifecycle management in IBM® DB2® for IBM Rational® Asset Manager These databases are used by the included version of IBM Rational Team Concert.
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.
If
you are using an existing Rational Team Concert server,
you can skip this task because Rational Team Concert already
have the databases.
Ensure that you also know the installation
directory for DB2 (typically C:\Program
Files\IBM\SQLLIB for Windows and opt/IBM/DB2/V10.1 for Linux, AIX®, and Linux for zSeries.
The user performing
these instructions must have system administrator authority on the
DB2 database.
Tip: On Linux, AIX, or Linux for zSeries,
to get system admin authority on the DB2 database,
sudo to the DB2 user db2inst1 and
run bash. Note that db2inst1 is the default instance
user.
Procedure
To set up the DB2 databases:
- Create the databases in the DB2 Command
Window. The following example commands create a new database called CCMDB.
These commands run in the DB2 Command
Window. The Command Window can be opened from the application Start
menu under the DB2 Command Line
Tools menu.
- On Windows:,
where <database_storage_drive> is
the drive (for example, C:\ ) where you want
to store the database files:
db2 create database CCMDB on <database_storage_drive> using codeset UTF-8 territory en pagesize 8192
Tip: The hard drive that you create the database on must have
at least 5 gigabytes of storage space available.
- On Linux,
AIX, or Linux for zSeries, where <database_storage_directory> is
a fully qualified path to the directory on your file system where
you want to store the database files:
db2 create database CCMDB on <database_storage_directory> using codeset UTF-8 territory en pagesize 8192
Tip: The database storage directory must already exist and have
at least 5 gigabytes of storage space available.
Note: To ensure proper handling of Unicode content, the database
character set must be UTF-8 encoding.
Tip: If the
database is not running, the command db2start starts DB2.
- Repeat the previous step to create a new database called 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.