Octopus Administrator's Guide
Octopus Monitoring, Logging, and Statistics

 

Previous Topic:
Octopus Logging
Chapter Index
 

 

Octopus Statistics


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 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.


Detailed Statistics

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:SS
TimeStamp
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 Statistics

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:SS

TimeStamp
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
Chapter Index