Progress
Database Administration
Guide and Reference


PROUTIL Utility

Performs various database operations, depending on the parameters and qualifiers you supply.

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C qualifier 

db-name

Specifies the database you are using.

-C

Specifies a particular utility or function when you use PROUTIL.

qualifier

Specifies the qualifier that you want to use. You can supply the qualifiers described in Table 19–7.

NOTE: PROUTIL and its qualifiers support the use of internationalization startup parameters such as -cpinternal codepage and -cpstream codepage. See "Database Startup Parameters," for a description of each database-related internationalization startup parameter.

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.

The following PROUTIL entries describe each of these qualifiers. See the appropriate section for more detailed information.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095