Progress
Database Administration
Guide and Reference


Create a Database Structure Extent

Use the PROSTRCT CREATE utility to create the physical database files for the database. The PROSTRCT CREATE syntax is:

prostrct create db-name structure-description-file 

NOTE: For the complete syntax of the PROSTRCT CREATE utility see Database Administration Utilities."

For example, to create a database named sports2000 from the sports2000.st structure description file, use PROSTRCT CREATE as follows:

prostrct create sports2000 sports2000.st 

Running the PROSTRCT CREATE utility on sports2000.st generates the following extents for a database named sports2000:

prostrct create sports2000 sports2000.st 
Formatting extents: 
   size                area name   path name 
     32    Primary Recovery Area /usr2/bi/sports2000.b1 00:00:00 
     32              Schema Area /usr1/sports2000.d1 00:00:00 
   1024       After Image Area 1 /usr3/ai/sports2000.a1 00:00:02 
   1024       After Image Area 2 /usr3/ai/sports2000.a2 00:00:03 
   1024       After Image Area 3 /usr3/ai/sports2000.a3 00:00:03 
   4096    Transaction Log Area /usr1/sports2000.t1 00:00:01 
   1024                 Employee /usr1/emp/sports2000_7.d1 00:00:01 
     32                 Employee /usr1/emp/sports2000_7.d2 00:00:00 
   1024                Inventory /usr1/inv/sports2000_8.d1 00:00:00 
     32                Inventory /usr1/inv/sports2000_8.d2 00:00:00 
   1024                Cust_Data /usr1/cust/sports2000_9.d1 00:00:01 
     32                Cust_Data /usr1/cust/sports2000_9.d2 00:00:00 
   1024               Cust_Index /usr1/cust/sports2000_10.d1 00:00:00 
     32               Cust_Index /usr1/cust/sports2000_10.d2 00:00:00 
   1024                    Order /usr1/ord/sports2000_11.d1 00:00:01 
     32                    Order /usr1/ord/sports2000_11.d2 00:00:00 
   1024                Misc /usr1/misc data/sports2000_12.d1 00:00:00 
     32                Misc /usr1/misc data/sports2000_12.d2 00:00:01 


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