Progress
Database Administration
Guide and Reference


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 1024, Extents 1, Records/Block32 
   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 1024, Extents 1, Records/Block 32 
   Ext # 1, Type VARIABLE, Size 0, Name: /usr1/example1.d1 
Area Name: Employee, Type6, BlockSize 1024, Extents 2, Records/Block 32 
   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 
   Ext # 1, Type FIXED   , Size 608, Name: /usr1/cmcguire/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 
   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 
   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 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095