Previous
Topic:
Octopus Logging |
Octopus can be set to compile and store two kinds of statistics: detailed and cumulative. Information is collected for the following components of the Octopus system:
- Octopus (global)
- Node
- Class
- Subclass
- Server (OctoEng)
- Session
Octopus collects detailed statistics when the StatType parameter in the relevant OCTOPUS section of the nucleus.ini file is set to DETAILED. Octopus compiles cumulative statistics when the StatType parameter is set to CUMULATIVE. When StatType is set to DETAILED,CUMULATIVE, both types of statistics are compiled.
The Octopus installation package includes the SQL Data Definition Language and SAND CDBMS Data Loader specification scripts required to set up database tables for Octopus detailed and cumulative statistics (stat.ddl) and populate them with values from the STAT and CSTAT files (dstat.ndl and cstat.ndl). These scripts are included in Appendix B.
When detailed statistics are compiled, the following information is collected for each query executed in the Octopus system, and saved in the .sta file specified with the StatFile parameter in the relevant OCTOPUS section(s) of the nucleus.ini file. The default detailed statistics file is database-name.sta, located in the directory specified by the DatabasePath parameter.
Information Column in .sta File Column in DSTAT Table Date and time in this format:
yyyy/mm/dd HH:MM:SSTimeStamp � Date (yyyy/mm/dd) � OCTO_DATE Year (yyyy) � OCTO_YEAR Month (mm) � OCTO_MONTH Day (dd) � OCTO_DAY Time (HH:MM:SS) � OCTO_TIME Hour (HH) � OCTO_HOUR Minute (MM) � OCTO_MINUTE Second (SS) � OCTO_SECOND Database Name DbName DBNAME User ID UserId USERID User Number UserNum USERNUM Size of result set (number of rows expected) Rsize RSIZE Number of rows fetched Frows FROWS Total time spent waiting for command execution TimeWait TIMEWAIT Total time spent in command execution TimeExec TIMEEXEC Total time spent in fetching data TimeFetch TIMEFETCH Text of SQL command "SQL1" SQL_REQ1 ... "SQL2" SQL_REQ2 ... "SQL3" SQL_REQ3 ... "SQL4" SQL_REQ4 ... "SQL5" SQL_REQ5 ... "SQL6" SQL_REQ6 ... "SQL7" SQL_REQ7 ... "SQL8" SQL_REQ8 ... "SQL9" SQL_REQ9 Error Code Error ERROR_CODE Error Message "ErrorString" ERROR_STR The STATFILE can be reset by executing the OctoRollLog program, as described in the Octopus Logging section above.
Cumulative statistical information is compiled over a user-specified period. This period (measured in seconds) is set with the StatInterval parameter in the OCTOPUS section(s) of the nucleus.ini file. After the specified amount of time has elapsed, the values are written to a comma-separated value file (specified by the nucleus.ini CStatFile parameter, with the extension .ost) and the time counter is reset to 0. Cumulative values since startup of the Octopus system are also calculated.
The following information is collected for each component of the Octopus system:
Information Column in .ost File Column in CSTAT Table Date and time in this format:
yyyy/mm/dd HH:MM:SSTimeStamp � Date (yyyy/mm/dd) � OCTO_DATE Year (yyyy) � OCTO_YEAR Month (mm) � OCTO_MONTH Day (dd) � OCTO_DAY Time (HH:MM:SS) � OCTO_TIME Hour (HH) � OCTO_HOUR Minute (MM) � OCTO_MINUTE Second (SS) � OCTO_SECOND Type of Component (for example, Node, Subclass, and so on) EntryType ENTRY_TYPE Component section header (from nucleus.ini) Header COMPONENT Statistics for Specified Interval Number of SQL commands executed NbReq INT_NBREQ Number of SQL commands rescheduled between Classes NbReqReschedul INT_NBREQPROM Number of rows expected (total size of result sets) ReqErows INT_RSIZE Number of rows fetched ReqFrows INT_FROWS Total time spent in waiting for command execution TotTimeWait INT_TOTTIMEWAIT Total time spent in command execution TotTimeExec INT_TOTTIMEEXEC Total time spent in fetching data during the specified interval TotTimeFetch INT_TOTTIMEFETCH Maximum time spent in waiting for command execution during the specified interval MaxTimeWait INT_MAXTIMEWAIT Maximum time spent in command execution MaxTimeExec INT_MAXTIMEEXEC Maximum time spent in fetching data MaxTimeFetch INT_MAXTIMEFETCH Cumulative Statistics (since Octopus Startup) Number of SQL commands executed CNbReq CUM_NBREQ Number of SQL commands rescheduled between Classes CNbReqReschedul CUM_NBREQPROM Number of rows expected (total size of result sets) CReqErows CUM_RSIZE Number of rows fetched CReqFrows CUM_FROWS Total time spent in waiting for command execution CTotTimeWait CUM_TOTTIMEWAIT Total time spent in command execution CTotTimeExec CUM_TOTTIMEEXEC Total time spent in fetching data CTotTimeFetch CUM_TOTTIMEFETCH Maximum time spent in waiting for command execution CMaxTimeWait CUM_MAXTIMEWAIT Maximum time spent in command execution CMaxTimeExec CUM_MAXTIMEEXEC Maximum time spent in fetching data CMaxTimeFetch CUM_MAXTIMEFETCH The CSTATFILE can be reset by executing the OctoRollLog program, as described in the Octopus Logging section above.
Previous
Topic:
Octopus Logging |