analyze_tables

Platform: Windows

Command type: codepageutil subcommand

codepageutil analyze_tables

dbset_name db_name login password codepage output_file_name [ -master sitename ] [ -xml ] { -all | table ... }

The codepageutil analyze_tables command counts and identify all the characters in a schema repository that are not in a specified code page.

The analyze_tables subcommand scans all character fields in all tables in a Rational® ClearQuest® schema repository or an associated Rational ClearQuest database, including multiline text fields and character large objects or CLOBs. If it finds a character not included the given data code page, it tallies and records that character.

analyze_tables does not scan attachments or binary large objects (also referred to as BLOBs), even though these may store characters.

The analyze_tables subcommand can scan either an entire database, or a specified group of tables.

The analyze_tables subcommand provides a variety of statistics about how many characters in the database are not supported by the preferred code page.

dbset_name

The name of the database set or connection that contains the database to be analyzed.

db_name

The logical name of the schema repository, master database, or user database to be checked. Note that the db_name for the master database is always MASTR.

login

The Rational ClearQuest login name of the user. This user must have super user privileges.

password

The Rational ClearQuest password for the user. If there is no password, enter an empty set of double quotes.

codepage

The code page setting for which you are analyzing the target database.

output_file_name

The path and name of the file that contains the results from the analyze_tables command. Enclose the path name in double quotes if there is a space in the path name or other characters. If the XML option is specified, the output file is in UTF8 encoding. Otherwise, the output file is in the encoding of the system's code page.

-master sitename

An optional parameter used for Rational ClearQuest MultiSite that specifies that only records mastered by sitename are to be scanned.

-xml

An optional parameter to specify that the output file be created in XML format.

-all | table ...

Use -all to specify that all tables in the target database are scanned, or use table ... to specify the names of one or more individual tables to be analyzed.

• Scan all tables in the SAMPL database for any characters that are excluded from the ASCII data code page and store the results in the file anafileASCII.txt in the directory path specified.

  codepageutil analyze_tables Connection3 SAMPL admin "" 20127 "C:\reports\anafileASCII.txt"
  
  -all
  

• Scan the Defect table in the SAMPL database for any characters that are excluded from the Latin-1 data code page and write detailed information in XML format to the file anafileLATIN1.xml in the directory path specified.

  codepageutil analyze_tables Connection3 SAMPL admin "" 1252 "C:\reports\anafileLATIN1.xml"
  
  -xml Defect
  

• Scan all the records from the SAMPL database that are mastered in site Boston for any characters that are not part of the ASCII data code page and write detailed information to the file analyzeout4.txt in text format.

  codepageutil analyze_tables Connection3 SAMPL admin "" 20127 analyzeout4.txt
  
  -master Boston -all
  

codepageutil test_codepage, installutil lscodepage, installutil setdbcodepage.