To create AI extents on an existing database:1. Define the number and locations of the AI extents. For further clarification refer to Article
How to determine the amount of AI file space required? 2. Create a Text file using any text editor (Notepad, Edit, vi, Progress Procedure Editor), which will contain the information for the new AI extents.
- This file must have the '.st' file extension
- The file-name can be any meaningful name. Avoid using the same name as the database to avoid any confusion with the full structure file of the database.
3. Add AI extents structural information to the text file using the following syntax:
First token: Specifies the file type, which is "a" to indicate that this extent is an AI extent.
Second token: Specifies the extent file pathname. Enter a pathname that represents a standard operating system file. If an extension is not supplied, Progress automatically appends an .a<n> extension to the database name.
Third token: Specifies the whether the extent type is a fixed-length (f), variable-length or fixed-variable-length (v) extent in lowercase.
Forth token: Specifies the extent size in 1K units for fixed-length (f) or fixed-variable-length (v) extents
Example:
addai.st# 500 MB fixed length ai extenta /usr/ai/. f 512000# 500 MB fixed-variable length ai extenta /usr/ai/. v 512000# a variable length ai extenta /usr/ai/. 4. As this is a database maintenance task, backup the database before proceeding.
5. Add the AI extents into the database.
The PROSTRCT command will format the new AI extents. It may take some time to allocate the files on disk if the extents are defined fixed length.
offline, all Progress OpenEdge versions:
$ prostrct add <dbname> <addai.st>
online, OpenEdge 10.1B and later:
$ prostrct addonline <dbname> <addai.st>
6. Verify the extents have been added to the Control Area:
$ prostrct list <db-name> <dbname>.st
The database structure now has AI extents but AI logging recovery is not enabled. Use RFUTIL to enable AI logging offline or since OpenEdge 10.1B databases can be enabled for after-imaging online with PROBKUP online. Refer to the
OpenEdge Database Administration Guide and Reference, "Enabling After-imaging"This method can also be used to add extents more ai extents to an existing database that has After-Imaging enabled.
