HP 3000 Manuals

HELP [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation


ALLBASE/SQL Performance and Monitoring Guidelines

HELP 

Invokes the SQLMON online help facility

Scope 

SQLMON Only

SQLMON Syntax 

         [             [CONTROL      ]]
         [[ScreenName] [INFO         ]]
         [             [SUBSYSTEM    ]]
{H[ELP]} [             [TUNE [Number]]]
{?     } [                            ]
         [MAIN                        ]
         [SetCommand                  ]
Parameters 

ScreenName              Displays help text for ScreenName.

CONTROL                 Displays information about the SET commands
                        affecting the current screen.

INFO                    Describes each field on the current screen.

SUBSYSTEM               Describes the subsystem.

TUNE                    Displays a list of performance tuning topics
                        relevant to 

                        ScreenName.

Number                  Provides detailed information on the tuning topic
                        designated by Number.

MAIN                    Displays general information about SQLMON.

SetCommand              Describes SetCommand.

Description 

   *   The help information is context sensitive.  For example, if you
       specify TUNE from the Lock subsystem, SQLMON displays tuning hints
       about locks.

   *   You remain in the help facility after SQLMON displays the
       information you requested.

   *   You can enter any of the parameters from the Help prompt.  For
       example, if you enter

            SQLMONITOR  HELP LOCK = info 

       SQLMON displays information about each field on the Lock screen.

   *   To leave the help facility, you can enter any of the following
       commands:

            //
            EXIT
            QUIT

Examples 

To invoke the help facility for the last screen displayed, issue the HELP
command without options, as in

     SQLMONITOR  OVERVIEW => HELP 

You can use a question mark instead of the HELP command, as in:

     SQLMONITOR  OVERVIEW => ? 

To get general information on SQLMON from within the help facility, use
the following command:

     SQLMONITOR HELP  OVERVIEW => MAIN 

In the last example, you do not need to enter the keyword HELP, since you
are already in the help facility.

     SQLMONITOR  OVERVIEW => HELP MAIN 

The following command displays information about the fields on the IO
screen:

     SQLMONITOR  OVERVIEW => HELP IO INFO 

To get help on the SET DBENVIRONMENT command, you can issue:

     SQLMONITOR  OVERVIEW => HELP SET DBENV 

To exit the help facility and return to the subsystem prompt, you would
issue

     SQLMONITOR HELP  OVERVIEW => EXIT 



MPE/iX 5.0 Documentation