Views Reply Votes
Legacy Post
Legacy
 288
2 Gig after-image variable file limit
2138
2
0 (0 Votes)
Posted: Jan 03, 2011   
Votes
Legacy Post
Legacy
 288
Replied 
Hello Joseph,
An AI variable extent will grow over 2GB's if you have large files enabled on the database. AI will not switch over at any point and will actually crash if you reach either the 2GB or system file size limit with large files enabled. The aistall parameter will prevent a crash in these cases. Please see Progress solution P88219 at the following link for more information.
http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress
Regards,
Ernest Hutchinson
Support Analyst
QAD Inc.
0 (0 Votes)
Replied: Jan 03, 2011
Votes
Legacy Post
Legacy
 288
Replied 
Hello Joseph,


I have some more information regarding your question. Progress solution p103761 may lead you to think that AI would switch in your case. I called Progress and confirmed that an OS or the 2GB limit will prevent the AI extent from switching to the next empty. The note in p103761 is as follows...


OpenEdge RDBMS fills a variable extent until any of the following happens:
The extent uses up the entire disk, The disk is full, You manually switch to a new AI extent or You disable after-imaging. After using the last available empty extent in the sequence of AI extents, OpenEdge RDBMS would loop back and use the first available empty extent, a round robin mode of operation.



Therefore if a full disk was hit AI would switch but hitting the 2GB or OS limit will crash the database


Regards,
Ernest Hutchinson
Support Analyst
QAD Inc.
0 (0 Votes)
Replied: Jan 03, 2011
Forums
All
Forum Help
Help Using Forums