Kbase P135714: Ever since converting to type 2 storage areas, the redo phase of database startup is taking longer a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/06/2009 |
|
Status: Verified
SYMPTOM(s):
Ever since converting to Type II storage areas, the database startup is taking longer and longer.
After truncating the BI file, database startup is faster.
The physical redo phase of database startup is taking longer and longer to execute.
FACT(s) (Environment):
Windows 32 Intel
OpenEdge 10.1B
CAUSE:
The BI cluster size was changed after converting to Type II storage areas. The database log file showed that prior to converting to Type II storage areas, the BI cluster size was set to 12,228. After converting, the database log file showed that the BI cluster size had been changed to 512. The smaller BI cluster size is causing new BI clusters to be allocated during the startup because the old clusters could not be reused due to the cluster age time not being reached. The BI file grew with each database startup making the physical redo phase take longer and longer to get through all of the clusters.
FIX:
Change the BI cluster size back to the value being used before converting to Type II storage areas.
Use the proutil utility to change the BI cluster size.
Command: proutil <dbname> -C truncate bi -bi <BI cluster size in bytes>