 |
» |
|
|
|
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. Issue SET DBECONNECT OFF. 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
|