Information

Title	What does -aistall do?

URL Name	P25890

Article Number	000151726

Environment	Product: Progress Product: OpenEdge Version: 9.x, 10.x, 11.x, 12.x OS: All supported platforms.

Question/Problem Description

What does -aistall do?
How to use -aistall.

Steps to Reproduce	1. prodb sports2000 sports2000 2. Create an add.st to add ai extents: echo "a . f 128" > add.st NOTE: The extent is small so that the behaviour can be quickly seen. 3. prostrct add sports2000 add.st (Do this several times). A production database should be backed up before adding an extent like this. 4. probkup sports2000 sports2000.bkp - Has to be done before After Imaging can be started. 5. rfutil sports2000 -C aimage begin 6. proserve sports2000 -aistall NOTE: A 4254 message appears in the lg: After-Image Stall (-aistall): Enabled. (4254) 7. Start a Progress / OpenEdge client 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. NOTE: 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 sports2000 -C aimage list shows the status of each ai file. 10. rfutil -C aimage extent empty can be used to empty the extents Example: rfutil sports2000 -C aimage extent empty 1 Processing then continues.

Steps to Reproduce

1. prodb sports2000 sports2000

2. Create an add.st to add ai extents:
echo "a . f 128" > add.st
NOTE: The extent is small so that the behaviour can be quickly seen.

3. prostrct add sports2000 add.st (Do this several times).
A production database should be backed up before adding an extent like this.

4. probkup sports2000 sports2000.bkp - Has to be done before After Imaging can be started.

5. rfutil sports2000 -C aimage begin

6. proserve sports2000 -aistall
NOTE: A 4254 message appears in the lg:
After-Image Stall (-aistall): Enabled. (4254)

7. Start a Progress / OpenEdge client 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.
NOTE: 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 sports2000 -C aimage list shows the status of each ai file.

10. rfutil -C aimage extent empty can be used to empty the extents
Example:
rfutil sports2000 -C aimage extent empty 1

Processing then continues.

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

The -aistall is a database start up parameter.
When a database is enabled for After Imaging and one of the following conditions has been encountered:

1) A command was issued to perform a probkup (which triggers the switch to the next empty AI file)
2) An rfutil <dbname> -C aimage new command was issued (which triggers the switch to the next empty AI file)
3) The current AI file can no longer be written to either because the file is configured as a fixed length extent and all of the space is used or the file is configured as a variable extent and no additional space exists on the file system (or the operating system maximum file size has been reached)

the -aistall option will suspend updates to an OpenEdge database.

Until empty AI files are made available (and are the next in order after the current busy AI file) the OpenEdge database is online but only read operations from shared memory connected clients are permitted.
All operations attempting to update the database will hang until empty after image files are made available to the database.

Prior to OpenEdge 10.1A it was common for customers to use scripts to manage the archiving of FULL after image files and then emptying these full after image files.

Beginning in OpenEdge 10.1A a feature was created named After Image Archive Manager which can be configured to manage the automated archiving of full AI files and emptying out the AI files once they have been successfully archived.

Note: The -aistall parameter will be automatically be set to enabled while the ai archiver is enabled, this is a requirement.

Workaround

Notes

References to written documentation:

https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmadm/after-image-stall-(-aistall).html

Keyword Phrase

Last Modified Date	2/16/2022 2:56 PM