Tables 14-5 through 14-22 show the record formats of the DAT-format files.
The following notes apply to these tables:
Table 14-5 Record format of a DAT-format file (system activity statistical information (1))
No. | Field name (title bar) | Attribute | Maximum length | Remarks | ||
---|---|---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() | ||
2 | Server name (SERVER) | 8 | ******** for overall statistical information | |||
3 | Edit time (START) | 11 | Format MM/DD/hh:mm | |||
4 | Schedule information (SCHEDULE) | Length of schedule queue (QUEUE LEN(SCH)) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
5 | Maximum value (MAX) | |||||
6 | Minimum value (MIN) | |||||
7 | Average value (AVG) | |||||
8 | Scheduled message length (MESSAGE LEN) | Number of occurrences (FREQ) | ![]() | |||
9 | Maximum value (MAX) | In bytes | ||||
10 | Minimum value (MIN) | |||||
11 | Average value (AVG) | |||||
12 | Process information (PROCESS) | Server abnormal terminations count (SERVER ABORT) | Number of occurrences (FREQ) | Numeric | 10 | Processing information continues with Nos. 174-177. |
13 | Server abnormal terminations count for HiRDB internal server (SYSTEM SERVER ABORT) | Number of occurrences (FREQ) | ![]() | |||
14 | Number of processes (PROCESS COUNT) | Maximum value (MAX) | ||||
15 | Minimum value (MIN) | |||||
16 | Average value (AVG) | |||||
17 | Transaction information (TRANSACTION) | Commits count (COMMIT) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
18 | Rollbacks count (ROLLBACK) | Number of occurrences (FREQ) | ||||
19 | Name server information (NAME) | System-specific information (CACHE HIT) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
20 | System-specific information (LOCAL HIT) | Number of occurrences (FREQ) | ||||
21 | System-specific information (LOOK UP) | Number of occurrences (FREQ) | ||||
22 | RPC information (RPC) | System-specific information (RESPONSE TIME) | Number of occurrences (FREQ) | Numeric | 10 | RPC information for users is listed in Nos. 178-199 and 252-259. |
23 | Maximum value (MAX) | ![]() | ||||
24 | Minimum value (MIN) | |||||
25 | Average value (AVG) | |||||
26 | System-specific information (USER SERVICE TIME) | Number of occurrences (FREQ) | ![]() | |||
27 | Maximum value (MAX) | |||||
28 | Minimum value (MIN) | |||||
29 | Average value (AVG) | |||||
30 | System-specific information (TIME OUT) | Number of occurrences (FREQ) | ||||
31 | System-specific information (ERROR) | Number of occurrences (FREQ) | ||||
32 | System-specific information (SEND) | Number of occurrences (FREQ) | ||||
33 | System-specific information (RECEIVE) | Number of occurrences (FREQ) | ||||
34 | Lock information (LOCK) | Lock release wait time (WAIT TIME) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
35 | Maximum value (MAX) | In milliseconds | ||||
36 | Minimum value (MIN) | |||||
37 | Average value (AVG) | |||||
38 | Lock queue length (number of users) (QUEUE LEN) | Number of occurrences (FREQ) | ![]() | |||
39 | Maximum value (MAX) | |||||
40 | Minimum value (MIN) | |||||
41 | Average value (AVG) | |||||
42 | Deadlocks count (DEADLOCK) | Number of occurrences (FREQ) | ||||
43 | Utilization factor of locked resources management table (USE LOCK TABLE) | Number of occurrences (FREQ) | ||||
44 | Maximum value (MAX) | 3 | Percentage | |||
45 | Minimum value (MIN) | |||||
46 | Average value (AVG) | |||||
47 | Shared memory information (SHARED MEMORY) | System-specific information (STATIC GET SIZE) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
48 | Maximum value (MAX) | In bytes | ||||
49 | Minimum value (MIN) | |||||
50 | Average value (AVG) | |||||
51 | System-specific information (STATIC POOL SIZE) | Number of occurrences (FREQ) | ![]() | |||
52 | Maximum value (MAX) | In bytes | ||||
53 | Minimum value (MIN) | |||||
54 | Average value (AVG) | |||||
55 | System-specific information (DYNAMIC GET SIZE) | Number of occurrences (FREQ) | ![]() | |||
56 | Maximum value (MAX) | In bytes | ||||
57 | Minimum value (MIN) | |||||
58 | Average value (AVG) | |||||
59 | System-specific information (DYNAMIC POOL SIZE) | Number of occurrences (FREQ) | ![]() | |||
60 | Maximum value (MAX) | In bytes | ||||
61 | Minimum value (MIN) | |||||
62 | Average value (AVG) | |||||
63 | Size of shared memory allocated for server or for HiRDB internal server (SEGMENT SIZE) | Average value (AVG) | In KB | |||
64 | Shared static memory allocation size (STATIC SIZE) | Average value (AVG) | ||||
65 | Shared dynamic memory allocation size (DYNAMIC SIZE) | Average value (AVG) | ||||
66 | Shared memory allocation size for global buffer (SIZE FOR BUFFER) | Average value (AVG) | ||||
67 | Synchronization point information (SYNC POINT) | Synchronization point dump collection time (GET INTERVAL TIME) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
68 | Maximum value (MAX) | In milliseconds | ||||
69 | Minimum value (MIN) | |||||
70 | Average value (AVG) | |||||
71 | Synchronization point dump interval (GET TIME) | Number of occurrences (FREQ) | ![]() | |||
72 | Maximum value (MAX) | In milliseconds | ||||
73 | Minimum value (MIN) | |||||
74 | Average value (AVG) | |||||
75 | Log information (LOG) | Buffer-fulls count (BUFFER FULL) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
76 | Waits count due to no current buffer (WAIT THREAD) | Number of occurrences (FREQ) | ||||
77 | Output block length (OUTPUT BLOCK LEN) | Number of occurrences (FREQ) | ||||
78 | Maximum value (MAX) | In bytes | ||||
79 | Minimum value (MIN) | |||||
80 | Average value (AVG) | |||||
81 | Non-bus data length (NOT BUS LEN) | Number of occurrences (FREQ) | ![]() | |||
82 | Maximum value (MAX) | In bytes | ||||
83 | Minimum value (MIN) | |||||
84 | Average value (AVG) | |||||
85 | Number of buffer sectors waiting for I/O (WAIT BUFFER FOR IO) | Number of occurrences (FREQ) | ![]() | |||
86 | Maximum value (MAX) | |||||
87 | Minimum value (MIN) | |||||
88 | Average value (AVG) | |||||
89 | Number of file write operations (WRITE TO FILE) | Number of occurrences (FREQ) | ![]() | |||
90 | Write errors count (WRITE ERROR) | Number of occurrences (FREQ) | ||||
91 | Log file swapping time (LOG FILE SWAP TIME) | Number of occurrences (FREQ) | ||||
92 | Maximum value (MAX) | In milliseconds | ||||
93 | Minimum value (MIN) | |||||
94 | Average value (AVG) | |||||
95 | Log input data length (LOG INPUT DATA) | Number of occurrences (FREQ) | ![]() | |||
96 | Maximum value (MAX) | In bytes | ||||
97 | Minimum value (MIN) | |||||
98 | Average value (AVG) | |||||
99 | Number of file read operations (READ FROM FILE) | Number of occurrences (FREQ) | ![]() | |||
100 | Read errors count (READ ERROR) | Number of occurrences (FREQ) | ![]() |
Table 14-6 Record format of a DAT-format file (system activity statistical information (2))
No. | Field name (title bar) | Attribute | Maximum length | Remarks | ||
---|---|---|---|---|---|---|
101 | Dictionary information (DICTIONARY) | Number of table definition information acquisition requests (TBL-DEF GET REQ) | Number of occurrences (FREQ) | Numeric | 10 | Dictionary information is continued to Nos. 200-251 and 260-267. |
102 | Table definition information buffer hits count (TABLE CACHE HIT) | Number of occurrences (FREQ) | ![]() | |||
103 | Number of definition information items in table definition information buffer (CASHED TBL-DEF) | Number of occurrences (FREQ) | ![]() | |||
104 | Maximum value (MAX) | |||||
105 | Minimum value (MIN) | |||||
106 | Average value (AVG) | |||||
107 | Size of table definition information buffer used per table definition information item (USE TBL-DEF SIZE) | Number of occurrences (FREQ) | ![]() | |||
108 | Maximum value (MAX) | In bytes | ||||
109 | Minimum value (MIN) | |||||
110 | Average value (AVG) | |||||
111 | Size of area used by table definition information buffer (CACHED TBL-DEF SIZE) | Number of occurrences (FREQ) | ![]() | |||
112 | Maximum value (MAX) | In bytes | ||||
113 | Minimum value (MIN) | |||||
114 | Average value (AVG) | |||||
115 | Table access privilege information acquisitions count (ACCESS PRIV CHECK) | Number of occurrences (FREQ) | ![]() | |||
116 | Table access privilege information buffer hits count (CACHE HIT(ACCESS)) | Number of occurrences (FREQ) | ![]() | |||
117 | User privilege information acquisition requests (CON/DBA DEF GET REQ) | Number of occurrences (FREQ) | ![]() | |||
118 | User privilege information buffer hits count (CON/DBA CACHE HIT) | Number of occurrences (FREQ) | ![]() | |||
119 | Number of users using the user privilege information buffer (CON/DBA CACHED USER) | Number of occurrences (FREQ) | ![]() | |||
120 | Maximum value (MAX) | ![]() | ||||
121 | Minimum value (MIN) | ![]() | ||||
122 | Average value (AVG) | ![]() | ||||
123 | Length of communication with dictionary server (DIC TRANS DATA LEN) | Number of occurrences (FREQ) | ![]() | |||
124 | Maximum value (MAX) | In bytes | ||||
125 | Minimum value (MIN) | |||||
126 | Average value (AVG) | |||||
127 | Dictionary server communications count (TRANS) | Number of occurrences (FREQ) | ![]() | |||
128 | Number of view analysis information acquisition requests (VIEW DEF GET REQ) | Number of occurrences (FREQ) | ||||
129 | View analysis information buffer hits count (VIEW DEF CACHE HIT) | Number of occurrences (FREQ) | ||||
130 | Number of view analysis information items in view analysis information buffer (VIEW CACHED DEF) | Number of occurrences (FREQ) | ![]() | |||
131 | Size of view analysis information buffer used per view analysis information item (USED VIEW SIZE) | Number of occurrences (FREQ) | ||||
132 | Maximum value (MAX) | In bytes | ||||
133 | Minimum value (MIN) | |||||
134 | Average value (AVG) | |||||
135 | Length of view analysis information buffer used (VIEW CACHE SIZE) | Number of occurrences (FREQ) | ![]() | |||
136 | Maximum value (MAX) | In bytes | ||||
137 | Minimum value (MIN) | |||||
138 | Average value (AVG) | |||||
139 | Length of view analysis information resulting in buffer miss (CACHE MISS VIEW SIZE) | Number of occurrences (FREQ) | ![]() | |||
140 | Maximum value (MAX) | In bytes | ||||
141 | Minimum value (MIN) | |||||
142 | Average value (AVG) | |||||
143 | SQL object information for single server, front-end server, back-end server, or dictionary server (FES-BES-DIC(SDS) INFORMATION) | Number of SQL object acquisition requests (SQLOBJ GET REQ) | Number of occurrences (FREQ) | ![]() | ||
144 | SQL object buffer hits count (SQLOBJ CACHE HIT) | Number of occurrences (FREQ) | ||||
145 | Number of SQL objects in SQL object buffer (CACHED SQLOBJ) | Number of occurrences (FREQ) | ||||
146 | Maximum value (MAX) | |||||
147 | Minimum value (MIN) | |||||
148 | Average value (AVG) | |||||
149 | Total length of SQL objects in SQL object buffer (CACHED SQLOBJ SIZE) | Number of occurrences (FREQ) | ![]() | |||
150 | Maximum value (MAX) | In KB | ||||
151 | Minimum value (MIN) | |||||
152 | Average value (AVG) | |||||
153 | Number of SQL objects swapped out of SQL object buffer (SWAP OUT SQLOBJ) | Number of occurrences (FREQ) | ![]() | |||
154 | SQL object length (SQLOBJ LEN) | Number of occurrences (FREQ) | ![]() | |||
155 | Maximum value (MAX) | In bytes | ||||
156 | Minimum value (MIN) | |||||
157 | Average value (AVG) | |||||
158 | Number of acquisition requests for stored procedure objects (STROBJ GET REQ) | Number of occurrences (FREQ) | ![]() | |||
159 | SQL object buffer hits count for stored procedure objects (STROBJ CACHE HIT) | Number of occurrences (FREQ) | ||||
160 | Number of stored procedure objects in SQL object buffer (CACHED STROBJ) | Number of occurrences (FREQ) | ![]() | |||
161 | Maximum value (MAX) | |||||
162 | Minimum value (MIN) | |||||
163 | Average value (AVG) | |||||
164 | Total length of stored procedure objects in SQL object buffer (CACHED STROBJ SIZE) | Number of occurrences (FREQ) | ![]() | |||
165 | Maximum value (MAX) | In KB | ||||
166 | Minimum value (MIN) | |||||
167 | Average value (AVG) | |||||
168 | Number of stored procedure objects swapped out of SQL object buffer (SWAP OUT STROBJ) | Number of occurrences (FREQ) | ![]() | |||
169 | Stored procedure object length (STROBJ LEN) | Number of occurrences (FREQ) | ||||
170 | Maximum value (MAX) | In bytes | ||||
171 | Minimum value (MIN) | |||||
172 | Average value (AVG) | |||||
173 | Number of times stored procedure objects were recompiled (STROBJ RECOMPILE) | Number of occurrences (FREQ) | ![]() | |||
174 | Process information (PROCESS) | Number of server processes under service execution (SERVICE COUNT) | Maximum value (MAX) | Numeric | 10 | ![]() |
175 | Minimum value (MIN) | |||||
176 | Average value (AVG) | |||||
177 | Number of service requests exceeding maximum number of startup processes (REQUEST OVER) | Number of requests (FREQ) | ||||
178 | RPC information (RPC) | Service response time for local unit's servers (RESPONSE ON OWN UNIT) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
179 | Maximum value (MAX) | In 100 microseconds | ||||
180 | Minimum value (MIN) | |||||
181 | Average value (AVG) | |||||
182 | Service response time for remote unit's servers (RESPONSE TO OTHER UNIT) | Number of occurrences (FREQ) | ![]() | |||
183 | Maximum value (MAX) | In 100 microseconds | ||||
184 | Minimum value (MIN) | |||||
185 | Average value (AVG) | |||||
186 | Execution time per service from local unit's servers (EXEC TIME ON OWN UNIT) | Number of occurrences (FREQ) | ![]() | |||
187 | Maximum value (MAX) | In 100 microseconds | ||||
188 | Minimum value (MIN) | |||||
189 | Average value (AVG) | |||||
190 | Execution time per service from remote unit's servers (EXEC TIME FROM OTHER UNIT) | Number of occurrences (FREQ) | ![]() | |||
191 | Maximum value (MAX) | In 100 microseconds | ||||
192 | Minimum value (MIN) | |||||
193 | Average value (AVG) | |||||
194 | Number of SENDs to local process (SEND TO OWN PRCS) | Number of occurrences (FREQ) | ![]() | |||
195 | Number of SENDs to other processes on local unit (SEND TO OTHER PRCS) | Number of occurrences (FREQ) | ||||
196 | Number of SENDs to remote unit (SEND TO OTHER UNIT) | Number of occurrences (FREQ) | ||||
197 | Number of RECEIVEs from local process (RECEIVE FROM OWN PRCS) | Number of occurrences (FREQ) | ||||
198 | Number of RECEIVEs from other processes on local unit (RECEIVE FROM OTHER PRCS) | Number of occurrences (FREQ) | ||||
199 | Number of RECEIVEs from remote unit (RECEIVE FROM OTHER UNIT) | Number of occurrences (FREQ) |
Table 14-7 Record format of a DAT-format file (system activity statistical information (3))
No. | Field name (title bar) | Attribute | Maximum length | Remarks | ||
---|---|---|---|---|---|---|
200 | Dictionary information (DICTIONARY) | Number of type definition information acquisition requests (TYPE-DEF GET REQ) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
201 | User-defined type information buffer hits count (TYPE-DEF CACHE HIT) | Number of occurrences (FREQ) | ||||
202 | Number of type definition information items in user-defined type information buffer (CACHED TYPE-DEF) | Number of occurrences (FREQ) | ||||
203 | Maximum value (MAX) | |||||
204 | Minimum value (MIN) | |||||
205 | Average value (AVG) | |||||
206 | Size of area used by user-defined type information buffer per type definition information item (TYPE-DEF CACHE SIZE) | Number of occurrences (FREQ) | ||||
207 | Maximum value (MAX) | In bytes | ||||
208 | Minimum value (MIN) | |||||
209 | Average value (AVG) | |||||
210 | Total size of area used by user-defined type information buffer (TYPE-DEF CACHE TOTAL SIZE) | Number of occurrences (FREQ) | ![]() | |||
211 | Maximum value (MAX) | In bytes | ||||
212 | Minimum value (MIN) | |||||
213 | Average value (AVG) | |||||
214 | Size of user-defined type information buffer allocated (TYPE-DEF CACHE ALLOC SIZE) | Number of occurrences (FREQ) | ![]() | |||
215 | Maximum value (MAX) | In bytes | ||||
216 | Minimum value (MIN) | |||||
217 | Average value (AVG) | |||||
218 | Number of routine definition information acquisition requests (RTN-DEF GET REQ) | Number of occurrences (FREQ) | ![]() | |||
219 | Routine definition information buffer hits count (RTN-DEF CACHE HIT) | Number of occurrences (FREQ) | ![]() | |||
220 | Number of routine definition information items in routine definition information buffer (CACHED RTN-DEF) | Number of occurrences (FREQ) | ||||
221 | Maximum value (MAX) | |||||
222 | Minimum value (MIN) | |||||
223 | Average value (AVG) | |||||
224 | Size of area used by routine definition information buffer per routine definition information item (RTN-DEF CACHE SIZE) | Number of occurrences (FREQ) | ![]() | |||
225 | Maximum value (MAX) | In bytes | ||||
226 | Minimum value (MIN) | |||||
227 | Average value (AVG) | |||||
228 | Total size of area used by routine definition information buffer (RTN-DEF CACHE TOTAL SIZE) | Number of occurrences (FREQ) | ![]() | |||
229 | Maximum value (MAX) | In bytes | ||||
230 | Minimum value (MIN) | |||||
231 | Average value (AVG) | |||||
232 | Size of routine definition information buffer allocated (RTN-DEF CACHE ALLOC SIZE) | Number of occurrences (FREQ) | ![]() | |||
233 | Maximum value (MAX) | In bytes | ||||
234 | Minimum value (MIN) | |||||
235 | Average value (AVG) | |||||
236 | Number of routine definition acquisition requests for plug-in-provided functions (PLG-RTN GET REQ) | Number of occurrences (FREQ) | ![]() | |||
237 | Routine definition information buffer hits count for plug-in provided functions (PLG-RTN CACHE HIT) | Number of occurrences (FREQ) | ||||
238 | Number of registry information acquisition requests (REGISTRY GET REQ) | Number of occurrences (FREQ) | ![]() | |||
239 | Registry information buffer hits count (REGISTRY CACHE HIT) | Number of occurrences (FREQ) | ||||
240 | Number of registry information items in registry information buffer (CACHED REGISTRY-DEF) | Number of occurrences (FREQ) | ||||
241 | Maximum value (MAX) | |||||
242 | Minimum value (MIN) | |||||
243 | Average value (AVG) | |||||
244 | Size of registry information buffer per registry information item (REGISTRY CACHE SIZE) | Number of occurrences (FREQ) | ||||
245 | Maximum value (MAX) | In bytes | ||||
246 | Minimum value (MIN) | |||||
247 | Average value (AVG) | |||||
248 | Total size of area used by registry information buffer (REGISTRY CACHE TOTAL SIZE) | Number of occurrences (FREQ) | ![]() | |||
249 | Maximum value (MAX) | In bytes | ||||
250 | Minimum value (MIN) | |||||
251 | Average value (AVG) | |||||
252 | RPC information (RPC) | Number of HiRDB-reserved ports used (REGISTERED PORTS) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
253 | Maximum value (MAX) | |||||
254 | Minimum value (MIN) | |||||
255 | Average value (AVG) | |||||
256 | Number of ports automatically assigned by OS when HiRDB-reserved ports ran out (ASSIGNED PORTS) | Number of occurrences (FREQ) | ||||
257 | Maximum value (MAX) | |||||
258 | Minimum value (MIN) | |||||
259 | Average value (AVG) | |||||
260 | Dictionary information (DICTIONARY) | Directory-registered user authentication time (DIRECTORY USER CHECK TIME) | Number of occurrences (FREQ) | Numeric | 10 | ![]() |
261 | Maximum value (MAX) | In microseconds | ||||
262 | Minimum value (MIN) | |||||
263 | Average value (AVG) | |||||
264 | Group checking time (GROUP CHECK TIME) | Number of occurrences (FREQ) | ![]() | |||
265 | Maximum value (MAX) | In microseconds | ||||
266 | Minimum value (MIN) | |||||
267 | Average value (AVG) |
Table 14-8 Record format of a DAT-format file: UAP statistical information
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | UAP or transaction execution start time (START) | Character | 14 | Format: MM/DD/hh:mm:ss |
4 | No. 3 in microseconds (START (MICRO)) | Numeric | 6 | Value in seconds is not included. |
5 | UAP or transaction execution termination time (END) | Character | 14 | Format: MM/DD/hh:mm:ss |
6 | No. 5 in microseconds (END (MICRO)) | Numeric | 6 | Value in seconds is not included. |
7 | Termination status (STATUS) | Character | 1 | N: Normal termination E: Termination after rollback |
8 | UAP or transaction execution time (UAP EXEC TIME(S)) | Numeric | 10 | In seconds (value less than a second is rounded) |
9 | Size of table definition information buffer used (CACHE SIZE) | In bytes | ||
10 | Number of SQL object acquisition requests (REQ (SQL)) | ![]() | ||
11 | SQL object buffer hits count (HITS (SQL)) | |||
12 | SQL object creations count (CREATE) | |||
13 | Maximum size of SQL object created (SQL MAX) | In bytes | ||
14 | COMMIT statement executions count (COMMIT) | ![]() | ||
15 | ROLLBACK statement executions count (ROLLBACK) | |||
16 | Number of rows actually retrieved by FETCH or SELECT statement (FETCH ROW) | |||
17 | Number of rows actually deleted by DELETE statement (DELETE ROW) | |||
18 | Number of rows actually inserted by INSERT statement (INSERT ROW) | |||
19 | Number of rows actually updated by UPDATE statement (UPDATE ROW) | |||
20 | SQL statement preprocessings count (SET) | |||
21 | OPEN statement executions count (OPEN) | |||
22 | FETCH statement executions count (FETCH) | |||
23 | CLOSE statement executions count (CLOSE) | |||
24 | DESCRIBE statement executions count (DESCRIBE) | |||
25 | SELECT statement executions count (SELECT) | |||
26 | INSERT statement executions count (INSERT) | |||
27 | UPDATE statement executions count (UPDATE) | |||
28 | DELETE statement executions count (DELETE) | |||
29 | LOCK statement executions count (LOCK) | ![]() | ||
30 | CREATE TABLE executions count (CREATE TABLE) | |||
31 | ALTER TABLE executions count (ALTER TABLE) | |||
32 | DROP TABLE executions count (DROP TABLE) | |||
33 | CREATE INDEX executions count (CREATE INDEX) | |||
34 | DROP INDEX executions count (DROP INDEX) | |||
35 | COMMENT TABLE executions count (COMMENT TABLE) | |||
36 | COMMENT COLUMN executions count (COMMENT COLUMN) | |||
37 | CREATE SCHEMA executions count (CREATE SCHEMA) | |||
38 | DROP SCHEMA executions count (DROP SCHEMA) | |||
39 | GRANT RDAREA executions count (GRANT RDAREA) | |||
40 | GRANT SCHEMA executions count (GRANT SCHEMA) | |||
41 | GRANT access-privilege executions count (GRANT ACCESS) | |||
42 | GRANT CONNECT executions count (GRANT CONNECT) | |||
43 | GRANT DBA executions count (GRANT DBA) | |||
44 | REVOKE RDAREA executions count (REVOKE RDAREA) | |||
45 | REVOKE SCHEMA executions count (REVOKE SCHEMA) | ![]() | ||
46 | REVOKE access-privilege executions count (REVOKE ACCESS) | |||
47 | REVOKE CONNECT executions count (REVOKE CONNECT) | |||
48 | REVOKE DBA executions count (REVOKE DBA) | |||
49 | CREATE VIEW executions count (CREATE VIEW) | |||
50 | DROP VIEW executions count (DROP VIEW) | |||
51 | System-specific information (UNUSED) | |||
52 | System-specific information (UNUSED) | |||
53 | PURGE TABLE statement executions count (PURGE TABLE) | |||
54 | Other executions count (MISC) | |||
55 | Number of acquisition requests for stored procedure objects (SQLOBJ GET REQ) | |||
56 | SQL object buffer hits count for stored procedure objects (SQLOBJ CACHE HIT) | |||
57 | CREATE PROCEDURE executions count (CREATE PROCEDURE) | |||
58 | DROP PROCEDURE executions count (DROP PROCEDURE) | |||
59 | CALL statement executions count (CALL) | |||
60 | DESCRIBE statement (INPUT) executions count (DESCRIBE INPUT) | |||
61 | ALTER PROCEDURE executions count (ALTER PROCEDURE) | |||
62 | UAP or transaction execution time (UAP EXEC TIME (MS)) | In milliseconds (includes a value in seconds; a value less than a millisecond is rounded) | ||
63 | Service name (SERVICE NAME) | Character | 31 | ![]() |
64 | Lock release wait time (LOCK TIME)1 | Numeric | 10 | In seconds |
65 | No. 64 in microseconds (LOCK TIME (MICRO))1 | 6 | Value in seconds is not included. | |
66 | Output timing for the corresponding row (OUTPUT TIMING) | Character | 1 | C: In UAP executions T: In transactions |
67 | Front-end server name (FES NAME) | 8 | ![]() | |
68 | Connect number (CONNECT NO) | Numeric | 10 | Sequence number assigned to each connection within one front-end server |
69 | Font-end server process ID (FES PROCESS ID) | ![]() | ||
70 | CPU time (CPU TIME)4 | In milliseconds | ||
71 | Single server or front-end server processing time (SERV EXEC TIME)2 | In seconds | ||
72 | No. 71 in microseconds (SERV EXEC TIME (MICRO)) | 6 | Value in seconds is not included. | |
73 | Total input/output time (IO TIME)5 | 10 | In seconds | |
74 | No. 73 in microseconds (IO TIME (MICRO))5 | 6 | Value in seconds is not included. | |
75 | Maximum input/output time (MAX IO TIME)3 | 10 | In seconds | |
76 | No. 75 in microseconds (MAX IO TIME (MICRO)) | 6 | Value in seconds is not included. | |
77 | Minimum input/output time (MIN IO TIME)3 | 10 | In seconds | |
78 | No. 77 in microseconds (MIN IO TIME (MICRO)) | 6 | Value in seconds is not included. | |
79 | Reference operations count on data page, index page, or directory page (DID RF CNT)5 | 10 | ![]() | |
80 | Update operations count on data page, index page, or directory page (DID UPD CNT)5 | ![]() | ||
81 | Buffer hits count for data page, index page, or directory page (DID HIT CNT)5 | ![]() | ||
82 | Buffer hit ratio for data page, index page, or directory page (DID BUF HIT RATIO) | 3 | Percentage | |
83 | Real READs count for data page, index page, or directory page (DID READ CNT)5 | 10 | ![]() | |
84 | Real WRITEs count for data page, index page, or directory page (DID WRITE CNT)5 | ![]() | ||
85 | Reference operations count on LOB column data page (LOB RF CNT)5 | ![]() | ||
86 | Update operations count on LOB column data page (LOB UPD CNT)5 | ![]() | ||
87 | Reference buffer hits count for LOB column data page (LOB RF HIT CNT)5 | ![]() | ||
88 | Update buffer hits count for LOB column data page (LOB UPD HIT CNT)5 | ![]() | ||
89 | Reference buffer hits count for LOB column data page (LOB RF BUF HIT RATIO) | 3 | Percentage | |
90 | Update buffer hits count for LOB column data page (LOB UPD BUF HIT RATIO) | |||
91 | Real READs count for LOB column database (LOB READ CNT)5 | 10 | ![]() | |
92 | Real WRITEs count for LOB column database (LOB WRITE CNT)5 | ![]() | ||
93 | Global buffer flashes count (BUF FLASH CNT)5 | ![]() | ||
94 | READ waits count for global buffer (BUF READ WAIT CNT)5 | ![]() | ||
95 | WRITE waits count for global buffer (BUF WRITE WAIT CNT)5 | ![]() | ||
96 | Global buffer lock release waits count (BUF LOCK WAIT CNT)5 | ![]() | ||
97 | Maximum number of work table files (MAX WKFILE NUM) | ![]() | ||
98 | Maximum number of work table file extensions (MAX WKFILE EXP CNT) | ![]() | ||
99 | Maximum size of work table file (MAX WKFILE VOLUME) | In MB | ||
100 | Work table file READs count (WKFILE READ CNT)5 | ![]() | ||
101 | Work table file WRITEs count (WKFILE WRITE CNT)5 | ![]() | ||
102 | Number of forced outputs on work table buffer (WKFILE BUF FORCED OUT CNT)5 | ![]() | ||
103 | Maximum hash table size in batch processing mode (MAX WHOLE HASH TABLE SIZE) | In KB | ||
104 | Maximum level-1 bucket size (MAX BUCKET SIZE LEVEL 1) | |||
105 | Maximum level-2 bucket size (MAX BUCKET SIZE LEVEL 2) | |||
106 | Maximum level-3 bucket size (MAX BUCKET SIZE LEVEL 3) | |||
107 | Number of times page search for reutilization of free space failed (REUSE FAILURE CNT)5 | ![]() | ||
108 | Number of times the mode changed from new page allocate to free page reuse on a table with SEGMENT REUSE specified (REUSE CHANGE CNT)5 | |||
109 | Number of times data pages and index pages were referenced using the local buffer (LOCAL BUF RF CNT)5 | |||
110 | Number of times data pages and index pages were updated using the local buffer (LOCAL BUF UPD CNT)5 | |||
111 | Local buffer hit count for data pages and index pages (LOCAL BUF HIT CNT)5 | |||
112 | Number of real READs on data pages and index pages using the local buffer (LOCAL BUF READ CNT)5 | |||
113 | Number of real WRITEs on data pages and index pages using the local buffer (LOCAL BUF WRITE CNT)5 | |||
114 | Local buffer flush count (LOCAL BUF FLUSH CNT)5 | |||
115 | Number of asynchronous READ requests (AR REQ CNT)5 | |||
116 | Number of times synchronization waits occurred during asynchronous READ (AR SYNC WAIT CNT)5 | |||
117 | Total synchronization wait time during asynchronous READ (AR SYNC WAIT TIME TOTAL)5 | In seconds | ||
118 | No. 177 in microseconds (AR SYNC WAIT TIME TOTAL (MICRO))5 | 6 | Value in seconds is not included. | |
119 | Average synchronization wait time during asynchronous READ (AR SYNC WAIT TIME AVERAGE) | 10 | In seconds | |
120 | No. 119 in microseconds (AR SYNC WAIT TIME AVERAGE (MICRO)) | 6 | Value in seconds is not included. | |
121 | Total synchronous input/output time during asynchronous READ (AR SYNC IO TIME TOTAL)5 | 10 | In seconds | |
122 | No. 121 in microseconds (AR SYNC IO TIME TOTAL (MICRO))5 | 6 | Value in seconds is not included. | |
123 | Average synchronous input/output time during asynchronous READ (AR SYNC IO TIME AVERAGE) | 10 | In seconds | |
124 | No. 123 in microseconds (AR SYNC IO TIME AVERAGE (MICRO)) | 6 | Value in seconds is not included. | |
125 | Maximum comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (MAX HASH COMP COUNT)3 | 10 | ![]() | |
126 | Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)5 | 10 | ![]() | |
127 | Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)5 | 10 | ![]() |
1 For a HiRDB/Parallel Server, this is the total lock release wait time (including parallel processing) resulting in the transaction.
2 If the pdstbegin command is executed while being connected, or transaction processing is underway, statistical information is collected for the next connection or transaction, not the current connection or transaction.
3 For a HiRDB/Parallel Server, the value is for all back-end servers.
4 This is the total CPU time for all servers in the transaction.
5 If the information is output for each transaction, this is the cumulative CONNECT value.
Table 14-9 Record format of a DAT-format file (SQL statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | SQL execution start time (START) | 14 | Format: MM/DD/hh:mm:ss | |
4 | No. 3 in microseconds (START (MICRO)) | Numeric | 6 | Value in seconds is not included. |
5 | SQL execution termination time (END) | Character | 14 | Format: MM/DD/hh:mm:ss |
6 | No. 5 in microseconds (END (MICRO)) | Numeric | 6 | Value in seconds is not included. |
7 | Length of created SQL object (PDATA) | 10 | In bytes | |
8 | Number of back-end servers that sent SQL object (BES COUNT) | ![]() | ||
9 | SQL execution time (SQL EXEC TIME (MICRO)) | In microseconds (includes the value in seconds) | ||
10 | Number of rows retrieved (FETCH ROW) | ![]() | ||
11 | Number of rows inserted (INSERT ROW) | |||
12 | Number of rows updated (UPDATE ROW) | |||
13 | Number of rows deleted (DELETE ROW) | |||
14 | Number of rows created in work table (CREATE LIST) | |||
15 | Number of rows deleted from work table (DROP LIST) | |||
16 | SQL execution time (SQL EXEC TIME (SEC)) | In seconds (value is rounded off) | ||
17 | Service name (SERVICE NAME) | Character | 31 | ![]() |
18 | Front-end server name (FES NAME) | 8 | ||
19 | Connection number (CONNECT NO) | Numeric | 10 | Serial number assigned to each connection in one front-end server. |
20 | SQL counter (SQL COUNTER) | ![]() | ||
21 | Front-end server process ID (FES PROCESS ID) | |||
22 | Operation code (OPERATION CODE)1 | Character | 4 | ![]() |
23 | Section number (SECTION NO) | Numeric | 5 | |
24 | SQL type code (SQL TYPE CODE)2 | Character | 4 | |
25 | SQL code (SQLCODE) | Numeric | 10 | |
26 | Server name (SERVER NAME) | Character | 8 | |
27 | Number of times processing requests were issued to the foreign server (FOREIGN REQUEST COUNT) | Numeric | 10 | ![]() |
28 | Foreign server processing time (FOREIGN EXEC TIME) | In seconds | ||
29 | No. 28 in microseconds (FOREIGN EXEC TIME(MICRO)) | In microseconds (includes the value in seconds) | ||
30 | Number of rows retrieved on the foreign server (FOREIGN FETCH ROW) | ![]() | ||
31 | Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT) | Numeric | 10 | ![]() |
32 | Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT) | Numeric | 10 | ![]() |
33 | Number of rows inserted in the foreign server (FOREIGN INSERT ROW) | Numeric | 10 | ![]() |
34 | Number of rows updated on the foreign server (FOREIGN UPDATE ROW) | Numeric | 10 | ![]() |
35 | Number of rows deleted on the foreign server (FOREIGN DELETE ROW) | Numeric | 10 | ![]() |
1 See Table 14-10 for the operation codes.
2 See Table 14-11 for the SQL type codes.
Table 14-10 Operation codes
Operation code | Corresponding SQL statements |
---|---|
AUI2 | DELETE statement (static SQL), INSERT statement (static SQL), UPDATE statement (static SQL), LOCK statement (static SQL), PURGE TABLE statement (static SQL), single-row SELECT statement (static SQL), FREE LOCATOR statement (static SQL) |
AUI3 | Assignment statement (static SQL) |
AUX | EXECUTE statement |
AUXI | EXECUTE IMMEDIATE statement and all definition SQL statements |
AUXO | EXECUTE statement (INTO specified) |
CALL | CALL statement |
CLOS | CLOSE statement |
CMIT | COMMIT statement |
CNCT | CONNECT statement |
CPRP | Commit Prepare* |
DESC | DESCRIBE statement (OUTPUT specified) |
DEST | DESCRIBE TYPE statement |
DISC | DISCONNECT statement, COMMIT statement (RELEASE specified) |
DISR | ROLLBACK statement (RELEASE specified) |
DIST | Disconnect + Tran Check* |
DSCM | Used by system |
DSPR | Used by system |
DSRL | Used by system |
FETC | FETCH statement |
GETD | GET DIAGNOSTICS |
HVAR | DESCRIBE statement (INPUT specified) |
JARI | INSTALL JAR |
JARR | REPLACE JAR |
JARU | REMOVE JAR |
OPEN | OPEN statement (dynamic SQL) |
OPN2 | OPEN statement (static SQL) |
OPNR | OPEN statement (dynamic SQL (multiple cursors)) |
RENV | Used by system |
RNCN | CONNECT statement (TO specified) |
RNDS | DISCONNECT statement (TO specified) |
RNSC | SET CONNECTION statement |
ROLL | ROLLBACK statement |
RSDC | DESCRIBE statement (OUTPUT, RESULT SET specified) |
RSFT | FETCH statement (RESULT SET specified) |
RSCL | CLOSE statement (RESULT SET specified) |
SAUH | SET SESSION AUTHORIZATION statement |
SET | PREPARE statement |
SINF | Used by system |
SOPT | Used by system |
SVLS | Used by system |
THRE | Used by system |
THSU | Used by system |
TRCK | Used by system |
TRC2 | Used by system |
TRST | Used by system |
TSCM | Used by system |
TSRL | Transfer Rollback* |
TSPR | Transfer Prepare* |
ALCR | ALLOCATE CURSOR statement |
DSET | DEALLOCATE PREPARE statement |
* Output only when the XA interface is used.
Table 14-11 SQL type codes
No. | SQL statement | SQL type code (hexadecimal) |
---|---|---|
1 | CREATE TABLE | 1038 |
2 | DROP TABLE | 103C |
3 | ALTER TABLE | 1040 |
4 | CREATE INDEX | 1044 |
5 | DROP INDEX | 1048 |
6 | COMMENT ON TABLE | 104C |
7 | COMMENT ON COLUMN | 1050 |
8 | CREATE SCHEMA | 1054 |
9 | DROP SCHEMA | 1058 |
10 | GRANT RDAREA | 105C |
11 | GRANT SCHEMA | 1060 |
12 | GRANT ACCESS | 1064 |
13 | REVOKE RDAREA | 1068 |
14 | REVOKE SCHEMA | 106C |
15 | REVOKE ACCESS | 1070 |
16 | CREATE VIEW | 1074 |
17 | DROP VIEW | 1078 |
18 | GRANT CONNECT | 1098 |
19 | GRANT DBA | 109C |
20 | REVOKE CONNECT | 10A0 |
21 | REVOKE DBA | 10A4 |
22 | CREATE ALIAS | 10A8 |
23 | DROP ALIAS | 10AC |
24 | CREATE PROCEDURE | 10B0 |
25 | DROP PROCEDURE | 10B4 |
26 | ALTER PROCEDURE | 10B8 |
27 | CREATE TYPE | 10C0 |
28 | DROP DATA TYPE | 10C4 |
29 | CREATE FUNCTION | 10C8 |
30 | DROP FUNCTION | 10CC |
31 | ALTER ROUTINE | 10E8 |
32 | LOCK statement | 2134 |
33 | SELECT statement | 4000, 4900, 4100, 4A04, 4204 |
34 | INSERT statement | 4108 |
35 | UPDATE statement | 4114 |
36 | DELETE statement | 411C |
37 | ASSIGN LIST statement | 4224, 4324 |
38 | DROP LIST statement | 422C |
39 | PURGE TABLE statement | 4184 |
40 | CALL PROCEDURE | 40BC |
41 | GET DIAGNOSTICS | 40C0 |
42 | Assignment statement | 40C4 |
43 | FREE LOCATOR statement | 40C8 |
Table 14-12 Record format of a DAT-format file (global buffer pool statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | Server name (SERVER) | 8 | ||
3 | Global buffer name (BUFFER NAME) | 16 | ||
4 | Statistics log acquisition time (LOG GET TIME) | 14 | Format: MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified | |
5 | Number of buffer sectors in global buffer pool (BUFFER COUNT) | Numeric | 10 | ![]() |
6 | Number of synchronization point dump pages (SYNC POINT) | |||
7 | Maximum number of concurrently requested buffer sectors (BUFFER MAX) | |||
8 | Update GETs count (UPDATE GET) | |||
9 | Update buffer hits count (UPDATE HIT) | |||
10 | Update buffer hit rate (UPDATE HIT RATIO) | 3 | Percentage | |
11 | Update buffer flushes count (UPDATE FLUSH) | 10 | ![]() | |
12 | Reference GETs count (REF GET) | |||
13 | Reference buffer hits count (REF HIT) | |||
14 | Reference buffer hit rate (REF HIT RATIO) | 3 | Percentage | |
15 | Reference buffer flushes count (REF FLUSH) | 10 | ![]() | |
16 | Real READs count (READ) | |||
17 | Input waits count (WAIT READ) | |||
18 | Real WRITEs count (WRITE) | |||
19 | Output waits count (WAIT WRITE) | |||
20 | Buffer lock release waits count (WAIT EXCLUSIVE) | |||
21 | Buffer shortages count (BUFFER INSUFFICIENCY) | |||
22 | Prefetch input pages count (PRRED) | |||
23 | Prefetch hit pages count (PRHIT) | |||
24 | Prefetch hit ratio (PRHIT RATIO) | 3 | Percentage | |
25 | Prefetch execution resources shortage count (PR INSUFFICIENCY) | 10 | ![]() | |
26 | Global buffer hit ratio (BUFHIT RATIO) | 3 | Percentage | |
27 | Current reference buffers count (CUR REF BUFNUM) | 10 | ![]() | |
28 | Current update buffers count (CUR UPDATE BUFNUM) | |||
29 | Deferred write trigger update buffers count (TRG UPDATE BUFNUM) | |||
30 | Synchronization points count (SYNC COUNT) | |||
31 | Number of prefetch READ requests (PR READ REQ CNT) | |||
32 | Number of READ requests for LOB global buffer (LOB READ REQ CNT) | |||
33 | Number of WRITE requests for LOB global buffer (LOB WRITE REQ CNT) | |||
34 | Batch input pages count for LOB global buffer (LOB BLK READ PGNUM) | |||
35 | Batch output pages count for LOB global buffer (LOB BLK WRITE PGNUM) | |||
36 | System-specific information (CACHE BUFFER INSUFFICIENCY) | |||
37 | System-specific information (CACHE BUFFER FLUSH MAX) | |||
38 | System-specific information (CACHE BUFFER FLUSH AVERAGE) | |||
39 | System-specific information (LOCK WAIT CNT) | Exponent representation | ||
40 | Percentage of lock contention-release wait (LOCK WAIT RATIO) | 5 | % (up to 1 decimal place) | |
41 | System-specific information (SLEEP EXEC AVERAGE) | 10 | Exponent representation | |
42 | Percentage rate of spin loop (SPIN EXEC RATIO) | 5 | % (up to 1 decimal place) | |
43 | Average spin loop count (SPIN EXEC AVERAGE) | 10 | Exponent representation | |
44 | Buffer pool lock exclusive time during synchronization point processing | 10 | ![]() | |
45 | No. 44 in microseconds | 6 | Value in seconds is not included | |
46 | Number of buffers processed within buffer pool lock exclusive time during synchronization point processing | 10 | ![]() | |
47 | Take-over count of database write processing by reference request hit during synchronization point processing | |||
48 | Take-over count of database write processing by update request hit during synchronization point processing |
Table 14-13 Record format of a DAT-format file (statistical information on HiRDB files for database manipulation)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | Server name (SERVER) | 8 | ||
3 | HiRDB file name (FILE NAME) | 167 | ||
4 | RDAREA name (RDAREA NAME) | 30 | ||
5 | Statistics log acquisition time (LOG GET TIME) | 14 | Format: MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified | |
6 | Synchronous READs count (SYNC READ) | Numeric | 10 | ![]() |
7 | Synchronous WRITEs count (SYNC WRITE) | |||
8 | System-specific information (AIO READ) | |||
9 | Asynchronous WRITEs count (AIO WRITE) | |||
10 | System-specific information (LIST IO) | |||
11 | Opens count (OPEN) | |||
12 | Closes count (CLOSE) | |||
13 | I/O errors count (IO ERROR) |
Table 14-14 Record format of a DAT-format file (deferred write processing statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | Server name (SERVER) | 8 | ||
3 | Log acquisition time (LOG GET TIME) | 11 | Format: MM/DD/hh:mm:ss | |
4 | Cause (CAUSE) | 1 | Trigger: T Pre-sync: P Synchronization point: S Database synchronization point: D RDAREA synchronization point: R | |
5 | Pre-sync completion status (STATUS)* | Pre-sync completed: P Complete and terminated: E | ||
6 | I/O parallel level (PARALLEL) | Numeric | 10 | ![]() |
7 | Total number of pages output (OUT PAGE) | Total number of pages output by deferred write processing for each cause | ||
8 | WRITE count (DWEXEC) | ![]() | ||
9 | Minimum unit value of WRITE (DWMIN) | In seconds (rounded off) | ||
10 | No. 9 in microseconds (DWMINM) | 6 | Value in seconds is not included. | |
11 | Maximum unit value of WRITE (DWMAX) | 10 | In seconds (rounded off) | |
12 | No. 11 in microseconds (DWMAXM) | 6 | Value in seconds is not included. | |
13 | Average unit value of WRITE (DWAVG) | 10 | In seconds (rounded off) | |
14 | No. 13 in microseconds (DWAVGM) | 6 | Value in seconds is not included. | |
15 | Total WRITE time (DWSUM) | 10 | In seconds (rounded off) | |
16 | No. 15 in microseconds (DWSUMM) | 6 | Value in seconds is not included. | |
17 | Parallel WRITE time (DWPARA) | 10 | In seconds (rounded off) | |
18 | No. 17 in microseconds (DWPARAM) | 6 | Value in seconds is not included. | |
19 | Execution time (DWTOTAL) | 10 | In seconds (rounded off) | |
20 | No. 17 in microseconds (DWTOTALM) | 6 | Value in seconds is not included. | |
21 | System-specific information (DWLSNGET) | 10 | In seconds (rounded off) | |
22 | System-specific information (DWLSNGETM) | 6 | Value in seconds is not included. | |
23 | System-specific information (DWSYNCLIST) | 10 | In seconds (rounded off) | |
24 | System-specific information (DWSYNCLISTM) | 6 | Value in seconds is not included. | |
25 | System-specific information (DWSEMOP) | 10 | In seconds (rounded off) | |
26 | System-specific information (DWSEMOPM) | 6 | Value in seconds is not included. |
* This information is displayed when the cause is set to P (pre-sync); otherwise, the null value is displayed.
Table 14-15 Record format of a DAT-format file (SQL static optimization information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Service name (SERVICE NAME) | 31 | ||
4 | Front-end server name (FES NAME) | 8 | ||
5 | Connection number (CONNECT NO) | Numeric | 10 | Serial number assigned to each connection in one front-end server |
6 | SQL counter (SQL COUNTER) | ![]() | ||
7 | Front-end server process ID (FES PROCESS ID) | |||
8 | Operation code (OPERATION CODE) | Character | 4 | For the operation codes, see Table 14-10. |
9 | Section number (SECTION NO) | Numeric | 5 | ![]() |
10 | SQL type code (SQL TYPE CODE) | Character | 4 | For SQL type codes, see Table 14-11. |
11 | Server name (SERVER NAME) | 8 | ![]() | |
12 | Syntax analysis start time (PARSE START(S)) | 14 | Format: MM/DD/hh:mm:ss | |
13 | No. 12 in microseconds (PARSE START (MICRO)) | Numeric | 6 | Value in seconds is not included. |
14 | Syntax analysis termination time (PARSE END(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
15 | No. 14 in microseconds (PARSE END (MICRO)) | Numeric | 6 | Value in seconds is not included. |
16 | Syntax analysis execution time (PARSE EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
17 | No. 16 in microseconds (PARSE EXEC TIME(MICRO)) | Value in seconds is included. | ||
18 | Semantic analysis start time (SEMAN START(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
19 | No. 18 in microseconds (SEMAN START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
20 | Semantic analysis termination time (SEMAN END(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
21 | No. 20 in microseconds (SEMAN END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
22 | Semantic analysis execution time (SEMAN EXEC TIME(SEC)) | 10 | In seconds (Value is rounded off.) | |
23 | No. 22 in microseconds (SEMAN EXEC TIME(MICRO)) | Value in seconds is included. | ||
24 | Optimization start time (OPT START(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
25 | No. 24 in microseconds (OPT START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
26 | Optimization termination time (OPT END(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
27 | No. 26 in microseconds (OPT END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
28 | Optimization execution time (OPT EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
29 | No. 28 in microseconds (OPT EXEC TIME(MICRO)) | Value in seconds is included. | ||
30 | SQL object generation start time (SQLOBJ GEN START(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
31 | No. 30 in microseconds (SQLOBJ GEN START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
32 | SQL object generation termination time (SQLOBJ GEN END(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
33 | No. 32 in microseconds (SQLOBJ GEN END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
34 | SQL object generation execution time (SQLOBJ GEN EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
35 | No. 34 in microseconds (SQLOBJ GEN EXEC TIME(MICRO)) | Value in seconds is included. | ||
36 | SQL object registration start time (SQLOBJ ENT START(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
37 | No. 36 in microseconds (SQLOBJ ENT START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
38 | SQL object registration termination time (SQLOBJ ENT END(S)) | Character | 14 | Format: MM/DD/hh:mm:ss |
39 | No. 38 in microseconds (SQLOBJ ENT END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
40 | SQL object registration execution time (SQLOBJ ENT EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
41 | No. 40 in microseconds (SQLOBJ ENT EXEC TIME(MICRO)) | Value in seconds is included. |
Table 14-16 Record format of a DAT-format file (SQL dynamic optimization information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Service name (SERVICE NAME) | 31 | ||
4 | Front-end server name (FES NAME) | 8 | ||
5 | Connection number (CONNECT NO) | Numeric | 10 | Serial number assigned to each connection in one front-end server |
6 | SQL counter (SQL COUNTER) | ![]() | ||
7 | Front-end server process ID (FES PROCESS ID) | |||
8 | Operation code (OPERATION CODE) | Character | 4 | For operation codes, see Table 14-10. |
9 | Section number (SECTION NO) | Numeric | 5 | ![]() |
10 | SQL type code (SQL TYPE CODE) | Character | 4 | For SQL type codes, see Table 14-11. |
11 | Server name (SERVER NAME) | 8 | ![]() | |
12 | Dynamic optimization start time (DYNAMIC START) | 14 | Format: MM/DD/hh:mm:ss | |
13 | No. 12 in microseconds (START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
14 | Dynamic optimization termination time (DYNAMIC END) | Character | 14 | Format: MM/DD/hh:mm:ss |
15 | No. 14 in microseconds (END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
16 | Dynamic optimization execution time (DYNAMIC EXEC TIME(SEC)) | 10 | In seconds | |
17 | No. 16 in microseconds (DYNAMIC EXEC TIME(MICRO)) | Value in seconds is included. | ||
18 | System-specific information (SUB SECTION COUNT) | 5 | ![]() | |
19 | System-specific information (SUB SECTION NO) | |||
20 | SQL object type (SQLOBJ KIND) | Character | 1 | F: Front end H: Foreign table access J: Sort/join T: Base table scan |
21 | Requested servers count (REQ SERVER) | Numeric | 10 | ![]() |
22 | Allocated servers count (ALC SERVER) | |||
23 | Allocated server name (ALC SERVER NAME) | Character | 8 | |
24 | RDAREA ID (RDAREA ID) | Numeric | 10 |
Table 14-17 Record format of a DAT-format file (SQL object execution information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Service name (SERVICE NAME) | 31 | ||
4 | Front-end server name (FES NAME) | 8 | ||
5 | Connection number (CONNECT NO) | Numeric | 10 | Serial number assigned to each connection in one front-end server. |
6 | SQL counter (SQL COUNTER) | ![]() | ||
7 | Front-end server process ID (FES PROCESS ID) | |||
8 | Server name (SERVER NAME) | Character | 8 | |
9 | Thread number (THREAD NO) | Numeric | 5 | |
10 | Operation code (OPERATION CODE) | Character | 4 | For operation codes, see Table 14-10. |
11 | Section number (SECTION NO) | Numeric | 5 | ![]() |
12 | System-specific information (SUB SECTION NO) | |||
13 | SQL code (SQLCODE) | 10 | ||
14 | SQL object execution start time (SQLOBJ START) | Character | 14 | Format: MM/DD/hh:mm:ss |
15 | No. 14 in microseconds (START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
16 | SQL object execution termination time (SQLOBJ END) | Character | 14 | Format: MM/DD/hh:mm:ss |
17 | No. 16 in microseconds (END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
18 | SQL object execution time (SQLOBJ EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
19 | No. 18 in microseconds (SQLOBJ EXEC TIME(MICRO)) | Value in seconds is included. | ||
20 | Number of rows retrieved for SQL object (FETCH ROW) | ![]() | ||
21 | Number of rows inserted for SQL object (INSERT ROW) | |||
22 | Number of rows updated for SQL object (UPDATE ROW) | |||
23 | Number of rows deleted for SQL object (DELETE ROW) | |||
24 | Number of work table rows created (CREATE LIST) | |||
25 | Number of work table rows deleted (DROP LIST) | |||
26 | Send operations count (SEND) | |||
27 | Length of send data (SEND DATA SIZE) | |||
28 | Receive operations count (RECEIVE) | |||
29 | Length of receive data (RECEIVE DATA SIZE) | |||
30 | Number of times work tables were created (CREATE TMP LIST) | |||
31 | Number of times work tables were deleted (DROP TMP LIST) | |||
32 | HiRDB file output operations count (IOS OUTPUT) | |||
33 | Buffer input operations count (BUFFER INPUT) | |||
34 | SELECT APSL number (SEL APSL NO) | |||
35 | SQL object type (SQLOBJ KIND) | Character | 1 | F: Front end J: Sort/join T: Base table scan |
36 | Number of times processing requests were issued to foreign server (FOREIGN REQUEST COUNT) | Numeric | 10 | ![]() |
37 | Foreign server processing time (FOREIGN EXEC TIME) | In seconds | ||
38 | No. 37 in microseconds (FOREIGN EXEC TIME(MICRO)) | In microseconds (includes the value in seconds) | ||
39 | Number of rows retrieved on the foreign server (FOREIGN FETCH ROW) | ![]() | ||
40 | Number of rows inserted in the foreign server (FOREIGN INSERT ROW) | ![]() | ||
41 | Number of rows updated on the foreign server (FOREIGN UPDATE ROW) | ![]() | ||
42 | Number of rows deleted on the foreign server (FOREIGN DELETE ROW) | ![]() |
Table 14-18 Record format of a DAT-format file (SQL object transfer statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Front-end server name (FES NAME) | 8 | ||
4 | Connection number (CONNECT NO) | Numeric | 10 | |
5 | Front-end server process ID (FES PROCESS ID) | |||
6 | Server name (SERVER) | Character | 8 | ![]() |
7 | System-specific information (SERVICE KIND) | 1 | ![]() | |
8 | Operation code (OPERATION CODE) | 4 | For operation codes, see Table 14-10. | |
9 | Section number (SECTION NO) | Numeric | 5 | ![]() |
10 | System-specific information (SUB SECTION NO) | |||
11 | SQL type code (SQL TYPE CODE) | Character | 4 | For SQL type codes, see Table 14-11. |
12 | SQL code (SQLCODE) | Numeric | 10 | ![]() |
13 | Service start time (SERVICE START) | Character | 14 | Format: MM/DD/hh:mm:ss |
14 | No. 13 in microseconds (SERVICE START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
15 | Service termination time (SERVICE END) | Character | 14 | Format: MM/DD/hh:mm:ss |
16 | No. 15 in microseconds (SERVICE END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
17 | Service execution time (SERVICE EXEC TIME(SEC)) | 10 | In seconds (value is rounded off) | |
18 | No. 17 in microseconds (SERVICE EXEC TIME(MICRO)) | Value in seconds is included. | ||
19 | SQL object transfer start time (TRANSFER START) | Character | 14 | Format: MM/DD/hh:mm:ss |
20 | No. 19 in microseconds (TRANSFER START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
21 | SQL object transfer end time (TRANSFER END) | Character | 14 | Format: MM/DD/hh:mm:ss |
22 | No. 21 in microseconds (TRANSFER END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
23 | SQL object transfer time (TRANSFER TIME(SEC)) | 10 | In seconds (value is rounded off) | |
24 | No. 23 in microseconds (TRANSFER TIME(MICRO)) | Value in seconds is included. | ||
25 | SQL object transfer size (TRANSFER SIZE) | 10 | In bytes |
Table 14-19 Record format of a DAT-format file (SQL statement statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Module name (MODULE NAME) | |||
4 | Service name (SERVICE NAME) | 31 | ||
5 | Front-end server name (FES NAME) | 8 | ||
6 | Connection number (CONNECT NO) | Numeric | 10 | Serial number assigned to each connection in one front-end server |
7 | SQL counter (SQL COUNTER) | ![]() | ||
8 | Front-end server process ID (FES PROCESS ID) | |||
9 | Operation code (OPERATION CODE) | Character | 4 | For operation codes, see Table 14-10. |
10 | Section number (SECTION NO) | Numeric | 5 | ![]() |
11 | SQL length (SQL LENGTH) | 10 | ||
12 | SQL statement (SQL STRING) | Character | 2M | An SQL statement is output a maximum of 30 KB from the beginning. |
Table 14-20 Record format of a DAT-format file (CONNECT/DISCONNECT statistical information)
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | |||
3 | Connect/disconnect time (CONNECT/DISCONNECT TIME) | 14 | Format: MM/DD/hh:mm:ss | |
4 | No. 3 in microseconds (CONNECT/DISCONNECT TIME(MICRO)) | Numeric | 6 | Value in seconds is not included. |
5 | Front-end server process ID (FES PROCESS ID) | 10 | ![]() | |
6 | SQL code (SQLCODE) | |||
7 | Connect/disconnect status (CONNECT/DISCONNECT STATUS) | Character | 1 | C: CONNECT D: DISCONNECT |
8 | Client group ID (CLT GROUP) | 1: WS client 2: PC client 3: Mainframe-based client 8: X/Open XA interface 9: Distributed client 0: Utility #: Other blank: None (space: 0 ![]() | ||
9 | Privilege information (PRIVILEGE) | C: CONNECT privilege D: DBA privilege blank: None (space: 0 ![]() | ||
10 | Connect/disconnect type (CONNECT/DISCONNECT KIND) | N: Normal (CONNECT/DISCONNECT) S: set session authorization I: Internal disconnect T: Transaction resolution (OLTP only) | ||
11 | Authorization identifier (USER NAME) | 30 | ![]() | |
12 | Password (PASSWORD) | Upon KFPA11560-E error (invalid password) | ||
13 | CLT IP address (CLT IP ADDRESS) | 15 | Format: XXX.XXX.XXX.XXX |
Table 14-21 Foreign server operation statistical information
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | Server name (SERVER NAME) | 8 | ||
3 | Foreign server ID (FOREIGN SERVER ID) | Numeric | 10 | ![]() |
4 | Foreign server name (FOREIGN SERVER) | Character | 30 | |
5 | DBMS type of the foreign server (DBMS KIND) | 1 | P: HiRDB R: XDM/RD O: Oracle I: DB2 | |
6 | Number of times connection was established (CONNECT COUNT) | Numeric | 10 | ![]() |
7 | Number of connection errors (CONNECT ERROR COUNT) | |||
8 | Number of connection errors due to number of licenses exceeded (LICENSE OVER COUNT) | |||
9 | Commits count (COMMIT COUNT) | |||
10 | Rollbacks count (ROLLBACK COUNT) | |||
11 | Number of rows retrieved (FETCH ROW) | |||
12 | Information used by the system (DBA CONNECT COUNT) | |||
13 | Information used by the system (DBA DISCONNECT COUNT) | |||
14 | Information used by the system (DBA PREPARE COUNT) | |||
15 | Information used by the system (DBA OPEN COUNT) | |||
16 | Information used by the system (DBA FETCH COUNT) | |||
17 | Information used by the system (DBA CLOSE COUNT) | |||
18 | Information used by the system (DBA EXECUTEIMD COUNT) | |||
19 | Information used by the system (DBA EXECUTE COUNT) | |||
20 | Information used by the system (DBA LOCKTABLE COUNT) | |||
21 | Foreign server processing time (FOREIGN EXEC TIME) | In seconds | ||
22 | No. 21 in microseconds (FOREIGN EXEC TIME(MICRO)) | In microseconds (includes the value in seconds) | ||
23 | Foreign server processing request count (FOREIGN EXEC COUNT) | ![]() | ||
24 | Number of rows inserted in the foreign server (FOREIGN INSERT ROW) | ![]() | ||
25 | Number of rows updated on the foreign server (FOREIGN UPDATE ROW) | ![]() | ||
26 | Number of rows deleted on the foreign server (FOREIGN DELETE ROW) | ![]() |
Table 14-22 Foreign server utilization statistical information
No. | Field name (title bar) | Attribute | Maximum length | Remarks |
---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | ![]() |
2 | UAP name (UAP NAME) | 30 | ||
3 | Service name (SERVICE NAME) | 31 | ||
4 | Front-end server name (FES NAME) | 8 | ||
5 | Connection number (CONNECT NO) | Numeric | 10 | ![]() |
6 | SQL counter (SQL COUNTER) | |||
7 | Front-end server's process ID (FES PROCESS ID) | |||
8 | Back-end server name (BES NAME) | Character | 8 | ![]() |
9 | Back-end server's process ID (BES PROCESS ID) | Numeric | 10 | ![]() |
10 | Thread number (THREAD ID) | |||
11 | Section number (SECTION NO) | 5 | ||
12 | Information used by the system (SUB SECTION NO) | |||
13 | Foreign server ID (FOREIGN SERVER ID) | 10 | ||
14 | Foreign server name (FOREIGN SERVER) | Character | 30 | ![]() |
15 | SQL type code (SQL TYPE CODE)1 | 4 | ||
16 | Array FETCH count on the foreign server (ARRAY FETCH ROW) | Numeric | 10 | ![]() |
17 | FETCH count on the foreign server (ARRAY FETCH COUNT) | |||
18 | Number of rows retrieved on the foreign server (FETCH ROW) | |||
19 | SQL execution start time at the foreign server (EXEC START) | Character | 14 | Format: MM/DD/hh:mm:ss |
20 | No. 19 in microseconds (START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
21 | SQL execution end time at the foreign server (EXEC END) | Character | 14 | Format: MM/DD/hh:mm:ss |
22 | No. 21 in microseconds (END(MICRO)) | Numeric | 6 | Value in seconds is not included. |
23 | SQL execution time at the foreign server (EXEC TIME(SEC)) | 10 | In seconds | |
24 | No. 23 in microseconds (EXEC TIME(MICRO)) | In microseconds (includes the value in seconds) | ||
25 | Foreign server processing request count (EXEC COUNT) | ![]() | ||
26 | Number of rows inserted in the foreign server (FOREIGN INSERT ROW) | ![]() | ||
27 | Number of rows updated on the foreign server (FOREIGN UPDATE ROW) | ![]() | ||
28 | Number of rows deleted on the foreign server (FOREIGN DELETE ROW) | ![]() |