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.
installutil setdbcodepage

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

installutil setdbcodepage

Sets the value of the Rational® ClearQuest® data code page to a supported Windows™ code page.

Applicability

Platform: Windows™

Command type: installutil subcommand

Synopsis

installutil setdbcodepage: [–dbset dbsetName] [-force] [-allowconversion] [-verbose] codePage adminUser adminPassword

Description

The installutil setdbcodepage subcommand sets the value of the Rational® ClearQuest® data code page to a supported Windows™ code page.

Important: This command does not guarantee that text that is stored in the database set is compatible with the data code page setting.

Options and arguments

dbsetName: The name of the database set or connection that contains the database to set.
-force: Set the data code page to a local character set value even if the database validation failed.
Important: Using the -force option is highly discouraged.
-allowconversion: Sets the data code page to the specified value, even if there are characters in your database that are not stored correctly when they are moved from the Rational® ClearQuest® client to the vendor database.
Important: Using the -allowconversion option might cause data corruption. Use this option only after you run the installutil setdbcodepage subcommand with the -verbose option to determine whether your database contains characters that are not stored correctly when they are moved to the vendor database.
-verbose: Lists the characters in a Rational® ClearQuest® database that are not stored correctly when they move from the Rational® ClearQuest® client to a vendor database. The replacement characters are also displayed.
codePage: The Windows™ code page number to which to set the Rational® ClearQuest® data code.
adminUser: The login name of an administrative user. This user must have the Super User privilege.
adminPassword: The password for the adminUser user. If there is no password, enter an empty set of double quotation marks ().

Example

Set the Rational® ClearQuest® data code page for the mydbset database set to the local character set value 1252 (ANSI - Latin I).

installutil setdbcodepage -dbset mydbset 1252 admin secret

Validating that database MASTR supports code page 1252 (ANSI - Latin I)...

Successfully validated all databases. Successfully set the code page to: 1252 (ANSI - Latin I)