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
Code pages and national language support
Working with Rational® ClearQuest® data code pages
After you determine the appropriate Rational® ClearQuest® data code page and create a vendor database instance with the corresponding vendor database character set, you can perform the tasks outlined in this topic.
Ensuring characters in database sets are supported in a Rational® ClearQuest® data code page
If you are using Rational® ClearQuest® for the first time, the GUI-based tools provide support to set up and manage data code pages for your schema repositories. Also, for many previous users of Rational ClearQuest whose data code pages were set to US-ASCII, the GUI provides all required code page functionality.
The codepageutil and installutil subcommands and data code page
This topic discusses which codepageutil subcommands to use to evaluate Rational® ClearQuest® data code page compatibility, and which installutil subcommands to use to display and set the Rational ClearQuest data code page.
Using installutil to set the data code page value for a pre-7.0 schema repository
After you use the codepageutil utility to evaluate an existing database set and convert any unsupported characters, you can use the installutil utility to set its Rational® ClearQuest® data code page value.

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
    - 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
      - About national language support
      - Preparing to configure national language support
      - Working with Rational® ClearQuest® data code pages
        After you determine the appropriate Rational® ClearQuest® data code page and create a vendor database instance with the corresponding vendor database character set, you can perform the tasks outlined in this topic.
        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.
        Changing the ClearQuest® data code page value
        You can change the Rational® ClearQuest® data code page of your schema repository from 20127 (ASCII) to a non-ASCII code page at any time without corrupting the data.
        Ensuring characters in database sets are supported in a Rational® ClearQuest® data code page
        If you are using Rational® ClearQuest® for the first time, the GUI-based tools provide support to set up and manage data code pages for your schema repositories. Also, for many previous users of Rational ClearQuest whose data code pages were set to US-ASCII, the GUI provides all required code page functionality.
        Developing a data conversion strategy
        The codepageutil and installutil subcommands and data code page
        This topic discusses which codepageutil subcommands to use to evaluate Rational® ClearQuest® data code page compatibility, and which installutil subcommands to use to display and set the Rational ClearQuest data code page.
        General guidelines for using the code page utility
        Running the code page utility codepageutil
        Applicability
        Applicability
        Evaluating codepageutil output data
        Using the code page utility with Rational® ClearQuest® MultiSite
        Using installutil to set the data code page value for a pre-7.0 schema repository
        After you use the codepageutil utility to evaluate an existing database set and convert any unsupported characters, you can use the installutil utility to set its Rational® ClearQuest® data code page value.
        Applicability
        installutil setdbcodepage
        Adding and removing code page headers from exported files
        You can use the cpheader command to add and remove data code page header information to and from exported workspace items (queries, charts, reports, and report formats) and form files created by using the original Rational® ClearQuest® Designer.
  - 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 installutil to set the data code page value for a pre-7.0 schema repository

After you use the codepageutil utility to evaluate an existing database set and convert any unsupported characters, you can use the installutil utility to set its Rational® ClearQuest® data code page value.

Before you begin

You must perform the following steps before you can set your data code page value:

Disconnect all Rational® ClearQuest® clients from the schema repository and user databases. If you do not, connected clients can still enter data outside the new code page after you set the Rational® ClearQuest® data code page value, .
Back up the schema repository and all user databases.

About this task

Starting with ClearQuest® version 7.0, the standard method for setting the Rational® ClearQuest® data code page for a new schema repository or connection is to use the Maintenance Tool. However, you can also use the installutil utility to set the data code page value.

The commands in this example use MyDBset as the name of the database set.

Procedure

From a Windows™ system, run the installutil lscodepage command to determine the local character set of your operating system and the data code page for your schema repository.
```
installutil lscodepage -dbset MyDBset admin_user admin_password
```
```
Code page of MyDBset: 932 (Japanese (Shift-JIS))  
Code page of client: 1252 (MS Windows Latin 1)
```
In this example, the local character set is 1252 (MS Windows™ Latin 1. The Rational® ClearQuest® data code page value of the MyDBset schema repository is currently set to 932 (Japanese (Shift-JIS)).
Then, run the installutil setdbcodepage subcommand to set the Rational® ClearQuest® data code page to the preferred value.
For a list of code pages supported by Rational® ClearQuest®, see Supported data code pages
installutil setdbcodepage -dbset MyDBset 1252 admin_user admin_password

Results

The data code page for your schema repository is now set and any user databases you create inherit this data code page setting.