![](../../img/s.gif) |
» |
|
|
|
Modifies the behavior of the SET DBENVIRONMENT command
Scope | ![](../../img/s.gif) |
SQLMON Only
SQLMON Syntax | ![](../../img/s.gif) |
SET DBEC [ONNECT] [ ON OFF ] Parameters | ![](../../img/s.gif) |
- 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 | ![](../../img/s.gif) |
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. Issue SET DBECONNECT OFF. Use the screens in the Lock subsystem, because the DBEnvironment probably has a lock problem.
Example | ![](../../img/s.gif) |
SQLMONITOR OVERVIEW => SET DBECONNECT OFF
|
If you omit the last parameter, SQLMON prompts for it,
as follows:
SQLMONITOR OVERVIEW => SET DBECONNECT
|
ON/OFF: OFF
|