Try OpenEdge Now
skip to main content
Database Administration
Database Basics : Creating and Deleting Databases : Creating a database with PROSTRCT CREATE : Creating a structure description file : Example structure description file
 
Example structure description file
The example that follows shows a .st file named sports2000.st that defines a database with:
*One primary recovery area.
*One schema area.
*Three after-image areas each with a fixed-length extent.
*One transaction log area with a fixed-length extent used with two-phase commit.
*Six application data areas each with one fixed- and one variable-length extent. The area names for the six application data areas are: Employee, Inventory, Cust_Data, Cust_Index, Order, and Misc. Note that the Cust_Data, Cust_Index, and Order areas have cluster sizes assigned to them, and are therefore Type II storage areas. The area numbers are not specified. The areas will be numbered sequentially starting at 7. Blocks per cluster is not specified, creating Type I data areas.
Sample Structure Description File: sports2000.st
#
# The following defines the Primary Recovery Area consisting of one
# variable length extent. It resides in the /usr2/bi directory:
#
b /usr2/bi
#
# The following defines the Schema Area consisting of one variable length # extent, residing in the current working directory:
#
d "Schema Area" .
#
# The following defines three fixed length After Image Areas each equal to
# 1 MB in size:
#
a /usr3/ai f 1024
a /usr3/ai f 1024
a !"/usr3/ai data" f 1024
#
# The following defines a Transaction Log Area equal to 4 MB in size and
# residing in the current working directory. This storage area is used
# for 2 phase commit:
#
t . f 4096
#
# The following defines six Application Data Areas each with one fixed
# length extent equal to 1 MB in size and 1 variable length extent:
#
d "Employee",32 /usr1/emp f 1024
d "Employee",32 /usr1/emp
#
d "Inventory",32 /usr1/inv f 1024
d "Inventory",32 /usr1/inv
#
d "Cust_Data",32;64 /usr1/cust f 1024
d "Cust_Data",32;64 /usr1/cust
#d "Cust_Index",32;8 /usr1/cust f 1024
d "Cust_Index",32;8 /usr1/cust
#
d "Order",32;64 /usr1/ord f 1024
d "Order",32;64 /usr1/ord
#
d "Misc",32 !"/usr1/misc data" f 1024
d "Misc",32 !"/usr1/misc data"
#
# Note that the directory pathname for the "Misc" application data area
# contains spaces, and to recognize that the pathname is specified with
# an ! (exclamation point) and " " (quotation marks).