Kbase 20006: What are the differences between the Progress 9.x and 8.x Structure Description Files?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
What are the differences between the Progress 9.x and 8.x Structure Description Files?
GOAL:
What are the differences between the Progress 9.x and 8.x .ST file?
GOAL:
What's new in the Progress 9.x .ST file?
FACT(s) (Environment):
Progress 9.x
Progress 8.x
UNIX
Windows
FIX:
The version 8.x Structure Description File has 4 line items:
- Extent Type
- Extent Path
- Fixed or Variable
- Fixed Extent Length.
The version 9.x Structure Description File now adds 3 new line items pertaining to database storage areas. They include:
- Area Name
- Area Number
- Records per block.
Thus, the Version 9.x Structure Description File can now have up to 7 line items:
- Extent Type
- Area Name
- Area Number
- Records per Block
- Extent Path
- Fixed or Variable
- Fixed Extent Length.
Descriptions of the line items are as follows:
Extent type
The type of storage area designated by a single character.
a = After-Image extent
b = Before-Image extent
d = Schema and Data extents
t = Transaction Log
Area Name
The name of the area. If nothing is entered here, with type "d", Progress locates the data in the schema area.
Area Number
The number that Progress associates with the storage area. Progress assigns an area number if none is entered.
Records per Block
The number of records that can be stored in each block. The default is 32 records per block or 64 records per block if the database has an 8K block size.
Extent Pathname
The path to this particular extent. Entering a "." places the extent in the current working directory.
Extent Type
The extent type can be either fixed, indicated by an "f" or variable, which is signified by no character designation.
Fixed Extent Size
If the extent is fixed, the size is expressed in kilobytes.
You can use a Version 8.x .ST file on a Version 9.x database. If you do, all the data extents will be stored within storage area 6 (the Schema Area) and there will be 32 records per block or 64 records per block if the database is using an 8K block size.