IQ UTILITIES statement

Description

Collects statistics on the buffer caches for a Sybase IQ database.

Syntax

IQ UTILITIESMAIN | PRIVATE }
[ INTO ] table-nameSTART MONITOR ['monitor-options']
| STOP MONITOR }

Parameters

monitor-options:

-summary | { -append | -truncate } -bufalloc | -cache | -cache_by_type | -contention | -debug | -file_suffix suffix| -io | -interval seconds | -threads }...

Examples

Example 1

Starts the buffer cache monitor and records activity for the IQ temp buffer cache:

IQ UTILITIES PRIVATE INTO monitor START MONITOR '-cache -interval 20'

Usage

START MONITOR starts the IQ buffer cache monitor. For START and STOP MONITOR, the table_name is a dummy table. You can specify any IQ base or temporary table, although it is best to have a table that you use only for monitoring. Results go to a text file, dbname.connection#-main-iqmon for MAIN buffer cache results, or dbname.connection#-temp-iqmon for PRIVATE (Temp) buffer cache results. Running the monitor again from the same database and connection number overwrites previous results. To set the directory location of the monitor output file, set the MONITOR_OUTPUT_DIRECTORY option.

The monitor-options define the content and frequency of results. You can specify more than one, and they must be enclosed with quotation marks.


Side effects

None.

Standards

Permissions

None

See also

“sp_iqsysmon procedure” in Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures

MONITOR_OUTPUT_DIRECTORY option

Chapter 5, “Monitoring and Tuning Performance” in the Performance and Tuning Guide for examples of monitor results

Chapter 1, “Using Procedures and Batches” in System Administration Guide: Volume 2 for advanced use of IQ UTILITIES to create procedures that extend the functionality of Sybase IQ system stored procedures