Kbase 21460: How To Add AI Extents in an Existing V9 or V10 Progress Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/03/2009 |
|
Status: Verified
GOAL:
How to add AI extents to an existing Progress 9.x database.
GOAL:
How to add AI extents to an existing Progress 10.x database.
FACT(s) (Environment):
OpenEdge Database Category: Maintenance
Progress 9.x
OpenEdge 10.x
FIX:
In order to create AI extents in an existing Progress 9.x database, use the following steps:
1) Define the number and the location(s) of your AI extents.
2) Using a text editor (Notepad, Edit, vi, Progress Procedure Editor) create a new file that will contain the information for the new AI extents. This file should be named as
file-name.st where file-name can be any name. Avoid using the same name as the database to avoid any confusion with the structure file of the database.
3) On the newly created structure file, add AI extents information using the following syntax:
a) First token: Specifies the file type. Type a to indicate that this extent is an AI extent.
b) 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 a .an extension.
c) Third token: Specifies whether the extent is a fixed-length or variable-length extent. Type f for a fixed-length extent. It must be lowercase.
d) Forth token: Specifies the length of the extent in 1K units
This is an example a structure file of 3 fixed AI extents of 500 MB each:
a /usr/ai/. f 512000
a /usr/ai/. f 512000
a /usr/ai/. f 512000
4) Since this is a database maintenance task, backup the database before proceeding.
5) Use the command "prostrct add <db-name> <st-file>" to add the extents into the database. At this point the prostrct command will format the new AI extents. It might take some time to allocate the files on disk if the extents are defined fixed length.
6) Use the command "prostrct list <db-name>" and verify the newly created .st file and check if the AI extents are correctly located on the database structure.
Now the database structure has the AI extents but the AI logging recovery is not enabled. Use the rfutil command to enable AI logging. Follow the procedures described in the section entitled "Enabling After-imaging" in the Progress Database Administration Guide and Reference.