Creating a schema repository

A schema repository is a database that stores and manages a group of schemas, including all versions of those schemas and their associated user databases.

Before you begin

You must create an empty database container with tools provided by the database vendor before you create a schema repository.

Procedure

Start the Maintenance Tool. Then click Schema Repository > Create.
In the Existing Connections pane, enter a name for the schema repository connection in the highlighted item and press Enter.
Tip: You can rename the connection later.
In the Schema Repository Properties area, choose the Feature Level for the schema repository. The default feature level is the latest level available. Then select a database vendor and enter the required properties. The properties for each database are different.
- If you select Microsoft SQL Server, Oracle DBMS, or IBM® DB2®, enter the physical database name of one of the empty databases that you created with the vendor database tools.
  When you create a DB2 schema repository, the User Name property must be a user identity that has database administrator authority for the DB2 database.
- If you select Microsoft Access, enter a physical database name; the Maintenance Tool creates a new database with that name.
Click Next.
In the ClearQuest® Data Code Page window, select the data code page to use with the new schema repository. You can choose any data code page that is supported by Rational® ClearQuest. The default data code page is associated with the language of the operating system on which the Maintenance Tool is running, if the code page is supported. If the code page is not supported, the default is ASCII.
You have the option of creating a sample user database.
Click Finish.

Results

The Rational ClearQuest data code page value for the new schema repository and the associated user databases is verified to ensure compatibility with the vendor database character set.