Creates and maintains an OpenEdge database. For example, you can use PROSTRCT and its qualifiers to:

  • Create a new database from an existing structure description (.st) file.
  • Display storage usage statistics including information about storage areas in a database.
  • Add areas and extents to a database.
  • Remove areas and extents from a database.
  • Extend and pre-extend new and existing variable-length extents in a database.

Syntax

prostrct -help qualifier db-name [ structure-description-file ]
     [[-userid username [-password passwd ]]|
      [ -U username -P passwd]
     ]
     [-Passphrase] [-Pin]

Parameters

-help
Displays syntax for utility and specified subcommands. If the syntax ends with ellipses, type the command shown followed by -help to view subcommand syntax.
qualifier

Specifies the qualifier that you want to use. You can supply the following qualifiers:

  • ADD
  • ADDONLINE
  • BUILDDB
  • CLUSTER CLEAR
  • CREATE
  • LIST
  • REMOVE
  • REORDER AI
  • REPAIR
  • STATISTICS
  • UNLOCK

Details of the qualifiers are found in the PROSTRCT subsections on the following pages.

db-name
Specifies the name of the database that you are using.
structure-description-file
Specifies the new .st file. Do not use dbname.st.
-userid username[-password passwd]| -U username -P passwd

A pair of username and password parameters are used together to support a common user authentication model to specify the user ID and password when connecting to an OpenEdge RDBMS.OpenEdge authenticates the user ID and password against the user accounts defined by the authentication system configured for the user's security domain.

Use username and password parameters to identify an authenticated Database Administrator.

If you do not specify a user ID and password for a database connection, OpenEdge assigns user ID of the the OS process as the default user ID.

For more information on authentication systems and security domains, see OpenEdge Getting Started: Identity Management.

-Passphrase
For encryption-enabled databases only, specifies to prompt for a passphrase to authenticate the keystore. Utilities that open the database must at a minimum authenticate as the keystore user. See Transparent Data Encryption for more information on encryption and keystore authentication.
-Pin
After you enable HSM as a secondary authentication requirement for a TDE-enabled database, both passphrase and PIN are required to authenticate the keystore.

Notes

  • You must define your database structure in a .st file before you create a database. PROSTRCT CREATE creates a database control (DB) area from the information in the .st file.
  • See Create and Delete Databases for a complete description of structure description files and storage areas.
  • PROSTRCT supports the use of internationalization startup parameters such as -cpinternalcodepage and -cpstream codepage. See Database Startup Parameters for a description of each database-related internationalization startup parameter.