If you want to change the data code page of an existing Rational® ClearQuest® schema
repository, you must verify that the databases associated with that
schema repository do not contain characters that are outside the planned
data code page. You must identify and convert such characters before
you change the data code page.
The code page utility codepageutil helps
you with these tasks. It provides two commands. codepageutil
test_codepg checks which character set a database can
handle. codepageutil analyze_tables locates
characters in an existing database that are not supported for a target
data code page setting, and must be converted to valid characters
to ensure data integrity.
For example, if you decided that, because there are UNIX database servers in your
Rational ClearQuest environment,
you want to convert a
Rational ClearQuest database
from code page
932 (Japanese) to code page
60932 (Japanese
with safe Shift-JIS encoding), you can use the code page utility to
perform the following tasks:
- Determine whether changing the data code page for a Rational ClearQuest schema
repository or database will require any data conversion.
- If data conversion is necessary, estimate the amount of work required
to convert the database, by counting the number of characters in the
database that are unsupported in data code page 60932.
- If data conversion is necessary, identify the location of each
character that is unsupported for code page 60932; that is, the table,
the record and record ID, and the field name and position in the field,
where each unsupported character is located.