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

F.2.1 Conductor Performance Log

The following performance information is output in a conductor performance log:

• Common Information
• Individual Information
• Output Example

Common Information

The following information is output regardless of the request type and the output type.

Output Item	Explanation
Output Item 1 (OutputTime)	Output time of the performance log
Output Item 2 (Id)	Conductor identifier name
Output Item 3 (RequestNo)	Request number
Output Item 5 (RequestKind)	Request type (the value in the list of individual information)
Output Item 6 (OutputType)	Output type (The Output Item 6 in the list of individual information)
Output Item 7 (OutputKind)	A kind of output (The Output Item 7 in the list of individual information)
Output Item 18 (ErrorInfo)	An error message when an error occurs

Remarks: Output Item 18 is output only when an error occurs.

Individual Information

For the individual information, the output information is different depended on the request type (RequestKind: Output Item 5), the output type (OutputType: Output Item 6) and the kind of output information (OutputKind: Output Item 7).

Request type (Output Item 5 )	Request content
Connect	Connection from API
SetShunsakuFile	Switching from Shunsaku File
GetHitCount	Search (ShunGetHitCount)
Search	Search (ShunSearch)
SearchRecId	Search (ShunSearchRecId)
Sort	Sort and aggregation (ShunSearch)
Insert-C / Update-C / Delete-C	Insert, update, delete (auto-commit is enabled)
Insert / Update / Delete	Insert, update, delete (auto-commit is disabled)
Commit / Rollback	Commit/rollback
SearchKey	Search by Direct access key (ShunSearchKey)
UpdateKey-C / DeleteKey-C	Update by direct access key, delete by direct access key (auto-commit is enabled)
UpdateKey / DeleteKey	Update by direct access key, delete by direct access key (auto-commit is disabled)

The following table shows output contents of each request type:

5	6	7	8	9	10	11	12	13	14	15	16	17
RequestKind (Request type)	OutputType	OutputKind	RequestTime	Response	Result	Client	TransactionId	Records	RetRecords	RetDataSize	MultiCount	DetailInfo
Connect	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-	-	-	-	-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API[,ShunsakuFile=ShunsakuFile name]
SetShunsakuFile	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-	-	-	-	-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API[,ShunsakuFile=ShunsakuFile name]
	4	DIR-PROCESS (*1)				-	-	-	-	-	-	Id=director identifier
GetHitCount	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-		-	-	-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	4	DIR-PROCESS				-	-		-	-	-	Id=director identifier, MaxSearcherTime=actual search time of searcher (sec.)[,MultiMax over occurred.]
Search	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-				-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	SEARCH-PHASE				-	-		-	-	-	-
	4	DIR-PROCESS				-	-		-	-	-	Id=director identifier, MaxSearcherTime=actual search time of searcher (sec.)[,MultiMax over occurred.]
	3	GETREC-PHASE				-	-	-			-	-
	4	DIR-PROCESS				-	-	-			-	Id=director identifier
SearchRecId	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-				-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	4	DIR-PROCESS				-	-				-	Id=director identifier
Sort	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-				-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	SEARCH-PHASE				-	-		-	-	-	-
	4	DIR-PROCESS				-	-		-	-	-	Id=director identifier, MaxSearcherTime=actual search time of searcher (sec.)[,MultiMax over occurred.]
	3	PARSING-PHASE				-	-	-	-	-	-	-
	4	SORT-PROCESS				-	-	-	-	-	-	Id=sorter identifier
	3	GETREC-PHASE				-	-	-			-	-
	4	DIR-PROCESS				-	-	-			-	Id=director identifier
	3	SORTING-PHASE				-	-	-			-	-
	4	SORT-PROCESS				-	-	-			-	Id=sorter identifier, UsedMemory=amount of memory use (byte), SortTime=sort time (sec.)
Insert-C Update-C Delete-C	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY							-		-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	UPDATE-PHASE				-			-		-	-
	4	DIR-PROCESS				-			-		-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
	3	SWITCH-PHASE				-		-	-	-	-	Kind=COMMIT or ROLLBACK
	4	DIR-PROCESS				-		-	-	-	-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
Insert Update Delete	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY							-		-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	UPDATE-PHASE				-			-		-	-
	4	DIR-PROCESS				-			-		-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
	3	SWITCH-PHASE (*2)				-		-	-	-	-	Kind=ROLLBACK
	4	DIR-PROCESS (*2)				-		-	-	-	-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
Commit Rollback	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY						-	-	-	-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	4	DIR-PROCESS				-		-	-	-	-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
SearchKey	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY					-				-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	4	DIR-PROCESS				-	-				-	Id=directoridentifier
UpdateKey-C DeleteKey-C	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY							-		-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	UPDATE-PHASE				-			-		-	-
	4	DIR-PROCESS				-			-		-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
	3	SWITCH-PHASE				-		-	-	-	-	Kind=COMMIT or ROLLBACK
	4	DIR-PROCESS				-		-	-	-	-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
UpdateKey DeleteKey	0	START		-	-		-	-	-	-	-	-
	1	SUMMARY							-		-	APIRecvTime=Time for receiving request from API, APISendTime=Time for sending result to API
	3	UPDATE-PHASE				-			-		-	-
	4	DIR-PROCESS				-			-		-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)
	3	SWITCH-PHASE (*2)				-		-	-	-	-	Kind=ROLLBACK
	4	DIR-PROCESS (*2)				-		-	-	-	-	Id=director identifier, MaxSearcherTime=actual update time of searcher (sec.)

: Item to be output
-: Item not to be output
*1) This is output if Shunsaku File has been switched during the transaction (adding, updating or deleting data without auto-commit).
*2) This is output only when an error occurs while adding, updating and deleting data.

Output Example

"OutputTime","Id","RequestNo","SearcherReqNo","RequestKind","OutputType","OutputKind","RequestTime","Response","Result","Client","TransactionId","Records","RetRecords","RetDataSize","MultiCount","DetailInfo","ErrorInfo"
"2006/03/22 20:12:27.376","shunc","442130f100000001",,"Connect",0,"START","20:12:27.375",,,"127.0.0.1:55101",,,,,,,
"2006/03/22 20:12:27.376","shunc","442130f100000001",,"Connect",1,"SUMMARY","20:12:27.375",0.001,0,"127.0.0.1:55101",,,,,,"APIRecvTime=0.000,APISendTime=0.000",
"2006/03/22 20:12:27.418","shunc","442130f100000002",,"Search",0,"START","20:12:27.418",,,"127.0.0.1:55101",,,,,,,
"2006/03/22 20:12:28.030","shunc","442130f100000002",,"Search",4,"DIR-PROCESS","20:12:27.419",0.610,0,,,100,,,,"Id=shund2,MaxSearcherTime=0.606",
"2006/03/22 20:12:28.032","shunc","442130f100000002",,"Search",4,"DIR-PROCESS","20:12:27.419",0.613,0,,,280,,,,"Id=shund1,MaxSearcherTime=0.609",
"2006/03/22 20:12:28.032","shunc","442130f100000002",,"Search",3,"SEARCH-PHASE","20:12:27.419",0.613,0,,,380,,,,,
"2006/03/22 20:12:28.041","shunc","442130f100000002",,"Search",4,"DIR-PROCESS","20:12:28.032",0.009,0,,,,100,2190,,"Id=shund2",
"2006/03/22 20:12:28.053","shunc","442130f100000002",,"Search",4,"DIR-PROCESS","20:12:28.032",0.020,0,,,,280,6148,,"Id=shund1",
"2006/03/22 20:12:28.053","shunc","442130f100000002",,"Search",3,"GETREC-PHASE","20:12:28.032",0.020,0,,,,380,8338,,,
"2006/03/22 20:12:28.058","shunc","442130f100000002",,"Search",1,"SUMMARY","20:12:27.418",0.640,0,"127.0.0.1:55101",,380,380,8338,,"APIRecvTime=0.000,APISendTime=0.005",
"2006/03/22 20:13:16.738","shunc","442130f100000005",,"Update-C",0,"START","20:13:16.681",,,"127.0.0.1:55128",,,,,,,
"2006/03/22 20:13:16.930","shunc","442130f100000005",,"Update-C",4,"DIR-PROCESS","20:13:16.738",0.192,0,,"442130f1-00000001",100,,38990,,"Id=shund2,MaxSearcherTime=0.004",
"2006/03/22 20:13:17.133","shunc","442130f100000005",,"Update-C",4,"DIR-PROCESS","20:13:16.738",0.395,0,,"442130f1-00000001",280,,109188,,"Id=shund1,MaxSearcherTime=0.009",
"2006/03/22 20:13:17.133","shunc","442130f100000005",,"Update-C",3,"UPDATE-PHASE","20:13:16.738",0.395,0,,"442130f1-00000001",380,,148178,,,
"2006/03/22 20:13:17.140","shunc","442130f100000005",,"Update-C",4,"DIR-PROCESS","20:13:17.133",0.006,0,,"442130f1-00000001",,,,,"Id=shund2,MaxSearcherTime=0.000",
"2006/03/22 20:13:17.146","shunc","442130f100000005",,"Update-C",4,"DIR-PROCESS","20:13:17.134",0.012,0,,"442130f1-00000001",,,,,"Id=shund1,MaxSearcherTime=0.000",
"2006/03/22 20:13:17.146","shunc","442130f100000005",,"Update-C",3,"SWITCH-PHASE","20:13:17.133",0.012,0,,"442130f1-00000001",,,,,"Kind=COMMIT",
"2006/03/22 20:13:17.146","shunc","442130f100000005",,"Update-C",1,"SUMMARY","20:13:16.681",0.465,0,"127.0.0.1:55128","442130f1-00000001",380,,148178,,"APIRecvTime=0.057,APISendTime=0.000",