Kbase P25074: When do you need to truncate the BI file(s)?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/2008 |
|
Status: Verified
GOAL:
When will the BI file(s) need to be truncated?
GOAL:
When should a BI file be truncated?
GOAL:
Why am I receiving messages telling me to truncate the BI file?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Some Progress utilities need to be run on a database which is in an up-to-date state (i.e. no outstanding transactions pending in the database). If this is not the case Progress will warn that the BI file(s) need to be truncated or truncate the BI file(s) automatically before running the utility.
To truncate the BI file use the following command:
proutil <database name> -C truncate bi
Some messages you may encounter when running a Progress utility which require a BI file to be truncated:
Use proutil to truncate bi file before analyze. (4691)
The BI file is being automatically truncated. (1526)
You must use the proutil truncate bi command before doing a remove. (6953)
** You should run TRUNCATE BI utility before backing up your database (851)
When the truncate BI command is issued, the following will occur:
· Uses the information in the before-image (BI) files to bring the database and after-image (AI) files 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 Cluster Size (-bi) parameter.
· Sets the BI block size using the Before-image Block Size (-biblocksize) parameter.