The table below lists the event names for performance trace information during execution of SQL code (CONNECT through COMMIT) and information related to these events. Figure 28-3 Conceptualization of performance trace collection points (for a HiRDB single server configuration) and Figure 28-4 Conceptualization of performance trace collection points (for a HiRDB parallel server configuration) show the main collection points for performance trace information.

In addition to the types of information listed below, note that HiRDB's internal information might also be output to performance trace information in some cases.

Table 28-2 Main collection points for performance trace information (during execution of SQL code)

No.	Event name	Event ID	Collection point (number in the figure)#1	Main process	Event type#2	Collection level
1	FES node request acceptance	0x11028F00	1	pdrdm	1	00000004
2	FES node request response	0x11018F00	1	pdrdm	1	00000004
3	CONNECT request acceptance	0x11028A00	1	pdrdm, pdndm	1	00000004
4	CONNECT request response	0x11018A00	2	pdrdm, pdndm	1	00000004
5	Server allocation request acceptance	0x11029100	1	pdscdd	1	00000004
6	Server allocation start	0x11019100	2	pdscdd	1	00000004
7	Server allocation end	0x11029101	2	pdfes, pddic, pdbes, pdsds	1	00000004
8	CONNECT request acceptance (FES, SDS)	0x11022001	1	pdfes, pdsds	1	00000004
9	CONNECT request response (FES, SDS)	0x11012001	2	pdfes, pdsds	1	00000004
10	Buffer output wait start	0x10134003	22	pdbes, pdsds	4b	00000004
11	Buffer output wait completion	0x10134004	22	pdbes, pdsds	4b	00000004
12	Buffer lock wait start	0x13134001	22	pdbes, pdsds	4a	00000004
13	Buffer lock wait completion	0x13134002	22	pdbes, pdsds	4a	00000004
14	Buffer flushing wait start	0x13134003	22	pdbes, pdsds	4d	00000004
15	Buffer flushing wait completion	0x13134004	22	pdbes, pdsds	4d	00000004
16	Buffer input wait start	0x13134005	22	pdbes, pdsds	4c	00000004
17	Buffer input wait completion	0x13134006	22	pdbes, pdsds	4c	00000004
18	Lock release wait start	0x102F8700	22	pdfes, pddic, pdbes, pdsds	8	00000004
19	Lock release wait end	0x102F8701	22	pdfes, pddic, pdbes, pdsds	8	00000004
20	Current log buffer full	0x102F8601	22, 23, 24, 25	pdfes, pddic, pdbes, pdsds, pdlogd, pdlogswd, pdtrnrvd, pdndmd, pdrdmd, pdrsvre	8	00000004
21	System log output destination change	0x10118600	22, 23, 24, 25	pdfes, pddic, pdbes, pdsds, pdtrnrvd, pdndmd, pdrdmd, pdrsvre	8	00000004
22	All system log buffers full	0x102F8602	22, 23, 24, 25	pdfes, pddic, pdbes, pdsds, pdlogd, pdlogswd, pdtrnrvd, pdndmd, pdrdmd, pdrsvre	8	00000004
23	SQL execution request acceptance	0x10022002	3, 13	pdfes, pdsds	1	00000010
24	Server allocation request	0x11019101	4, 8, 14	pdfes, pdbes, pddic	1	00000010
25	Dictionary information collection request	0x10013001	4	pdfes	1	00000010
26	Dictionary information collection request acceptance	0x10023002	5	pddic	1	00000010
27	Sending of dictionary information	0x10013003	6	pddic	1	00000010
28	Receiving of dictionary information	0x10023004	7	pdfes	1	00000010
29	SQL execution request	0x13012503	8	pdfes, pdbes	1	00000010
30	SQL execution request acceptance (BES)	0x13022003	9	pdbes	1	00000010
31	Sending of SQL execution result	0x13012504	10	pdbes	1	00000010
32	Receiving of SQL execution result	0x13022504	11	pdfes, pdbes	1	00000010
33	SQL execution request response	0x10012002	12, 18	pdfes, pdsds	1	00000010
34	Sending of COMMIT request	0x10019600, 0x10029601	14	pdfes	1	00000010
35	Receiving of COMMIT request	0x10029600, 0x10029602, 0x10029603	15	pdbes	1	00000010
36	Sending of COMMIT result	0x10019601	16	pdbes	1	00000010
37	Receiving of COMMIT result	0x10029601	17	pdfes	1	00000010
38	Transaction start	0x11009600	20, 21, 22	pdfes, pdbes, pddic, pdsds	1	00000040
39	System log buffering completion	0x102F8600	22, 23, 24, 25	pdfes, pddic, pdbes, pdsds, pdlogd, pdlogswd, pdtrnrvd, pdndmd, pdrdmd, pdrsvre	8	00000040
40	System log output	0x10008600	22, 23, 24, 25	pdfes, pddic, pdbes, pdsds, pdlogd, pdlogswd, pdtrnrvd, pdndmd, pdrdmd, pdrsvre	2c	00000040
41	Start of take-over of database write processing at synchronization point	0x13114001	22	pdbes, pdsds	2a	00000040
42	Completion of take-over of database write processing at synchronization point	0x13114002	22	pdbes, pdsds	2a	00000040
43	Buffer output start	0x10114001	22	pdbes, pdsds	2a	00000040
44	Buffer output completion	0x10114002	22	pdbes, pdsds	2a	00000040
45	Buffer input start	0x13114003	22	pdbes, pdsds	2a	00000040
46	Buffer input completion	0x13114004	22	pdbes, pdsds	2a	00000040
47	Work table file output start	0x13114101	22	pdbes, pdsds	2b	00000040
48	Work table file output completion	0x13114102	22	pdbes, pdsds	2b	00000040
49	Work table file input start	0x13114103	22	pdbes, pdsds	2b	00000040
50	Work table file input completion	0x13114104	22	pdbes, pdsds	2b	00000040
51	Sending of SQL execution request (XDS)	0x10011001	--	pdxds	1	00000010
52	Receiving of SQL execution request	0x10021002	--	pdxds	1	00000010
53	Connection to the system manager (XDS)	0x11011003	--	pdxds	1	00000010
54	Receiving of connection-target FES information (XDS)	0x11021004	--	pdxds	1	00000010
55	Connection to the node manager (XDS)	0x11011005	--	pdxds	1	00000010
56	Receiving of connection-target scheduler information (XDS)	0x11021006	--	pdxds	1	00000010
57	Connection to the scheduler (XDS)	0x11011007	--	pdxds	1	00000010
58	Receiving of CONNECT request response (XDS)	0x11021008	--	pdxds	1	00000010

Legend:

--: Collected when a memory database is used.

#1

Corresponds to a number in Figure 28-3 Conceptualization of performance trace collection points (for a HiRDB single server configuration) or Figure 28-4 Conceptualization of performance trace collection points (for a HiRDB parallel server configuration). This means that performance trace information is collected at the collection point indicated by the corresponding number in the figure.

#2

The following table describes event types:

Event type	Description
1	Communication
2a	Disk I/O: Global buffer
2b	Disk I/O: Work table
2c	Disk I/O: System log
4a	Global buffer lock information: Buffer lock wait
4b	Global buffer lock information: Buffer output wait
4c	Global buffer lock information: Buffer input wait
4d	Global buffer lock information: Buffer flushing wait
8	Other

Figure 28-3 Conceptualization of performance trace collection points (for a HiRDB single server configuration)

Legend:

: Performance trace collection point

: Processing that takes place between performance trace collection points

Figure 28-4 Conceptualization of performance trace collection points (for a HiRDB parallel server configuration)

Legend:

: Performance trace collection point

: Processing that takes place between performance trace collection points