enablelargefiles and AI Questions

[jdrouil]

Hello, I am in an AIX 5.2 environment, Progress 9.1E04. QAD 9.1E.

Our AI (after-image) files for the main database are variable length and will therefore max out at 2 gig. Will it automatically cut over to a new AI extent, assuming one is available? The documentation is a bit unclear.

I am not sure if large files are enabled. But if not, what will it buy me if I enable large files?

I have seen mention of an AI Archiver in another post, but cannot find in my version of the Progress Data Admin Guide. Is this something available in a later version of Progress only?

Thanks!

 

[rstanciu]

try an proutil [database] -C describe, I'm not shure if works in 9.1E
but the enable large files works: proutil [database] -C enablelargefiles (database server offline).

aiarchiver don't works with your version, aiarchiver arrives with v.10

 

[jdrouil]

I found out that at the 2gb limit, or if disk is full, the database will halt.

Therefore the solution is to go with fixed-variable extents that max out before the 2gb limit, and should switch successfully to the oldest extent, if empty.

 

[tamhas]

How fast are you filling up the AI files? I can't imagine allowing an AI file to get anywhere near 2GB before wanting to switch. With a reasonable switching strategy, the 2GB limit should be moot.