HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET DBEINITPROG 

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 

MPE/iX 5.0 Documentation