When
you create a schema repository or user database, you must set
the properties for the vendor database.
Microsoft Access parameters
IBM® does not support Microsoft® Access
databases for production use.
To specify the following database parameter
for Microsoft Access,
enter the full path and name for the schema repository or user database in
the Physical Database Name field using a UNC style
path. For example:
\\DevServer\ProjectShare\CQ_DBS\schema_repo.mdb
You can navigate to the directory that contains the database.
To preserve the UNC style path name, use the Network Neighborhood.
SQL Server parameters
To specify
database parameters for SQL Server:
- In the Physical Database Name field, enter the
database name for SQL Server schema repository or user database.
- Enter the name of the database server in the Database Server
Name field. All Rational® ClearQuest® clients
must be able to access this server host name exactly as it appears in this
entry.
- Enter the database owner (DBO or Administrator) user name in the Administrator
Name field.
- Enter the password for the database owner (DBO or Administrator) in the Administrator
Password field.
- Optional: Enter the connect options in the Connect Options field.
The supported connect options are INSTANCE and PORT.
If
the SQL Server instance name is different from the default, you can specify
the instance in the form INSTANCE=name.
If the
port number of the database is different from the default (1433), enter the
port number in the form PORT=number.
If you use
both INSTANCE and PORT, separate
the options with semicolons. For example: INSTANCE=MYSQLSERVER;PORT=1400
Oracle parameters
To specify database
parameters for Oracle:
- Enter the machine name of the database server in the Server field
for the schema repository or user database.
- Enter the Oracle DBMS System Identifier (SID) in the SID field.
- Enter the Oracle user name in the User Name field.
- Enter the password for the user name in the Password field.
- Leave the Connect Options field blank unless one
of the following conditions is true:
- Your environment includes clients from earlier versions of Rational ClearQuest and
from version 7.0, and all clients are connected to the same databases. For
more information, see the IBM Rational ClearQuest and ClearQuest MultiSite
Installation and Upgrade Guide.
- Your database server uses a TCP/IP port other than the default (1521).
If you use a nondefault port, enter PORT=number in
the Connect Options field.
DB2 parameters
To specify database parameters
for DB2
®:
- Enter the machine name of the database server in the Server field
for the schema repository or user database.
- Enter the database name in the Database field.
- Enter the DB2 user
name in the User Name field. Note, when you create
a DB2 schema
repository or user database, the User Name property
must be a user identity with Database Administrator authority for the DB2 database.
- Enter the password for the user name in the Password field.
- Leave the Connect Options field blank unless one
of the following conditions is true:
- Your environment includes clients from earlier versions of Rational ClearQuest and
from version 7.0, and all clients are connected to the same databases. For
more information, see the IBM Rational ClearQuest and ClearQuest MultiSite
Installation and Upgrade Guide.
- Your database server uses a TCP/IP port other than the default (50000).
If you use a nondefault port, enter it in the Connect Options field
in the form PORT=number.
When you create a schema repository or user database with DB2,
you must run the command binddb2pkg before Rational ClearQuest clients
connect to a DB2 database.
For more information about this command, see the command reference section
of the online help.