Modifies the behavior of the SET DBENVIRONMENT command
Scope
SQLMON Only
SQLMON Syntax
SET DBEI [NITPROG] [ ON OFF ]
Parameters
ON
SQLMON gathers program information for each session when you issue SET DBENVIRONMENT. The default value.
OFF
SQLMON defers gathering program information for each session until you invoke a screen that displays the information.
Description
If SET DBENVIRONMENT pauses for too long to gather program information, issue the command SET DBEINITPROG OFF. SET DBENVIRONMENT might pause if it is gathering information for a large number of sessions.
Example
SQLMONITOR OVERVIEW => SET DBEINITPROG OFF
If you omit the last parameter, SQLMON prompts for it, as follows:
SQLMONITOR OVERVIEW => SET DBEINITPROG
ON/OFF: OFF