HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

SHOWDBE-ALL 

Shows information about the DBEnvironment.

Scope 

SQLUtil SHOWDBE Command

Syntax 

-> ALL

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,
has SM capability, 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.SOMEGRP.SOMEACCT
     Maintenance Word:  Return  
     Output File Name (opt):  Return  
     ->
     -> all

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

MPE/iX 5.5 Documentation