 |
» |
|
|
|
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 HP-UX kill 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
|