Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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]
>                             [-blocksize blocksize]
>                             [-validate]

> In the syntax block, `structure-description-file` represents the name of the `.st` file. If you do not specify the name of the `.st` file, PROSTRCT uses `db-name``.``st.` The database blocksize in kilobytes is represented by `blocksize`. Specify 1024, 2048, 4096, or 8192. If you specify `-validate`, PROSTRCT will check that the contents of your structure description file are accurate without creating the database.

> | To create a database named `sports2000` from the `sports2000.st` structure description file, use PROSTRCT CREATE as follows:

> 1. First verify that your structure description file is accurate, use the `-validate` option to PROSTRCT CREATE as follows:

>     prostrct create sports2000 sports2000.st -blocksize 4096 -validate

> If there are no errors in your structure description file, PROSTRCT returns a status similar to the following:

>     The structure file format is valid. (12619)
>     Device: /usr1/dbs/, KBytes needed: 3488, KBytes available: 483876225
>     (12616)
>     There is sufficient free space to initialize the defined extents. (12618)

> 2. Second, create the as follows:

>     prostrct create sports2000 sports2000.st -blocksize 4096

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