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 for large files
 
Example structure description file for large files
When creating a new database, large file processing is enabled if the .st file specifies a fixed-length extent size or a maximum size for a variable-length extent that is greater than 2 GB. Large file processing requires an Enterprise database license. The following example shows the .st file of a database with large file processing enabled:
# Sample Structure Description File: largedb.st
#
# largedb.st to create database largedb with large file processing enabled.
#
# A fixed length bi file of 1GB and a variable length bi file with a maximum # size of 4GB.
#
b tests/largedb.b1 f 1048576
b tests/largedb.b2 v 4194304
#
# SCHEMA AREA with a fixed length file of 3GB and a variable length file with # a maximum size of 3GB.
#
d "Schema Area":6,64 tests/largedb.d1 f 3145728
d "Schema Area":6,64 tests/largedb.d2 v 3145728
#
# TABLE AREA with a fixed length file of just over 2GB and a variable length # file with a maximum size of 1TB.
#
d "Table Area":7,64 tests/largedb_7.d1 f 2097280
d "Table Area":7,64 tests/largedb_7.d2
#
# A fixed length ai file of 2GB and a variable length file with a maximum size # of 1TB.
a tests/largedb.a1 f 2097152
a tests/largedb.a2
#
For more information on enabling large file processing, see PROUTIL ENABLELARGEFILES qualifier.