Difference between revisions of "SET IOSTATS"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{YLM to do}}
 
==Class==
 
Performance and Optimization
 
 
 
 
==Purpose==
 
==Purpose==
 +
Enables or disables the logging of input/output statistics
  
  
Line 12: Line 8:
  
 
==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 COMPILE]], [[SET DCACHE]], [[SET ICACHE]], [[SET IOLOGGING]], [[SET LOCKTYPE]], [[SET NETWORK]], [[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 20:
 
<code lang="recital">
 
<code lang="recital">
 
set iostats on
 
set iostats on
set iostats to 100
+
do myapp
 +
list iostats
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|IOSTATS]]
 
[[Category:Set_Commands|IOSTATS]]
 +
[[Category:Performance and Optimization]]
 +
[[Category:Performance and Optimization Set Commands]]

Latest revision as of 14:46, 13 January 2010

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 COMPILE, SET DCACHE, SET ICACHE, SET IOLOGGING, SET LOCKTYPE, SET NETWORK, 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 Server, Recital