Relation betwwen AI roll forward and BI file growth.

[AmolMone]

Is there any relation between AI rollforward and BI file growth? My observation is AI roolforward is causing BI to grow to huge size above 10G. Does any one has any experience on this?

 

[cj_brandt]

1) Progress version, Service Pack and product
2) OS and version

What is the size of the BI file on your source database when the AI logs were being created.

 

[RealHeavyDude]

I am not 100% positive but I assume that it takes roughly the same amount of before image information to roll the transactions forward as it does to process the transactions against the live database. On the other hand, as far as I know, rolling forward the after image the transactions are processed sequentially one by one therefore I guess that a long running transaction on the live system should not need that much before image space to be locked when is rolled forward.

Here I must admit that I never had any issue like that ...

Heavy Regards, RealHeavyDude.