HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 9 SQLMON Command Reference

HELP

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Invokes the SQLMON online help facility

Scope

SQLMON Only

SQLMON Syntax

{ H[ELP] ? } [[ScreenName] [ CONTROL INFO SUBSYSTEM 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
Feedback to webmaster