Kbase P125375: How to go from having a variable before-image extent to having a fixed and variable length bi extent
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/26/2010 |
|
Status: Verified
GOAL:
How to go from having 1 variable bi extent to having more than 1 bi extent?
GOAL:
How to remove a bi extent from an existing database?
GOAL:
How to add a fixed before-image extent to a database that only has a variable before-image extent?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
In order to add a fixed bi extent to a database that already has a single variable length bi file:
Steps:
1. Ensure that the database is shutdown. Command: proshut <dbname> -by
2. Backup your database with either an Operating System command or via a Progress backup using probkup command.
3. Truncate the existing bi file. Command: proutil <dbname> -C truncate bi
4. First remove the existing variable bi extent so that at least 1 fixed before-image extent can be added along with a new variable extent. To remove the variable length extent, issue the prostrct remove utility. Command: prostrct remove <dbname> bi
5. Create a file called add.st with any text editor. This file must contain the following information:
- Token (b in this case because we are adding bi extents)
- location where the new extents are to be created
- f to indicate that it is a fixed extent or blank for a variable length extent
- size of extent in 1K blocks.
Example:
# add.st
b . f 524288
b .
6. Add these extents to the database. Command: prostrct add <dbname> add.st
7. Verify the new database structure. The resulting structure file will reflect the latest changes. Command: prostrct list <dbname> <dbname>.st
Note: If the database is a repilcation enabled target database, the above instructions will not work.