Information

Title	How to truncate the BI File

URL Name	000033987

Article Number	000157088

Environment	Product: Progress Version: All supported versions Product: OpenEdge Version: All supported versions OS: All supported platforms

Question/Problem Description

How to truncate the BI file?
How do I truncate the BI file?
How can BI file be truncated?
When does the BI file need to be truncated?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

Open a proenv command prompt Progress environment and use the following command to truncate the BI file:

$ proutil <dbname> -C truncate bi

For further information refer to Article: When do you need to truncate the BI file(s)?

OpenEdge 11.6.1 enabled two new parameters to assist in predicting how long crash recovery will take and report on how many transactions are involved :

Crash Recovery Status (-crStatus) defaults to 30 seconds when not specified.
Crash Recovery Transaction Display (-crTXDisplay) must be specified to enable it.

For further information refer to Article: How to display how far along bi crash recovery is within the whole process?

Workaround

Notes

References to Other Documentation:

Manage the OpenEdge Database: PROUTIL Utility - PROUTIL TRUNCATE BI qualifier
https://docs.progress.com/bundle/openedge-database-management/page/PROUTIL-TRUNCATE-BI-qualifier.html

Keyword Phrase

Last Modified Date	9/23/2020 4:31 PM

How to truncate the BI File

Information