HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET DBENVIRONMENT 

Specifies which DBEnvironment SQLMON monitors

Scope 

SQLMON Only

SQLMON Syntax 

SET DBEN[VIRONMENT] [DBEnvironmentName [MAINT=MaintenanceWord]]
                    [OFF                                      ]
Parameters 

DBEnvironmentName       The name of the DBEnvironment to be monitored.

MaintenanceWord         The maintenance word of the DBEnvironment,
                        required if you are not the DBEnvironment creator
                        or system manager.

OFF                     The default value, indicating that no
                        DBEnvironment has been specified.

Description 

   *   You cannot display an SQLMON screen until you issue SET
       DBENVIRONMENT.

   *   SQLMON can monitor just one DBEnvironment at a time.

   *   The SET DBECONNECT and SET DBEINITPROG commands affect the
       behavior of the SET DBENVIRONMENT command.

Examples 

The following example shows how to monitor the PartsDBE DBEnvironment:

     SQLMONITOR  OVERVIEW => SET DBENV PartsDBE 

If you omit the DBEnvironment name or the maintenance word, SQLMON
prompts for them, as follows:

     SQLMONITOR  OVERVIEW => SET DBENVIRONMENT 

     DBENVIRONMENT NAME <or OFF>: PartsDBE 

     MAINTENANCE WORD:

MPE/iX 5.0 Documentation