Progress
Database Administration
Guide and Reference


Switching To a New AI File

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

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 the RFUTIL AIMAGE NEW utility, the database engine continues writing to the extent until there is no more room left on the disk or the 2GB addressable AI file limit is reached. When the extent becomes full, the database engine automatically switches to the next extent, provided that the next extent is empty.

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 extent and mark it as empty. The system will then automatically switch to that extent and the database activity automatically resumes. For more information on the -aistall parameter, see 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.

Manual Switching To a New AI Extent

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.

Follow these steps 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:
  3. 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 Database Administration Utilities."


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