IOSTATS()

Class

Performance and Optimization

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