Kbase P63636: How to change or set a new value for BI cluster size?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/24/2009 |
|
Status: Verified
GOAL:
How to change or set a new value for BI cluster size?
GOAL:
How to change or set a new value for BI block size?
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Use PROUTIL with TRUNCATE BI Qualifier.
This qualifier Performs three functions:
1)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.
2) Sets the BI cluster size using the Before-image Cluster Size (-bi) parameter.
3) Sets the BI block size using the Before-image Block Size (-biblocksize) parameter.
SYNTAX
proutil db-name -C truncate bi { [ -G n ] | -bi size | -biblocksize size }
Where
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.