IOSTATS()

From Recital Documentation Wiki
Revision as of 15:50, 27 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


Purpose

Function to monitor table and index file I/O operations


Syntax

IOSTATS(<expC> [,<workarea | alias>])


See Also

CLEAR IOSTATS, SET DCACHE, SET ICACHE


Description

The IOSTATS() function provides a facility for monitoring table and index file I/O operations. This function is very useful for performance tuning. If the optional <workarea | alias> is omitted, then the value returned is the total for all active workareas.

The <expC> is a character expression denoting any of the following operations:


Item Action
Reads # of row reads for tables
Updates # of row updates for tables
Deletes # of row deletes for tables
Recalls # of row recalls for tables
Appends # of row inserts for tables
DcacheReads # of cache reads for tables
DcacheWrites # of cache writes for tables
IReads # of index reads for tables
IWrites # of index writes for tables
IcacheReads # of index cache reads for tables
IcacheWrites # of index cache writes for tables
Opens # of table opens
Closes # of table closes
KeyStrokes # of key strokes


OPENS, CLOSES, and KEYSTROKES are general items and are not specific to individual workareas. KEYSTROKES are only applicable Recital Terminal Developer.


Example

// Print total keystrokes
? iostats("keystrokes")


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer