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 additional AI extents, they are added to the end of the extent list. PROSTRCT REORDER AI will move the new, empty AI 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 when A1 fills because it cannot switch to the full A2 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 full A2 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