Kbase P159567: Truncation of the bi files is taking several minutes even though the bi file is very small.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2010 |
|
Status: Unverified
SYMPTOM(s):
Truncation of the bi files is taking several minutes even though the bi file is very small.
Truncation of the bi file is taking 3 to 4 minutes.
Syntax of command is: proutil <dbname> -C truncate bi
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
CHANGE:
Migrating from Version 9.1x to a newer release of Progress and all bi files are being truncated first.
CAUSE:
When the proutil truncate bi file command is used the -G parameter defaults to 60 prior to Release 10. This can added a lot of time to the truncation process.
FIX:
Use the -G 0 parameter to reduce the wait time at the start of the truncation of the bi file.
example:
proutil <dbname> -C truncate bi -G 0
Caution: This value should not be change in production after a crash. Damage to the database could occur if the BI file is truncated before the writes to the database and AI files are flushed from the operating system buffer cache. .