Difference between revisions of "IOSTATS()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (6 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 8: | 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 66: | Line 62: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Performance and Optimization]] | ||
| + | [[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
