HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 6 Getting Started With SQLMON

Invoking SQLMON Screens

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

To access an SQLMON screen, type the name of the screen at a subsystem prompt. For example, to invoke the Overview screen, issue the following command:

SQLMONITOR OVERVIEW => OVERVIEW

The commands are not case sensitive, and you can abbreviate them. For example, you can also access the Overview screen with this command:

   SQLMONITOR OVERVIEW => o

The abbreviated commands are context sensitive and vary according to the current subsystem. For example, to access the Lock Memory screen from the Lock subsystem, you can use either of the following commands:

   SQLMONITOR LOCK => m



   SQLMONITOR LOCK => /loc m

But to access the Lock Memory screen from another subsystem, you must use the longer abbreviation:

   SQLMONITOR IO => /loc m

Table 6-1 “SQLMON Screens” lists the SQLMON screens by subsystem.

Table 6-1 SQLMON Screens

SubsystemScreen NameDescription
IOIOPerformance information on the data and log buffer pools.
 IO Data ProgramData buffer pool information for each program being run by sessions attached to the DBEnvironment.
 IO Data SessionData buffer pool information for each session attached to the DBEnvironment.
 IO Log ProgramLog buffer pool information for each program being run by sessions attached to the DBEnvironment.
 IO Log SessionLog buffer pool information for each session attached to the DBEnvironment.
LoadLoadInformation useful in measuring the throughput efficiency of the DBEnvironment.
 Load ProgramTransaction throughput information for each program being run by sessions attached to the DBEnvironment.
 Load SessionTransaction throughput information for each session attached to the DBEnvironment.
LockLockLock activity data for the entire DBEnvironment.
 Lock ImpedeLocks granted to a particular session that are causing other sessions to wait.
 Lock MemoryNumber of locks allocated at each granularity to each session.
 Lock ObjectSessions in the lock queue for particular locks.
 Lock SessionLock activity data for a single session.
 Lock TabSummaryNumber of locks allocated at each granularity level for each table.
OverviewOverviewImportant aspects of the DBEnvironment's performance, such as the data buffer pool miss rate and the amount of available runtime control block space.
 Overview ProgramSession information for each program.
 Overview SessionInformation about all sessions connected to the DBEnvironment.
SampleIOSampleIODBEFile I/O information.
 SampleIO ObjectsI/O information for database objects in the data buffer pool.
 SampleIO TablesI/O information for tables in a DBEFileSet.
 SampleIO IndexesIndex and referential constraint
 SampleIO TabindexI/O information about a single table, and its indexes and referential constraints.
StaticStaticInformation about indexes, referential constraints, and hashing for each table contained in a DBEFileSet.
 Static ClusterInformation about the clustering of indexes and referential constraints in a DBEFileSet.
 Static DBEFileFile capacity and fullness data for each DBEFile in a DBEFileSet.
 Static HashOverflow chain information for hashed tables.
 Static IndirectInformation about the indirect rows in each table of a DBEFileSet.
 Static SizeInformation about the size of database objects in a DBEFileSet.

 

Table 6-2 “Abbreviated Screen Commands” summarizes the abbreviated commands used to invoke SQLMON screens. You can also issue the commands in the "Different Subsystem" column from the same subsystem.

Table 6-2 Abbreviated Screen Commands

Screen NameAbbreviated Command
 Different SubsystemSame Subsystem
IO/ii
IO Data Program/i d pd p
IO Data Session/i d sd s
IO Log Program/i l pl p
IO Log Session/i l sl s
Load/loal
Load Program/loa pp
Load Session/loa ss
Lock/locl
Lock Impede/loc ii
Lock Memory/loc mm
Lock Object/loc oo
Lock Session/loc ss
Lock TabSummary/loc tt
Overview/oo
Overview Program/o pp
Overview Session/o ss
SampleIO/sas
SampleIO Objects/sa oo
SampleIO Tables/sa tabltabl
SampleIO Indexes/sa ii
SampleIO Tabindex/sa tabitabi
Static/stst
Static Cluster/st cc
Static DBEFile/st dd
Static Hash/st hh
Static Indirect/st ii
Static Size/st sisi

 

Feedback to webmaster