Welcome
Administering
Learn how to administer the product.
Administering Rational® ClearQuest®
Learn how to administer the Rational® ClearQuest®.
Managing databases
Describes the different types of databases that the administrator can create and manage
Connections and database sets
Using the installutil commands registeroracleoptions and getoracleoptions

IBM ClearQuest 10.0.9
Overview
Learn general information about the product.
Installing
Learn how to install the product.
Upgrading and migrating
Learn how to upgrade and migrate data for the product.
Administering
Learn how to administer the product.
- Administering Rational® ClearQuest®
  Learn how to administer the Rational® ClearQuest®.
  - Reconfiguring ClearQuest® to use a different JRE
    When you change the Java Runtime Environment (JRE) for Rational® ClearQuest®, you must reconfigure the product to make it work with the new JRE.
  - Managing databases
    Describes the different types of databases that the administrator can create and manage
    - Tools for managing databases
    - Database backup procedures and schedules
    - Vendor databases
    - Schemas and schema repositories
    - User databases
    - Connections and database sets
      - Creating a connection
        You can create a connection when you are creating a schema repository or at a later time.
      - Editing a connection
        You can edit the properties of a database connection. Editing a connection affects only the local connection information on the client computer.
      - Renaming a connection
        You can rename the default name the Maintenance Tool applies to your connections. For example, you can rename a connection to a shorter name or to a name that is more recognizable for your team.
      - Duplicating an existing connection
        When creating a new schema repository with properties similar to an existing database, you can duplicate an existing connection to match the new schema repository.
      - Deleting and restoring a connection
        Unneeded connections can be deleted. Connections are maintained independently on each client computer. Deleting a connection on one client computer does not affect connections on other computers.
      - Using the installutil commands registeroracleoptions and getoracleoptions
      - Using the relocateschemarepo and relocateuserdb commands to update database information
      - How to use the installutil recreateindexes command
    - Connection profiles
    - Modifiable master properties
      You can modify several master properties in a Rational® ClearQuest® database set if your account has the Super User privilege.
    - Code pages and national language support
  - Managing user accounts
    Use the User Administration tool to set up and administer users and user groups. Rational® ClearQuest® stores information about users and user groups in the user database and schema repository.
  - Configuring query limits on result sets
    You can configure query limits on the size of result sets to improve system performance, availability, and scalability.
  - Using LDAP with Rational® ClearQuest®
    Overview of user authentication methods available with Rational® ClearQuest®.
  - Workspace folder permissions overview
    Rational® ClearQuest® uses a role-based access control (RBAC) model for enforcing workspace folder permissions. The workspace folder permissions feature requires that your schema repository and user databases are at feature level 6 or later.
  - Optimistic and pessimistic record locking
    Overview of optimistic and pessimistic locking implementations in Rational® ClearQuest®.
  - Configuring ClearQuest® core logging and tracing
    This section describes how to configure logging and tracing for ClearQuest® core.
- Administering Rational® ClearQuest® Web
  This section discusses how to administer Rational® ClearQuest® Web.
- Administering Rational® ClearQuest® Multisite
  Administering Rational® ClearQuest® Multisite
Reporting
Learn how to generate reports for the product.
Developing
Learn how to develop schemas by using the Rational® ClearQuest® Designer.
Managing change and releases
Learn how to manage change and release in the product.
Integrating
You can integrate Rational® ClearQuest® with other software by adding packages to existing schema.
Extending product function
Learn how to extend the product.
Reference
Review reference information for the product.
Tutorials

Using the installutil commands registeroracleoptions and getoracleoptions

The installutil registeroracleoptions command enables an override for the connect options of Oracle-based Rational® ClearQuest® databases. This command should only be used for troubleshooting purposes or special circumstances. In a majority of cases, the connect options for schema repositories and user databases suffice for defining Oracle connection information.

Here is the syntax for this command:

installutil registeroracleoptions "<connect_options>"

You provide the same connect option values as you would in the Rational® ClearQuest® Maintenance Tool and Rational® ClearQuest® Designer.

Here is an example:

installutil registeroracleoptions "PORT=1523"

Installutil getoracleoptions is the Rational® ClearQuest® command line tool that will display the entry you have specified with installutil registeroracleoptions command. There is no syntax. You only need to run this command:

installutil getoracleoptions

If you have not previously run the registeroracleoptions command, you will receive this error message:

Failed to read from registry: "Software\Rational Software\ClearQuest\2003.06.00\Core", name: "OverrideOracleConnectOptions".

On UNIX® & Linux® Operating Systems

The installutil command does not exist with Rational® ClearQuest® on UNIX or Linux platforms. However, you can define the Oracle override environment variable CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS. Here is an example of setting this variable and viewing it with a C shell:

setenv CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS "PORT=1523"

echo $CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS