Kbase P100365: More memory and disk space needed if cluster size changed and "bigrow" used?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
More memory and disk space needed if cluster size changed and "bigrow" used?
GOAL:
More memory needed if cluster size changed?
GOAL:
More disk space needed if "bigrow" used?
FIX:
Not more memory will be used if the Before Image (BI) cluster size is changed.
More disk space might be used with a larger cluster size as the BI file contains a multiple of clusters.
More disk space will be used for the database if the number of BI clusters created is higher than the number of BI clusters needed.
The cluster size is changed with the command:
proutil <db> -C truncate bi -bi <cluster_size>
It does not affect the shared memory usage as it does not make any change to the BI buffers within memory.
With the following command a certain number of clusters are created within the BI file prior to starting the database:
proutil <db> -C bigrow <number>
The BI file will grow if its non fixed extent will contain the clusters created.