Progress
Version 9
Product Update Bulletin
Reorder AI Extents Example
Additional
AI
extents are needed when you are unable to execute an extent switch because all extents are full, and you are unable to empty the next extent in the sequence for reuse. If an extent switch cannot be performed, your database shuts down, or stalls if you have enabled after-image stall.To add additional
AI
extents, create a.st
file to define the additional extents, and use PROSTRCT ADD to update your database. The PROSTRCT utility operates on databases that are offline. For more information on the PROSTRCT utility, see the Progress Database Administration Guide and Reference . When you add additionalAI
extents, they are added to the end of the extent list. PROSTRCT REORDER AI will move the new, emptyAI
extents, so that they immediately follow the busy extent. Reordering your extents is necessary if the next extent in the switch sequence is not empty. This condition can occur if Fathom Replication has any of your full extents locked. The Fathom Replication lock blocks the user from using RFUTIL to empty the extent so that it may be reused. For more information on Fathom™ Replication, see Progress Fathom Replication User’s Guide .The following series of diagrams illustrates the effect of PROSTRCT REORDER AI on your
AI
extents.Figure O–1 shows the original
AI
extent configuration. The database will shutdown whenA1
fills because it cannot switch to the fullA2
extent.Figure O–1: Original Database AI Extents
![]()
The user must first add additional
AI
extents as Figure O–2 shows.Figure O–2: Database AI Extents After PROSTRCT ADD of Two New Extents
![]()
Adding the new extents is not sufficient to prevent a database shutdown. The database will still shutdown when
A1
is filled because after-imaging still can not switch to the fullA2
extent. Use PROSTRCT REORDER AI to re-arrange the extents. Figure O–3 shows the result of the PROSTRCT REORDER AI:Figure O–3: Database AI Extents After PROSTRCT REORDER AI
![]()
After the reorder is complete, after-imaging can successfully switch extents. The result of the reordering is that the empty extents are moved to immediately follow the busy extent. Their area number and file name extensions have been altered to reflect the move. The physical location and size of the file on disk is not altered.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |