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

SET TOP

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Determines the number of items displayed on a screen

Scope

SQLMON Only

SQLMON Syntax

SET T [OP] [ NumItems OFF ]

Parameters

NumItems

The number of items to display. An integer value.

OFF

All items. The default value.

Description

This command affects the following screens:

  • IO Data Program

  • IO Data Session

  • IO Log Program

  • IO Log Session

  • Load Program

  • Load Session

  • SampleIO

  • SampleIO Indexes

  • SampleIO TabIndex

  • SampleIO Tables

Examples

To display the top ten items (sorted according to a defined value), you can enter

   SQLMONITOR IO => SET TOP 10

The items on the screens are sorted according to the value of a sort command, as listed below:

  • For the IO Data Program and IO Data Session screens, SET SORTIODATA

  • For the IO Log Program and IO Log Session screens, SET SORTIOLOG

  • For the Load Program and Load Session screens, SET SORTLOAD

  • For the screens in the SampleIO subsystem, SET SORTSAMPLEIO

  • For the Lock Memory screen, SET SORTLOCK

For more information on the commands listed above, see their command pages in this chapter.

If you omit the last parameter, SQLMON prompts for it, as in

   SQLMONITOR IO => SET TOP



   NUMBER OF ITEMS TO DISPLAY <OFF=ALL>: 5
Feedback to webmaster