PROUTIL utility syntax

PROUTIL performs various database operations. The qualifier you enter specifies the operation, and determines the required parameters you supply.

Syntax

proutil -help db-name -C qualifier 
     [ [-userid username[-password passwrd]]|
       [ -U username -P passwrd ]
     ]
     [-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.

db-name

Specifies the name of the database that you are using.

-C

Specifies a particular utility or function when you use PROUTIL.

qualifier

Specifies the qualifier that you want to use. You can supply the qualifiers described in Table 1.

-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 OS process as the default user ID.

Note: You can also generate an encrypted password using the genpassword utility. For more information, see the encrypted password procedure in the Password (-P) connection parameter section of the Startup Command and Parameter Reference. For more information on authentication systems and security domains, see Learn about 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. Utilities that modify encryption policies (such as ENABLEENCRYPTION, DISABLEENCRYPTION, EPOLICY, TABLEMOVE, or INDEXMOVE) must authenticate as the keystore admin. For more information on the keystore passphrase, see Database keystore.

CAUTION: If your database is enabled for TDE and configured for manual start, you must specify -Passphrase every time the database is opened.

-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. The -Pin qualifier never applies for a remote connection.

The following table lists all of the PROUTIL qualifiers. See the appropriate section for each qualifier for more detailed information.