IOSTATS()

From Recital Documentation Wiki
Revision as of 12:03, 8 March 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to monitor table and index file I/O operations


Syntax

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


See Also

CLEAR IOSTATS, DISPLAY IOSTATS, DISPLAY PROFILE, LIST IOSTATS, LIST PROFILE, PROFILE, SET DCACHE, SET ICACHE, SET PROFILE


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 Server, Recital