When you create a user database using the Designer, you apply a
schema version to the user database. The copy of the applied schema version
resides in the user database. The schema version defines the process model
and forms for the defect and change tracking system.
Before you create a user database, you must create an empty database
container with tools provided by the database vendor.
For
information about configuring vendor databases, see the IBM Rational ClearQuest and ClearQuest MultiSite
Installation and Upgrade Guide.
To create a user database:
- Click Start the Designer. If
the Open Schema window opens, click Cancel.
- Click .
- In Step 1 of the new Database Wizard, enter a logical
database name for the user database. The name must be five or fewer alphanumeric
characters.
- Optional: Enter a comment and click Next.
- In Step 2 of the New Database Wizard, select the
vendor of the database to use for the user database and enter the required
database properties. These properties for each database are different.
- If you select Microsoft SQL Server, Oracle RDBMS, or IBM DB2 as the
vendor database, enter the physical database name of one of the empty databases
that you created with the database vendor tools.
- When you create a DB2 user database, the User Name property must
be a user identity with Database Administrator authority for the DB2 database.
- If you select Microsoft Access, enter a physical database name. The
Designer creates a new database with that name.
- At the end of Step 2, you can specify whether the
user database is a production database or a test database. The default setting
is Production Database. Then click Next.
- In Step 3 of the New Database Wizard, enter a value
(in minutes) in the Timeout and Poll Interval fields.
If you do not want the database to time out for idle connections, set both
to zero (0). Click Next.
- In Step 4 of the New Database Wizard, select a schema
from a list of predefined schemas, to associate with the new user database.
- Click Finish.