Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Truncating the BI file

> Truncating the BI file resets the file to its minimum size. You should plan ahead to determine the amount of disk space required to hold all the files required to process at your peak transaction rate. However, under certain circumstances, the BI file might grow unusually large. This usually occurs because of a long-running transaction, for example, if a user leaves the terminal for a long period in the middle of a transaction. If a situation like this occurs, you can truncate the BI file.

> When you truncate the BI file, the database engine uses the information in the BI files to bring the database and AI files up to date, waits to verify that the information has been successfully written to the disk, then truncates the primary recovery file to its minimum length.

> To truncate the BI file, use the TRUNCATE BI qualifier of the PROUTIL utility:

>      proutil db-name -C truncate bi

> In this command, `db-name` specifies the database you are using.

> See the description the "PROUTIL TRUNCATE BI qualifier" section for a complete description.

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