Kbase P25890: What does -aistall do?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/05/2003 |
|
Status: Unverified
GOAL:
What does -aistall do?
GOAL:
How to use -aistall.
FACT(s) (Environment):
Progress 9.x
FIX:
The following is extracted from the documentation:
Use After-image Stall (-aistall) to suspend database activity if all AI files are filled. -aistall ceases all database activity and continues to send the following message to the log file until the AI extent is emptied:
Can·t switch to after-image extent <filename> it is full. (3775)
Backup ai extent and mark it as empty (3776)
When using after-image (AI) files, monitor the status of the files to ensure that the AI extents do not run out of space and cause the database to hang. Without the use of -aistall, the database shuts down when the AI files are filled.
---------------------------------------------------------------------
An example of -aistall with sports, using 91D05 on Unixware 7.1.1.
1. prodb sports sports
2. Create an add.st to add ai extents:
echo "a . f 128" > add.st
Note that the extent is small so that the behaviour can be quickly seen.
3. prostrct add sports add.st (Do this several times). A production database should be backed up before adding an extent like this.
4. probkup sports sportsbak - Has to be done before ai can be started.
5. rfutil sports -C aimage begin
6. proserve sports -aistall. A 4254 message appears in the lg:
After-Image Stall (-aistall): Enabled. (4254)
7. Start a session and run the following:
/* addrecord.p */
/* for testing involving database growth */
def var newnum as int.
find last cust.
newnum = cust-num.
repeat:
newnum = newnum + 1.
create cust.
assign
cust-num = newnum.
display cust-num.
pause 0 no-message.
if cust-num = 500000 then leave.
end.
8. The code runs, and ai extents are switched. Once the last extent is Full, it tries to switch but errors out with the 3775 and 3776. Processing is suspended on the database.
9. rfutil sports -C aimage list shows the status of each ai file.
10. rfutil -C aimage extent empty can be used to empty the extents, e.g. rfutil sports -C aimage extent empty 1
Processing then continues.