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

SET SORTSAMPLEIO

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Defines how items are sorted on the SampleIO subsystem screens

Scope

SQLMON Only

SQLMON Syntax

SET SORTS [AMPLIO] [ SortColumn OFF ]

Parameters

SortColumn

The column by which items are sorted. SortColumn is an integer from 0 to 3 that represents a column on the screen, as follows:

0

same as OFF

1

SWAPIN

2

SWAPOUT

3

TOTALIO (default)

The items are sorted in descending order according to the values in the column.

OFF

Sorts the items by object name.

Description

  • This command affects the SampleIO, SampleIO Indexes, SampleIO TabIndex, and SampleIOTables screens.

  • On the screens, an asterisk appears beside the sort column number.

  • For more information on the SampleIO screens, see the descriptions of each screen in the chapter "SQLMON Screen Reference."

Examples

To sort the items on the SampleIO subsystem screens according to the value in the SWAPOUT column, enter

   SQLMONITOR SAMPLEIO => SET SORTSAMPLEIO 2

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

   SQLMONITOR SAMPLEIO => SET SORTSAMPLEIO



   <0=OFF,1=SWAPIN,2=SWAPOUT,3=TOTALIO>: 2
Feedback to webmaster