PROSTRCT LIST qualifier

Creates a structure description (.st) file for an OpenEdge database.

Syntax

prostrct list db-name[ structure-description-file ][ -RO ]

Parameters

db-name
Specifies the multi-volume database whose structure description file you want to update.
structure-description-file
Specifies the structure description file PROSTRCT creates. If you do not specify the structure description file, PROSTRCT uses the base name of the database and appends a .st extension. It replaces an existing file of the same name.
-RO
Runs the utility in read-only mode. Use read-only mode to connect to databases on read-only media or to diagnose and repair issues on a stopped database before starting it. Read-only mode allows any number of connections at once, up to the maximum number of connections. This reduces bottlenecks and expedites disaster recovery on large databases.
Note: Use -RO with caution because it is designed to work only with a read-only connection. Unexpected errors may result if you specify -RO when using a single-user or multi-user connection.

PROSTRCT LIST provides storage area, transaction log, and records per block information in the .st file it produces. Also, PROSTRCT LIST displays storage area names and extent information including the extent type, size, number, and name.

Notes

  • Use PROSTRCT LIST any time you make changes to the structure of the database to verify that the change was successful.
  • You can use this utility with an online database or with a stopped database that has a read-only connection. See Read-only connections.
  • See Maintain Database Structure for more information about the LIST qualifier with the PROSTRCT utility.