Progress
Database Administration
Guide and Reference
After-image Areas and Extents
You can define multiple AI areas in the structure description (ST) file, which lets you create AI areas on multiple disk volumes and perform online backups while AI is enabled. Regardless of how many AI areas are defined, each AI area contains only one extent. Before defining the AI extents, consider the following:
- The database engine fills the AI areas in the order that you define them in the structure description file. When you are defining areas, you can store more than one AI area on a disk. However, you should store all the AI areas on disks other than the one that contains the database (DB) files or primary recovery area (BI) files.
- For both fixed-length and variable-length extents, the database engine automatically switches extents when the current extent becomes full, as long as the next extent is empty. If you define three large fixed-length extents, you can use extent 1 for a full day’s worth of transactions, and have extent 2 empty and ready to use when you need to switch over to the next extent. This also leaves extent 3 available if you perform an unusually high number of transactions and use both extents 1 and 2.
The database engine uses AI areas sequentially, in the order defined in the structure description file. AI area filenames have a .an extension, where n indicates the numerical order in which you defined the area. After it uses the last area, the database engine reuses the first area if it is empty. Figure 11–1 illustrates this behavior. An extent switch is the operation of switching from one AI area extent to another.
Figure 11–1: After-image Extents Switching
![]()
You must monitor the status of the extents to ensure that you do not try to reuse an unavailable file. For information on monitoring the status of your AI extents, see the "Monitoring AI File Status" section in this chapter.
Like DB and BI extents, there are two types of AI extents:
Fixed-length Extents
Fixed-length extents are extents that you preallocate and preformat in the structure description file. With fixed-length extents, you control how much disk space each extent uses.
Variable-length Extents
Variable-length AI extents do not have a predefined length. They continue to fill until they use the entire disk, you back up the database, or you issue the RFUTIL AIMAGE NEW command. The initial length of a variable-length extent is 128K. Like DB areas, you can define more than one variable-length AI area for a single database.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |