Progress
Database Administration
Guide and Reference


PROUTIL TRUNCATE BI Qualifier

Performs three functions:

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C truncate bi
{ [ -G n ] | -bi size | -biblocksize size }

db-name

Specifies the database you are using.

-G n

Specifies the number of seconds the TRUNCATE BI qualifier waits after bringing the database and AI files up to date and before truncating the BI file. The default wait period is 60 seconds. You might specify a shorter period for practice or test purposes. However, do not do so for any significant database, because a system crash could damage the database if the BI file is truncated before the writes to the database and AI files are flushed from the operating system buffer cache.

-bi size

Specifies the size of the cluster in kilobytes. The number must be a multiple of 16 ranging from 16 to 262,128 (16K to 256MB). The default cluster size is 524K. If you use a value that is not a multiple of 16, PROUTIL rounds the value up to the next multiple of 16.

-biblocksize size

Specifies the size of the BI blocks in each buffer in kilobytes. The valid values are 1, 2, 4, 8, and 16. The default -biblocksize is 8K. A value of 0 tells Progress to use the default block size. The block size cannot be smaller than the database block size.

NOTES


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