Difference between revisions of "SET IOSTATS"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
==Class== | ==Class== | ||
Performance and Optimization | Performance and Optimization | ||
| Line 5: | Line 4: | ||
==Purpose== | ==Purpose== | ||
| + | Enables or disables the logging of input/output statistics | ||
| Line 12: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[CLEAR PROFILE]], [[CREATE]], [[DELETE]], [[DISPLAY PROFILE]], [[DO]], [[INDEX]], [[LIST PROFILE]], [[PROFILE]], [[RECALL]], [[REPLACE]], [[SET CLUSTERING]], [[SET COMPILE]], [[SET ICACHE]], [[SET IOLOGGING]], [[SET LOCKTYPE]], [[SET PROFILE]], [[SET REPLICATION]], [[SET SYSLOGGING]], [[USE]] | + | [[CLEAR IOSTATS]], [[CLEAR PROFILE]], [[CREATE]], [[DELETE]], [[DISPLAY PROFILE]], [[DO]], [[INDEX]], [[IOSTATS()]], [[LIST PROFILE]], [[PROFILE]], [[RECALL]], [[REPLACE]], [[SET CLUSTERING]], [[SET COMPILE]], [[SET DCACHE]], [[SET ICACHE]], [[SET IOLOGGING]], [[SET LOCKTYPE]], [[SET PROFILE]], [[SET REPLICATION]], [[SET SYSLOGGING]], [[USE]] |
==Description== | ==Description== | ||
| + | The SET IOSTATS command enables or disables the logging of input/output statistics. SET IOSTATS should only be set ON to enable the collection of statistics for performance tuning; it should be set OFF on production systems to optimize concurrent user access. The DISPLAY IOSTATS and LIST IOSTATS commands and the IOSTATS() function can be used to output the statistics to the screen, file or printer. | ||
| + | For details of the statistics logged, please see [[LIST IOSTATS]]. CLEAR IOSTATS is used to reset the log. | ||
| Line 21: | Line 23: | ||
<code lang="recital"> | <code lang="recital"> | ||
set iostats on | set iostats on | ||
| − | + | do myapp | |
| + | list iostats | ||
</code> | </code> | ||
| Line 30: | Line 33: | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|IOSTATS]] | [[Category:Set_Commands|IOSTATS]] | ||
| + | [[Category:Performance and Optimization]] | ||
| + | [[Category:Performance and Optimization Set Commands]] | ||
Revision as of 11:32, 25 June 2009
Class
Performance and Optimization
Purpose
Enables or disables the logging of input/output statistics
Syntax
SET IOSTATS ON | OFF | TO <expN>
See Also
CLEAR IOSTATS, CLEAR PROFILE, CREATE, DELETE, DISPLAY PROFILE, DO, INDEX, IOSTATS(), LIST PROFILE, PROFILE, RECALL, REPLACE, SET CLUSTERING, SET COMPILE, SET DCACHE, SET ICACHE, SET IOLOGGING, SET LOCKTYPE, SET PROFILE, SET REPLICATION, SET SYSLOGGING, USE
Description
The SET IOSTATS command enables or disables the logging of input/output statistics. SET IOSTATS should only be set ON to enable the collection of statistics for performance tuning; it should be set OFF on production systems to optimize concurrent user access. The DISPLAY IOSTATS and LIST IOSTATS commands and the IOSTATS() function can be used to output the statistics to the screen, file or printer.
For details of the statistics logged, please see LIST IOSTATS. CLEAR IOSTATS is used to reset the log.
Example
set iostats on do myapp list iostats
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
