Difference between revisions of "IOSTATS()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
(4 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 | ||
− | |||
==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]], [[SET PROFILE]] | [[CLEAR IOSTATS]], [[DISPLAY IOSTATS]], [[DISPLAY PROFILE]], [[LIST IOSTATS]], [[LIST PROFILE]], [[PROFILE]], [[SET DCACHE]], [[SET ICACHE]], [[SET PROFILE]] | ||
− | |||
==Description== | ==Description== | ||
Line 16: | Line 13: | ||
The <expC> is a character expression denoting any of the following operations: | The <expC> is a character expression denoting any of the following operations: | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Item||Action | !Item||Action | ||
|- | |- | ||
Line 50: | Line 46: | ||
|} | |} | ||
− | + | OPENS, CLOSES, and KEYSTROKES are general items and are not specific to individual workareas. | |
− | OPENS, CLOSES, and KEYSTROKES are general items and are not specific to individual workareas. | + | |
− | + | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | // Print total | + | // Print total opens |
− | ? iostats(" | + | ? iostats("Opens") |
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Performance and Optimization]] | [[Category:Performance and Optimization]] | ||
− |
Latest revision as of 11:19, 5 February 2013
Contents
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.
Example
// Print total opens ? iostats("Opens")