Consultor Eletrônico



Kbase P18166: How to reduce the number of bi extents
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Unverified

GOAL:

How to reduce the number of bi extents

GOAL:

How to shrink the Before Image (BI)

GOAL:

How to reduce the BI file size

FIX:

After having run:
proutil <dbname> -C truncate bi
you may suppress one BI extent with the command "prostrct remove".

The V9, V10 syntax is:
prostrct remove <dbname> bi
The V8 syntax is:
prostrct remove <dbname> b

If you want your last BI extent to be none fixed, then you will need to remove the last fixed BI extent prior to adding a new non-fixed one.
With a file "add.st" containing:
b . /dir1/dir2
the command, for V8, V9 and V10,
prostrct add <dbname> add.st
adds a last non fixed BI extent.