Interstage Shunsaku Data Manager Operator's Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

6.2.4 Monitoring Sorter Operation Information

Sorter operation information can be used for the following purposes:

• Checking the operating status of sorters
• Checking statistical information for sort requests

Sorter operation information can be obtained by executing the shunostate command on the server where the sorter is located.

Example 1

The following example shows how sorter operation information is displayed.

shunostate -s shuno1 -w 
Shunsaku shunostate 2006/01/01 19:01:00

(1)       (2)            (3)             (4)
Time      State          Requests        Errors 
          (5)            (6)             (7)
          AvgTime(sec)   MaxTime(sec)    MaxTimeDetected
          (8)            (9)             (10)                      (11)
          AvgUsedMemory  MaxUsedMemory   MaxUsedMemoryDetected     Concurrency

19:01:00  ACTIVE         3515            0
          2.000          30.000          2006/01/01 10:00:00
          10.0MB         20.0MB          2006/01/01 10:00:00       5

The following table shows the explanation of the item displayed.

Item Displayed	Explanation
(1) Time	Output time (hh:mm:ss)
(2) State	The operating status of the sorter The operating status of the sorter is displayed as follows: ACTIVE: Running
(3) Requests	Cumulative number of sort requests
(4) Errors	Cumulative number of error responses
(5) AvgTime(sec)	Average response time (seconds)
(6) MaxTime(sec)	Maximum response time (seconds)
(7) MaxTimeDetected	Date/time when the maximum response time was detected (YYYY/MM/DD hh:mm:ss)
(8) AvgUsedMemory	Average amount of memory used per sort request
(9) MaxUsedMemory	Maximum amount of memory used for a single sort request
(10) MaxUsedMemoryDetected	Date/time when the maximum amount of memory used for a single sort request was detected (YYYY/MM/DD hh:mm:ss)
(11) Concurrency	Number of sort requests currently being processed

• The statistical information in items (3) to (10) can be reset by executing this command with the -r option. Information is then calculated by counting from the time that the information was reset.
• Sorter operation information can also be collected at fixed time intervals. In this case, the following items show the increases that have occurred during the time interval.
  • Cumulative number of sort requests
  • Cumulative number of error responses
  • Average response time (seconds)
  • Average amount of memory used

Example 2

In the following example, operation information for the sorter is collected three times at 60-second intervals and then displayed.

shunostate -s shuno1 -w 60 3  
Shunsaku shunostate 2006/01/01 19:01:00

Time      State          Requests        Errors
          AvgTime(sec)   MaxTime(sec)    MaxTimeDetected
          AvgUsedMemory  MaxUsedMemory   MaxUsedMemoryDetected     Concurrency

19:02:00  ACTIVE         30              0
          2.000          13.000          2006/01/01 19:01:05
          20.0MB         28.0MB          2006/01/01 19:01:10       2

19:03:00  ACTIVE         7               0
          2.300          15.000          2006/01/01 19:02:20
          22.0MB         32.0MB          2006/01/01 19:02:30       5

19:04:00  ACTIVE         20              0
          1.980          16.540          2006/01/01 19:03:20
          23.0MB         33.0MB          2006/01/01 19:03:30       3

Example 3

In the following example, operation information for the sorter is collected three times at 60-second intervals and then output in CSV format.

shunostate -s shuno1 -w -C 60 3 > C:\shunwork\monitor\srtstate.csv

shunostate -s shuno1 -w -C 60 3 > /home/shunsaku/monitor/srtstate.csv

Output content of srtstate.csv

"Time","State","Requests","Errors","AvgTime(sec)","MaxTime(sec)","MaxTimeDetected","AvgUsedMemory","MaxUsedMemory","MaxUsedMemoryDetected","Concurrency"
"2006/01/01 19:02:00","ACTIVE",30,0,2.000,13.000,"2006/01/01 19:01:05",20971520,29360128,"2006/01/01 19:01:10",2
"2006/01/01 19:03:00","ACTIVE",7,0,2.300,15.000,"2006/01/01 19:02:20",23068672,33554432,"2006/01/01 19:02:30",5
"2006/01/01 19:04:00","ACTIVE",20,0,1.980,16.540,"2006/01/01 19:03:20",24117248,34603008,"2006/01/01 19:03:30",3

• Column headings are output in the first line, and operation information is output from the second line.
• The "Time" column uses date/time format (YYYY/MM/DD hh:mm:ss).
• The values in the "AvgUsedMemory" and "MaxUsedMemory" columns are displayed in bytes.
• Each record ends with a linefeed code.

CSV files are output using the following format:

• Enclose character string items in double quotes (").
• Do not enclose numerical values in double quotes (").