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

6.2.2 Monitoring Conductor Operation Information

Conductor operation information can be used for the following purposes:

• Checking the operating status of the conductor
• Checking statistical information about requests from applications
• Checking which director or sorter has caused a communication problem if it occurs when an application is executed and attempts to communicate with a director or sorter

Conductor operation information can be obtained by executing the shuncstate command on the server where the conductor is located.

Example 1

The following example shows how conductor operation information is displayed.

shuncstate -s shunc -w 
Shunsaku shuncstate 2006/01/01 19:01:00

(1)       (2)       (3)          (4)        (5)         (6)         (7)
Time      State     Connections Searches    Sorts       Updates     Errors 
19:01:00  ACTIVE    310         100         20          150         0      

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 conductor The operating status of the conductor is displayed as follows: ACTIVE: Running
(3) Connections	Number of connections that have been established with the conductor
(4) Searches	Cumulative number of search requests
(5) Sorts	Cumulative number of search requests with sort specifications
(6) Updates	Cumulative number of update (insert, update or delete) requests
(7) Errors	Cumulative number of error responses

The statistical information in items (4) to (7) show cumulative values counted from when the conductor started or when statistical information was reset. Statistical information can be reset by executing this command with the -r option.

Conductor operation information can also be collected at fixed time intervals. In this case, items (4) to (7) show the increases that have occurred during the time interval.

Example 2

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

shuncstate -s shunc -w 60 3 
Shunsaku shuncstate 2006/01/01 19:01:00

Time      State     Connections Searches    Sorts       Updates     Errors
19:02:00  ACTIVE    310         20          10          7           0     
19:03:00  ACTIVE    350         5           0           1           0     
19:04:00  ACTIVE    203         7           0           0           0     

Example 3

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

shuncstate -s shunc -w -C 60 3 > C:\shunwork\monitor\constate.csv

shuncstate -s shunc -w -C 60 3 > /home/shunsaku/monitor/constate.csv

Content of constate.csv

"Time","State","Connections","Searches","Sorts","Updates","Errors"
"2006/01/01 19:02:00","ACTIVE",310,10,20,7,0
"2006/01/01 19:03:00","ACTIVE",350,0,5,1,0
"2006/01/01 19:04:00","ACTIVE",203,0,7,0,0

• 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).
• Each record ends with a linefeed code.

Information for the sorters and directors connected to the conductor can be obtained by executing the shuncstate command with the -p option.

Example 4

The following example shows how information for the sorters and directors connected to the conductor is displayed.

shuncstate -s shunc -p
Shunsaku shuncstate 2006/01/01 19:01:00

(1)                 (2)      (3)             (4)         (5)
Type                ID       Hostname        State       LatestTime(sec)    LatestTime(sec)
Sorter              shuno1   DirSvr1         ACTIVE      2.000
Director            shund1   DirSvr1         ACTIVE      10.000
Director            shund2   DirSvr1         ACTIVE      12.000
Director            shund3   DirSvr1         ACTIVE      15.000

The following table shows the explanation of the item displayed.

Item Displayed	Explanation
(1) Type	Process type One of the following is displayed for the process type: Sorter Director
(2) ID	Process identifier
(3) Hostname	Host name or IP address
(4) State	Communication status The following is displayed for the process status. ACTIVE: Running INACTIVE : Error This parameter is 'ACTIVE' when the conductor is running. If a communication problem is detected while an application process is communicating with a director or sorter, this parameter will change to 'INACTIVE'. Once the problem has been resolved and communications is restored, its status returns to 'ACTIVE'.
(5) LatestTime(sec)	The latest respond time (in seconds) of the director and sorter.

Example 5

In the following example, information for the sorters and directors connected to the conductor is output in CSV format.

shuncstate -s shunc -p -C > C:\shunwork\monitor\constate.csv

shuncstate -s shunc -p -C > /home/shunsaku/monitor/constate.csv

Content of constate.csv

"Type","ID","Hostname","State","LatestTime(sec)"
"Sorter","shuno1","DirSvr1","ACTIVE",2.000
"Director","shund1","DirSvr1","ACTIVE",10.000
"Director","shund2","DirSvr1","ACTIVE",12.000
"Director","shund3","DirSvr1","ACTIVE",15.000

• Column headings are output in the first line, and operation information is output from the second line.
• 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 (").