Salesforce

After image files added online with fixed variable size grow beyond their specified limit

« Go Back

Information

 
TitleAfter image files added online with fixed variable size grow beyond their specified limit
URL Name000032729
Article Number000152435
EnvironmentProduct: OpenEdge
Version: 10.2B04, 10.2B05, 10.2B06, 11.0x, 11.1.0
OS: All supported platforms
Question/Problem Description
AI files added online do not switch automatically when they reach their fixed variable size.
Fixed-Variable After-Image files cause disks to fill or reach quota or ulimit when added online.
After image files added online with fixed variable size switch at Database 2GB limit when largefiles are not enabled instead of their fixed-variable size.
Online added after image files do not switch at their fixed variable limit.
Steps to Reproduce
Clarifying Information
Fixed Variable AI files in use.
Pre-existing AI fixed variable files do switch when their fixed-variable size limit is reached.
Error Message
Defect NumberDefect PSC00245461 / OE00222318
Enhancement Number
Cause
The fixed variable size limit is not set for the extent when added online in the active memory structures. 
Resolution
Upgrade to OpenEdge 10.2B07, 11.1.1.0, 11.2 or later where the maxvlen field is properly set in the active structures for extents added online
Workaround
The following Workarounds subvert this behaviour:

Option 1: Restart the database, the new AI files added online previously will switch as expected when their fixed-variable extent size is reached.

Option 2: Until the database can be restarted, as opposed to relying on when the fixed variable size is reached force an ai switch.

a. If the database is enabled for AI Management (AIMGT), change the aiarchive interval mode from "ON DEMAND" to "TIMED" to force the ai switch at a timed interval:
$ rfutil dbname -C aiarchiver setinterval {120 ... 86,400}

b. If the AIMGT deamon is not in use, then ensure that the 'rfutil' scripts which manage the database ai files include a manual switch at timed intervals:
$ rfutil dbname -C aimage new

Option 3: Restructure AI files to Fixed Extents as opposed to Fixed Variable extents if 'automatic' ai switching is required by the after-imaging implementation.

Stop the database then disable After Imaging:
$  rfutil dbname -C aimage end

Run the following command as many times as there are ai files:
$  prostrct remove dbname ai

Create a new structure file defining AI files with fixed AI extent format:

a . f 20480
a . f 20480
a . f 20480


Add ai files back to the database:
$  prostrct add dbname addai.st

Re-enable After-Imaging and AI Archiver (if required):
$  rfutil dbname -C mark backedup
$  rfutil dbname -C aimage begin
$  rfutil dbname -C aiarchiver enable
 
 
Notes
Keyword Phrase
Last Modified Date1/18/2016 1:50 PM

Powered by