Table 14-6 Record format of a DAT-format file (system activity statistical information (1)) through Table 14-21 Record format of a DAT-format file (CONNECT/DISCONNECT statistical information) list the record formats of the DAT-format files.
The following notes apply to these tables:
Table 14-6 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) | 19 | Format MM/DD/hh:mm (when -y is omitted) Format YYYY/MM/DD hh:mm:ss (when -y is specified) | |||
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 to 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 to 199 and 252 to 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)#3 | Number of occurrences (FREQ) | Numeric | 10 | Lock information continues with Nos. 268 to 271 and 281 to 285. |
35 | Maximum value (MAX) | In milliseconds | ||||
36 | Minimum value (MIN) | |||||
37 | Average value (AVG) | |||||
38 | Number of lock-release waits (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 | Usage rate of pool partition for locking (USE LOCK TABLE)#1 | 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)#3 | 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)#3 | 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 | Log information continues with Nos. 272 to 280 and 286 to 294. |
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)#2 | Number of occurrences (FREQ) | -- | |||
90 | Write errors count (WRITE ERROR) | Number of occurrences (FREQ) | ||||
91 | Log file swapping time (LOG FILE SWAP TIME)#3 | 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-7 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)#1 | Number of occurrences (FREQ) | Numeric | 10 | Dictionary information is continued to Nos. 200 to 251 and 260 to 267. |
102 | Table definition information buffer hits count (TABLE CACHE HIT)#1 | Number of occurrences (FREQ) | -- | |||
103 | Number of definition information items in table definition information buffer (CASHED TBL-DEF)#1 | 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)#1 | 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)#1 | 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 misses (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)#2 | 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)#2 | 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)#2 | 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)#2 | 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-8 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)#7 | 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)#7 | Number of occurrences (FREQ) | -- | |||
265 | Maximum value (MAX) | In microseconds | ||||
266 | Minimum value (MIN) | |||||
267 | Average value (AVG) | |||||
268 | Lock information (LOCK) | Number of thread-to-thread lock-release waits for the pool partition for locking (REQUEST WAIT QUEUE)#1 | Count (FREQ) | Numeric | 10 | -- |
269 | Maximum value (MAX) | |||||
270 | Minimum value (MIN) | |||||
271 | Average value (AVG) | |||||
272 | Log information (LOG) | File write operation time (FILE WRITE TIME)#2, #7 | Count (FREQ) #2 | Numeric | 10 | -- |
273 | Maximum value (MAX) #2, #3 | In microseconds | ||||
274 | Minimum value (MIN) #2, #3 | |||||
275 | Average value (AVG) #2, #3 | |||||
276 | File read operation time (FILE READ TIME)#7 | Count (FREQ) | -- | |||
277 | Maximum value (MAX) #3 | In microseconds | ||||
278 | Minimum value (MIN)#3 | |||||
279 | Average value (AVG) #3 | |||||
280 | Buffering count (BUFFERING) | Count (FREQ) #4 | -- | |||
281 | Lock information (LOCK) | Number of thread-to-thread lock requests (REQUEST)#1 | Count (FREQ) | -- | ||
282 | Number of thread-to-thread lock-release waits (REQUEST WAIT)#1 | Count (FREQ) | -- | |||
283 | Number of thread-to-thread lock-release wait time (REQUEST WAIT TIME)#1, #5, #6, #7 | Maximum value (MAX) | In microseconds | |||
284 | Minimum value (MIN) | |||||
285 | Average value (AVG) | |||||
286 | Log information (LOG) | Number of requests in the log flush queue (BUF FLUSH WAIT QUEUE) | Count (FREQ) | -- | ||
287 | Maximum value (MAX) | -- | ||||
288 | Minimum value (MIN) | -- | ||||
289 | Average value (AVG) | -- | ||||
290 | Number of log flush requests (BUF FLUSH) | Count (FREQ) | -- | |||
291 | Number of log flush waits (BUF FLUSH WAIT) | Count (FREQ) | -- | |||
292 | Total log flush wait time (BUF FLUSH WAIT TIME)#5, #6, #7 | Maximum value (MAX) | In microseconds | |||
293 | Minimum value (MIN) | |||||
294 | Average value (AVG) |
Table 14-9 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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
4 | No. 3 in microseconds (START (MICRO)) | Numeric | 6 | Value in seconds is not included. |
5 | UAP or transaction execution termination time (END) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | ||
128 | Total number of segments used during execution of SQL statements that use temporary tables (TOTAL SEGMENTS USED FOR TEMP TABLE) | 10 | ||
129 | Total number of times data compression processing was performed (COMPRESSION CNT)#6 | 10 | ||
130 | Total time spent for data compression processing (COMPRESSION TIME)#6 | 10 | In seconds | |
131 | No. 130 in microseconds (COMPRESSION TIME(MICRO))#6 | 6 | Value in seconds is not included. | |
132 | Maximum time spent for data compression processing (MAX COMPRESSION TIME)#6 | 10 | In seconds | |
133 | No. 132 in microseconds (MAX COMPRESSION TIME(MICRO))#6 | 6 | Value in seconds is not included. | |
134 | Total number of times data expansion processing was performed (EXTENSION CNT)#6 | 10 | -- | |
135 | Total time spent for data expansion processing (milliseconds) (EXTENSION TIME)#6 | 10 | In seconds | |
136 | No. 135 in microseconds (EXTENSION TIME(MICRO))#6 | 6 | Value in seconds is not included. | |
137 | Maximum time spent for data expansion processing (MAX EXTENSION TIME)#6 | 10 | In seconds | |
138 | No. 137 in microseconds (MAX EXTENSION TIME(MICRO))#6 | 6 | Value in seconds is not included. | |
139 | Total number of thread-to-thread lock requests for the pool partition for locking (LOCK POOL REQ CNT) | 10 | -- | |
140 | Total number of thread-to-thread lock-release waits for the pool partition for locking (LOCK POOL WAIT CNT) | |||
141 | Sum of the thread-to-thread lock-release wait times for the pool partition for locking (LOCK POOL WAIT TIME)#7, #8 | In seconds | ||
142 | No. 141 in microseconds (LOCK POOL WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
143 | Maximum thread-to-thread lock-release wait time for the pool partition for locking (LOCK POOL MAX WAIT TIME)#7, #8 | 10 | In seconds | |
144 | No. 143 in microseconds (LOCK POOL MAX WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
145 | Sum of the numbers of requests in thread-to-thread lock-release wait queues for the pool partition for locking (LOCK POOL WAIT QUEUE) | 10 | -- | |
146 | Maximum number of requests in the thread-to-thread lock-release wait queue for the pool partition for locking (LOCK POOL MAX WAIT QUEUE) | |||
147 | Total number of log flush requests (BUF FLUSH REQ CNT) | |||
148 | Total number of log flush waits (BUF FLUSH WAIT CNT) | |||
149 | Sum of the log flush wait times (BUF FLUSH WAIT TIME)#7, #8 | In seconds | ||
150 | No. 149 in microseconds (BUF FLUSH WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
151 | Maximum log flush wait time (BUF FLUSH MAX WAIT TIME)#7, #8 | 10 | In seconds | |
152 | No. 151 in microseconds (BUF FLUSH MAX WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
153 | Sum of the numbers of requests in the log flush queue (BUF FLUSH WAIT QUEUE) | 10 | -- | |
154 | Maximum number of requests in the log flush queue (BUF FLUSH MAX WAIT QUEUE) | |||
155 | Total number of global buffer pool lock requests (BUF POOL LOCK REQ CNT) | |||
156 | Total number of thread-to-thread lock-release waits for global buffer pool (BUF POOL LOCK WAIT CNT) | |||
157 | Sum of the thread-to-thread lock-release wait times for global buffer pool (BUF POOL LOCK WAIT TIME)#7, #8 | In seconds | ||
158 | No. 157 in microseconds (BUF POOL LOCK WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
159 | Maximum thread-to-thread lock-release wait time for global buffer pool (BUF POOL LOCK MAX WAIT TIME)#7, #8 | 10 | In seconds | |
160 | No. 159 in microseconds (BUF POOL LOCK MAX WAIT TIME(MICRO))#7, #8 | 6 | Value in seconds is not included. | |
161 | Sum of the numbers of requests in thread-to-thread lock-release wait queue for global buffer pool (BUF POOL LOCK WAIT QUEUE) | 10 | -- | |
162 | Maximum number of requests in the thread-to-thread lock-release wait queue for global buffer pool (BUF POOL LOCK MAX WAIT QUEUE) |
Table 14-10 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) | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) | |
4 | No. 3 in microseconds (START (MICRO)) | Numeric | 6 | Value in seconds is not included. |
5 | SQL execution termination time (END) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | Sequence 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 | System-specific information (FOREIGN REQUEST COUNT) | Numeric | 10 | |
28 | System-specific information (FOREIGN EXEC TIME) | |||
29 | System-specific information (FOREIGN EXEC TIME(MICRO)) | |||
30 | System-specific information (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 | System-specific information (FOREIGN INSERT ROW) | Numeric | 10 | |
34 | System-specific information (FOREIGN UPDATE ROW) | Numeric | 10 | |
35 | System-specific information (FOREIGN DELETE ROW) | Numeric | 10 |
#1: For the operation codes, see Table 14-11 Operation codes.
#2: For the SQL type codes, see Table 14-12 SQL type codes.
Table 14-11 Operation codes
Operation code | Corresponding SQL statements |
---|---|
ALCR | ALLOCATE CURSOR statement |
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 |
CLIN | INSTALL CLIB |
CLRP | REPLACE CLIB |
CLRM | REMOVE CLIB |
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 |
DSET | DEALLOCATE PREPARE statement |
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) |
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# |
#: Output only when the XA interface is used.
Table 14-12 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 | ALTER INDEX | 1079 |
19 | GRANT CONNECT | 1098 |
20 | GRANT DBA | 109C |
21 | REVOKE CONNECT | 10A0 |
22 | REVOKE DBA | 10A4 |
23 | CREATE PROCEDURE | 10B0 |
24 | DROP PROCEDURE | 10B4 |
25 | ALTER PROCEDURE | 10B8 |
26 | CREATE TYPE | 10C0 |
27 | DROP DATA TYPE | 10C4 |
28 | CREATE FUNCTION | 10C8 |
29 | DROP FUNCTION | 10CC |
30 | ALTER ROUTINE | 10E8 |
31 | LOCK statement | 2134 |
32 | SELECT statement | 4000, 4900, 4100, 4A04, 4204 |
33 | INSERT statement | 4108 |
34 | UPDATE statement | 4114 |
35 | DELETE statement | 411C |
36 | ASSIGN LIST statement | 4224, 4324 |
37 | DROP LIST statement | 422C |
38 | PURGE TABLE statement | 4184 |
39 | CALL PROCEDURE | 40BC |
40 | GET DIAGNOSTICS | 40C0 |
41 | Assignment statement | 40C4 |
42 | FREE LOCATOR statement | 40C8 |
Table 14-13 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) | 19 |
| |
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) (Number of times a lock-release wait occurred because a page in buffer was being used by another user) | |||
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 | Global buffer pool lock release waits count (entire buffer defined by a single pdbuffer) (LOCK WAIT CNT) | Exponent representation | ||
40 | Percentage of global buffer pool lock contention-release wait (entire buffer defined by a single pdbuffer) (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 | Global buffer pool lock exclusive time during synchronization point processing (entire buffer defined by a single pdbuffer) (SYNC LOCK) | 10 | -- | |
45 | No. 44 in microseconds (SYNC LOCK(MICRO)) | 6 | Value in seconds is not included | |
46 | Number of buffers processed within the global buffer pool lock exclusive time during synchronization point processing (entire buffer defined by a single pdbuffer) (SYNC BUFF) | 10 | -- | |
47 | Take-over count of database write processing by reference request hit during synchronization point processing (REF ALTWRITE) | |||
48 | Take-over count of database write processing by update request hit during synchronization point processing (UPD ALTWRITE) | |||
49 | Sum of the contention-lock release wait times (LOCK WAIT TIME)#1, #2 | In seconds | ||
50 | No. 49 in microseconds (LOCK WAIT TIME(MICRO))#1, #2 | 6 | Value in seconds is not included | |
51 | Sum of the numbers of requests in contention-lock release queues (LOCK WAIT QUEUE) | 10 | -- |
When the total of a global buffer's reference GETs plus update GETs exceeds 4,294,967,295, statistical information for that global buffer is reset. For details, see 2.9(6) Notes.
The global buffer pool statistical information includes information about in-memory data buffers, but the value displayed for each item is an approximate value.
Table 14-14 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) | 19 |
| |
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-15 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) | 19 |
| |
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. 19 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-16 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 | Sequence 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-11. |
9 | Section number (SECTION NO) | Numeric | 5 | -- |
10 | SQL type code (SQL TYPE CODE) | Character | 4 | For SQL type codes, see Table 14-12. |
11 | Server name (SERVER NAME) | 8 | -- | |
12 | Syntax analysis start time (PARSE START(S)) | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) | |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
25 | No. 24 in microseconds (OPT START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
26 | Optimization termination time (OPT END(S)) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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-17 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 | Sequence 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-11. |
9 | Section number (SECTION NO) | Numeric | 5 | -- |
10 | SQL type code (SQL TYPE CODE) | Character | 4 | For SQL type codes, see Table 14-12. |
11 | Server name (SERVER NAME) | 8 | -- | |
12 | Dynamic optimization start time (DYNAMIC START) | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) | |
13 | No. 12 in microseconds (START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
14 | Dynamic optimization termination time (DYNAMIC END) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 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-18 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 | Sequence 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-11. |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
15 | No. 14 in microseconds (START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
16 | SQL object execution termination time (SQLOBJ END) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) Format YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | System-specific information (FOREIGN REQUEST COUNT) | Numeric | 10 | -- |
37 | System-specific information (FOREIGN EXEC TIME) | |||
38 | System-specific information (FOREIGN EXEC TIME(MICRO)) | |||
39 | System-specific information (FOREIGN FETCH ROW) | |||
40 | System-specific information (FOREIGN INSERT ROW) | |||
41 | System-specific information (FOREIGN UPDATE ROW) | |||
42 | System-specific information (FOREIGN DELETE ROW) |
Table 14-19 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-11. | |
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-12. |
12 | SQL code (SQLCODE) | Numeric | 10 | -- |
13 | Service start time (SERVICE START) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
14 | No. 13 in microseconds (SERVICE START(MICRO)) | Numeric | 6 | Value in seconds is not included. |
15 | Service termination time (SERVICE END) | Character | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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 | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) |
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-20 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 | Sequence 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-11. |
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-21 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) | 19 | Format: MM/DD/hh:mm:ss (when -y is omitted) YYYY/MM/DD hh:mm:ss (when -y is specified) | |
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 0: Utility #: Other blank: None (space: 0x20) | ||
9 | Privilege information (PRIVILEGE) | C: CONNECT privilege D: DBA privilege blank: None (space: 0x20) | ||
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-22 Record format of a DAT-format file (statistical information about database I/O operations)
No. | Field name (title bar) | Attribute | Maximum length | Remarks | |
---|---|---|---|---|---|
1 | Host name (HOST) | Character | 32 | -- | |
2 | Server name (SERVER) | 8 | -- | ||
3 | Name of the RDAREA in which I/O operations occurred (RDAREA NAME) | 30 | -- | ||
4 | Sequence number of the HiRDB file constituting the RDAREA indicated in 3 (FILE NUMBER) | Numeric | 2 | -- | |
5 | Time the statistics log was acquired (LOG GET TIME) | Character | 19 | Format: YYYY/MM/DD hh:mm:ss | |
6 | Page length of the HiRDB file (PAGE SIZE(K)) | Numeric | 6 | In kilobytes | |
7 | Reads count per acquisition interval (READ CNT) | 10 | -- | ||
8 | Number of reads for which time was measured among all reads that occurred within the acquisition interval (READ MEASURE CNT) | -- | |||
9 | Time in microseconds for the reads for which time was measured (READ TIME(MICRO)) | Total value (SUM) | 12 | Includes the time in seconds. | |
10 | Maximum value (MAX) | ||||
11 | Writes count per acquisition interval (WRITE CNT) | 10 | -- | ||
12 | Number of writes for which time was measured among all writes that occurred within the acquisition interval (WRITE MEASURE CNT) | -- | |||
13 | Time in microseconds for the writes for which time was measured (WRITE TIME(MICRO)) | Total value (SUM) | 12 | Includes the time in seconds. | |
14 | Maximum value (MAX) | -- | |||
15 | Rank type (RANK KIND) | Character | 2 | The top 10 values are selected. Reads count: RC Total read time: RS Maximum read time: RM Writes count: WC Total write time: WS Maximum write time: WM No item selected#: * |