Progress
Database Administration
Guide and Reference


Progress Structure List Utility

Your structure description file must reflect the current information in your database control area to ensure continuity and ease database management. Therefore, update the structure description file any time you make changes to the structure of a database, such as adding, moving, or removing extents. Use the Progress Structure List (PROSTRCT LIST) utility to update your structure description file. PROSTRCT LIST produces a new structure description file for the database you name, using the current information stored in the database control area.

NOTE: You can use PROSTRCT LIST with an online database.

To update the structure description file with the current information stored in the database control area, use the PROSTRCT LIST utility:

prostrct list db-name [ structure-description-file ] 

db-name

Specifies the database whose structure description file you want to update.

structure-description-file

Specifies the structure description file to create. If you do not specify the structure description file, PROSTRCT LIST uses the base name of the database and appends a .st extension. It replaces an existing file of the same name.

For example, to update the structure description file for /user/joe/service, enter the following command:

prostrct list /user/joe/service 

PROSTRCT LIST displays the information it produces in the structure description file, including storage area type, storage area name, records per block, extent pathname, and extent type, either fixed or variable (a size of 0 indicates a variable-length extent). For example:

AreaName: ControlArea, Type 6, Block Size 1024, Extents 1, Records/Blck 32 
   Ext # 1, Type VARIABLE, Size 0, Name: /user/joe/service.db 
AreaName: Primary Recovery Area, Type 3, Block Size 8192, Extents 1 
   Ext # 1, Type VARIABLE, Size 0, Name: /usrer/joe/service.b1 
AreaName: Transaction Log Area, Type 4, Block Size 16384, Extents 1 
   Ext # 1, Type FIXED   , Size 1024, Name:/user/joe/service.t1 
AreaName: Schema Area, Type 6, Block Size 1024, Extents 1, Records/Blck 32 
   Ext # 1, Type VARIABLE, Size 0, Name: /user/joe/service.d1 
AreaName: After Image Area 1, Type 7, Block Size 8192, Extents 1 
   Ext # 1, Type FIXED   , Size 32, Name: /user/joe/service.a1 
AreaName: service, Type 6, Blck Size 1024, Extents 6, Records/Block 32 
   Ext # 1, Type FIXED   , Size 32, Name:/user/joe/service_8.d1 
   Ext # 2, Type FIXED   , Size 32, Name:/user/joe/service_8.d2 
   Ext # 3, Type FIXED   , Size 32, Name:/user/joe/service_8.d3 
   Ext # 4, Type FIXED   , Size 32, Name:/user/joe/service_8.d4 
   Ext # 5, Type FIXED   , Size 32, Name:/user/joe/service_8.d5 
   Ext # 6, Type VARIABLE , Size 0, Name:/user/joe/service_8.d6 
AreaName: joe, Type 6, Block Size 1024, Extents 1, Records/Block 32 
   Ext # 1, Type VARIABLE, Size 0, Name: /user/joe/yy/z/service_1000.d1 


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