HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET DBECONNECT 

Modifies the behavior of the SET DBENVIRONMENT command

Scope 

SQLMON Only

SQLMON Syntax 

SET DBEC[ONNECT] [ON ]
                 [OFF]
Parameters 

ON                      When you issue SET DBENVIRONMENT, SQLMON connects
                        to the DBEnvironment and accesses the system
                        catalog.  The default value.

OFF                     When you issue SET DBENVIRONMENT, SQLMON does not
                        connect to the DBEnvironment or access the system
                        catalog.

Description 

   *   Use SET DBECONNECT OFF if the prompt does not return after you
       issue SET DBENVIRONMENT. 
       SET DBENVIRONMENT might execute indefinitely if the DBEnvironment
       has a locking problem.

       If SET DBENVIRONMENT executes indefinitely, do the following:

          *   Use the MPE/iX ABORTJOB command to terminate SQLMON.

          *   Run SQLMON again.

          *   Issue SET DBECONNECT OFF.

          *   Issue SET DBENVIRONMENT.

          *   Use the screens in the Lock subsystem, because the
              DBEnvironment probably has a lock problem.

Example 

     SQLMONITOR  OVERVIEW => SET DBECONNECT OFF 

If you omit the last parameter, SQLMON prompts for it, as follows:

     SQLMONITOR  OVERVIEW => SET DBECONNECT 

ON/OFF: OFF 

MPE/iX 5.0 Documentation