Table 19–7: PROUTIL Utility Qualifiers
Qualifier
|
Description
|
2PHASE BEGIN
|
Enables two-phase commit for a Progress database.
|
2PHASE COMMIT
|
Determines whether the coordinator database committed a transaction.
|
2PHASE END
|
Disables two-phase commit for a Progress database.
|
2PHASE MODIFY
|
Changes the nickname or priority of a Progress database for two-phase commit.
|
2PHASE RECOVER
|
Commits or aborts limbo transactions for a database.
|
BIGROW
|
Specifies the number of BI clusters available to a database.
|
BULKLOAD
|
Loads data files into a database.
|
BUSY
|
Determines whether the database is currently in use.
|
CHANALYS
|
Displays information about free chain blocks.
|
CODEPAGE- COMPILER
|
Compiles a conversion map file from text format to binary format.
|
CONV89
|
Converts a Version 8 database to a Version 9 database.
|
CONVCHAR
|
Converts a database’s character set or identifies a database’s character set (for undefined databases).
|
CONVFILE
|
Converts a text file from one character set to any other character set.
|
DBANALYS
|
Displays statistical information about index, record, and free chain blocks.
|
DBAUTHKEY
|
Sets an authorization key for a database.
|
DBIPCS
|
Displays status information for shared-memory segments attached by all Progress databases on the system.
|
DUMP
|
Performs a binary dump, which is generally faster that an ASCII dump.
|
DUMPSPECIFIED
|
Performs a selective binary dump and allows you to dump by field value.
|
ENABLELARGEFILES
|
Enables large file processing for a database.
|
ENABLEPDR
|
Enables database replication with Peer Direct.
|
HOLDER
|
Determines whether the database is currently in use in single-user mode, multi-user mode, or by a Progress utility.
|
IDXANALYS
|
Displays information on index blocks.
|
IDXCOMPACT
|
Performs index compaction online and increases space utilization of the index block to a specified compacting percentage.
|
IDXMOVE
|
Moves an index from one application data area to another while the database remains online.
|
IDXBUILD
|
Consolidates index records to use disk space as efficiently as possible. Activates deactivated indexes in the database. Repairs corrupted indexes in the database.
|
IDXCHECK
|
Checks Progress database indexes to determine whether an index is corrupt, and if it is, diagnoses the problem.
|
IDXFIX
|
Checks the Progress database records and indexes to determine whether an index is corrupt or a record has a missing or incorrect index. You can scan the database, the indexes, or both.
|
IOSTATS
|
Provides current statistics for active databases. The statistics include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup.
|
LOAD
|
Performs a binary load.
|
MVSCH
|
Moves schema after a database conversion.
|
RCODEKEY
|
Inserts the authorization key into existing CRC-based r-code.
|
TABANALYS
|
Displays information about the degree of fragmentation for each table in a database.
|
TABLEMOVE
|
Moves a table and optionally its associated indexes from one storage area to another while the database remains online.
|
TRUNCATE AREA
|
Truncates application data storage areas in the specified database. Use this qualifier before you remove storage areas and extents.
|
TRUNCATE BI
|
Performs three functions: Uses the information in the before-image (BI) files to bring the database up to date, waits to verify that the information has been successfully written to the disk, then truncates the before-image file to its original length. Sets the BI cluster size using the Before-image Filename (-bi ) parameter. Sets the BI block size using the Before-image Block Size (-biblocksize ) parameter.
|
UPDATEVST
|
Loads the specified database with the most recent virtual system tables.
|
WBREAK- COMPILER
|
Compiles the word-break table.
|
WORD-RULES
|
Compiles a word-rules file that tells Progress that the rules in the specified files apply to a database.
|