Difference between revisions of "IOSTATS()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 4: Line 4:
  
 
==Syntax==
 
==Syntax==
IOSTATS(<expC> [,<workarea | alias>])
+
IOSTATS(<expC> [, <workarea | alias>])
  
  
 
==See Also==
 
==See Also==
[[CLEAR IOSTATS]], [[DISPLAY IOSTATS]], [[DISPLAY PROFILE]], [[LIST IOSTATS]], [[LIST PROFILE]], [[PROFILE]], [[SET DCACHE]], [[SET ICACHE]]
+
[[CLEAR IOSTATS]], [[DISPLAY IOSTATS]], [[DISPLAY PROFILE]], [[LIST IOSTATS]], [[LIST PROFILE]], [[PROFILE]], [[SET DCACHE]], [[SET ICACHE]], [[SET PROFILE]]
  
  

Latest revision as of 12:03, 8 March 2010

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