Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Maintaining Database Structure : Using the OpenEdge Structure Add utility : PROSTRCT ADD and pathnames
 
PROSTRCT ADD and pathnames
When you use PROSTRCT ADD to add additional storage areas or extents to a relative path database, the relative path database is converted to an absolute path database. For example, if you add an additional application data storage area named Misc to the relative path database example1, PROSTRCT ADD converts the relative path database to an absolute path database. Use PROSTRCT LIST to update the .st file with the added extents. For example:
prostrct add example1 add.st
prostrct list example1
In the following sample output of the PROSTRCT LIST utility, note the absolute pathname (/usr1/example1.db) of the modified database:
Area Name: Control Area, Type6, BlockSize 4096, Extents 1, Records/Block32,
Cluster Size 1
   Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.db

Area Name: Primary Recovery Area, Type3, BlockSize 8192, Extents 1
   Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.b1

Area Name: Schema Area, Type6, BlockSize 4096, Extents 1, Records/Block 32,
Cluster Size 1
   Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.d1

Area Name: Employee, Type6, BlockSize 1024, Extents 2, Records/Block 32,
Cluster Size 8
   Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_7.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_7.d2

Area Name: Inventory, Type6, BlockSize 1024, Extents 2, Records/Block 32,
Cluster Size 64
   Ext # 1, Type FIXED , Size 608, Name: /usr/example1_8.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_8.d2

Area Name: Cust_Data, Type6, BlockSize 1024, Extents 2, Records/Block 32,
Cluster Size 64
   Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_9.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_9.d2

Area Name: Cust_Index, Type 6, BlockSize 1024, Extents 2, Records/Block 32
   Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_10.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_10.d2

Area Name: Order, Type6, BlockSize 1024, Extents 2, Records/Block 32,
Cluster Size 64
   Ext # 1, Type FIXED , Size 1280, Name: /usr1/example1_11.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_11.d2

Area Name: Misc, Type6, BlockSize 1024, Extents 2, Records/Block 32
   Ext # 1, Type FIXED , Size 320, Name: /usr1/example1_12.d1
   Ext # 2, Type VARIABLE, Size 0, Name: /usr1/example1_12.d2