Shows information about the DBEnvironment.
Scope |
 |
SQLUtil SHOWDBE Command
Syntax |
|
Description |
|
This command shows information contained in the DBECon file.
Authorization |
|
Any user may execute this command. However,
the DBEnvironment maintenance word will not be displayed unless the
user is the DBECreator or superuser or supplies the correct maintenance word.
Example |
|
The values specified in START DBE NEW and
START DBE NEWLOG statements for
audit databases are stored in the DBECon file.
The SQLUtil SHOWDBE command can be used
to verify the parameters of a DBEnvironment.
For example, when you enter the SHOWDBE command after
creation of a DBEnvironment, you might see
the following:
isql=> sqlutil
>> showdbe
DBEnvironment Name; DBE1
Maintenance Word: Return
Output File Name (opt): Return
->
-> all
Maintenance word:
DBEnvironment Language: (n-computer)
DBECreator ID: 6723
AutoStart: ON
Audit Logging Is: ON
Audit Logging ID is: MYDBE1
Default Partition ID Is: 1
Maximum number of Partitions Is: 10
User Mode: MULTI
DBEFile0 Name: MyDBE1
DDL Enabled: YES
No. of Runtime Control Block Pages: 128
No. of Data Buffer Pages: 200
No. of Log Buffer Pages: 200
Max. Transactions: 30
Maximum Timeout: NONE
Default Timeout: MAXIMUM
Authorize Once per Session: OFF
|
