Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Switching to a new AI file

> You switch to a new AI extent for the following reasons:

> - As part of the backup schedule.

> - When the current fixed-length AI extent is full, or when the disk holding the current variable-length AI extent is full.

> - Before archiving an AI extent.

> Except when you switch to a new extent because the current extent is full, switching to a new AI extent establishes a starting point for backup; after you restore the backup, you roll forward starting from that extent.

> Note: When you perform an online backup, PROBKUP automatically switches over to a new extent as long as the next extent is empty. Before you perform the online backup, make sure that the next extent is empty.

> A fixed-length extent has a predefined size, so the database engine can determine when the extent becomes full.

> In contrast to a fixed-length extent, a variable-length extent does not have a predefined maximum size. Therefore, the database engine cannot anticipate when the extent is about to become full. Unless you force a switch using RFUTIL AIMAGE NEW, the database engine continues writing to the extent until an operating system limitation is reached, you reach the 2GB addressable AI file limit without large files enabled, or there is no more room left on the disk. When the extent becomes full, the database engine automatically switches to the next extent, provided that the next extent is empty. For more information on large files, see the "PROUTIL ENABLELARGEFILES qualifier" section.

> If the next extent is full, the database engine shuts down the database. However, you can use the After-image Stall (-`aistall`) parameter to suspend database activity and send a message to the log file or you can use the RFUTIL qualifier AIMAGE AIOFF to disable after-imaging. If you use `-aistall`, you can archive the oldest full extent and mark it as empty. The system will then automatically switch to that extent and resumes database activity automatically. For more information on the -`aistall` parameter, see Chapter 18, " Database Startup Parameters." If you use RFUTIL AIMAGE AIOFF, after-imaging becomes disabled and can no longer write notes.

> Note: You can only use the -`aistall` parameter and RFUTIL AIMAGE AIOFF in multi-user mode.

> When the database engine suspends database activity or shuts down the database, it sends the following message to the log file:

>     Can’t switch to after-image extent filename it is full.
>     Backup ai extent and mark it as empty (3774)

> The database engine cannot resume database activity until the next extent is backed up and marked as empty.

> You can manually perform an online AI extent switch if you want to archive the AI file at regularly scheduled times instead of waiting until the extent becomes full.

> | To switch to the next extent in the sequence:

> 1. Make sure the next extent in the sequence is archived. If not, archive it. See the "Archiving an AI file" section for details.

> 2. Use the RFUTIL AIMAGE NEW utility with the following syntax:

>     rfutil db-name -C aimage new

> When you issue the RFUTIL AIMAGE NEW command, RFUTIL changes the status of the current extent to full and changes the status of the next file to busy. For more information on this command, see Chapter 22, " RFUTIL Utility."

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095