SHOWDBE

Shows the information related to a DBEnvironment.

Scope

SQLUtil Only

SQLUtil Syntax

>> SHOWDBE DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord Output File Name (opt): OutputFileName

Parameters

DBEnvironmentName: is the name of a DBEnvironment.
MaintenanceWord: is the maintenance word.
OutputFileName: is the name of the output file to which the output from this command should be directed. The default is the terminal.

Description

This command shows information about the specified DBEnvironment.
Once this command is executed, the user will be prompted for subsequent SHOWDBE commands.
The DBEnvironment may be in use while this command is executed.

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

   >> showdbe

   DBEnvironment Name:  ../sampledb/PartsDBE

   Maintenance Word:  Return 

   Output File Name (opt):   Return 

   -> startparms



   DBEnvironment Language:  n-computer

   DBECreator ID:           170

   AutoStart:  ON

   Audit Logging Is: ON

   Audit Logging Name is: Wrapper1

   Default Partition ID is: 1

   Maximum Number of Partitions Is: 10

   Comment Partition ID Is: 2

   Audit Elements Are: CHKPT, DATA, CMNT

   User Mode:  MULTI

   DBEFile0 Name:  PartsF0

   DDL Enabled:  YES

   No. of Runtime Control Block Pages: 128 

   No. of Data Buffer Pages:  200

   No. of Log Buffer Pages:  200 

   Max. Transactions: 100 

   Maximum Timeout:  NONE

   Default Timeout:  MAXIMUM

   Authorize Once per session:  OFF





   -> quit