HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

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,
has SM capability, or supplies the correct maintenance word.

Example 

     >> showdbe 
     DBEnvironment Name:  PartsDBE.SomeGrp.SomeAcct 
     Maintenance Word:  Return  
     Output File Name (opt):   Return  
     -> startparms 

     DBEnvironment Language:  NATIVE-3000
     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
     Data Buffer Pages Memory Resident:  NO
     No. of Log Buffer Pages:  200
     Max. Transactions: 100
     Maximum Timeout:  NONE
     Default Timeout:  MAXIMUM
     Authorize Once per session:  OFF

     -> quit 

MPE/iX 5.5 Documentation