Difference between revisions of "IOSTATS()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to monitor table and index file I/O operations
 
Function to monitor table and index file I/O operations
Line 6: Line 4:
  
 
==Syntax==
 
==Syntax==
IOSTATS(<expC> [,<workarea | alias>])
+
IOSTATS(<expC> [, <workarea | alias>])
  
  
 
==See Also==
 
==See Also==
[[CLEAR IOSTATS]], [[SET DCACHE]], [[SET ICACHE]]
+
[[CLEAR IOSTATS]], [[DISPLAY IOSTATS]], [[DISPLAY PROFILE]], [[LIST IOSTATS]], [[LIST PROFILE]], [[PROFILE]], [[SET DCACHE]], [[SET ICACHE]], [[SET PROFILE]]
  
  
Line 64: Line 62:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Performance and Optimization]]
 
[[Category:Performance and Optimization]]
 
[[Category:Performance and Optimization Functions]]
 
[[Category:Performance and Optimization Functions]]

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