Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

14.4.3 Record formats of DAT-format files

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:

#1
If there are multiple pool partitions for locking (a value greater than 1 was specified in the pd_lck_pool_partition or pd_fes_lck_pool_partition operand), the usage rates calculated for all pool partitions for locking are totaled, and then the maximum, minimum, and average values are output.

#2
This value includes not only the system log file output counts but also the number of write operations performed when system log file status changes occur. If dual system log files are used, the number of write operations for both systems are included. This value also includes not only the system log block output count, but also the number of file write operations that occur when the file status changes due to swapping of system log files. If the system log parallel output facility is used, data is written to the dual system log files in parallel. Therefore, a completion of write operations in both systems is counted as 1.

#3
If a negative value is obtained because, for example, the OS time was moved back, a value of 0 is output as the statistical information. For a reason such as this, the displayed value might be smaller than the actual value.

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)

#1
If the automatic numbering facility is used, the operation of the sequence generators is also included in this value.

#2
If a negative value is obtained because, for example, the OS time was moved back, a value of 0 is output as the statistical information. For a reason such as this, the displayed value might be smaller than the actual value.

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)

#1
If there are multiple pool partitions for locking (a value greater than 1 was specified in the pd_lck_pool_partition or pd_fes_lck_pool_partition operand), the numbers of thread-to-thread lock-release waits obtained for all pool partitions for locking are totaled, and then the maximum, minimum, and average values are output.

#2
This value includes not only the system log file output counts and time but also the number of write operations and the write operation time required when system log file status changes occur. If dual system log files are used, the number of write operations and the write operation time for both systems are included. This value also includes not only the system log block write operations count and the system log block write operation time, but also the number of write operations and the write operation time required when the file status changes due to swapping of system log files. If the system log parallel output facility is used, data is written to the dual system log files in parallel. Therefore, a completion of write operations in both systems is counted as 1. For the write operation time, the calculation is based on the amount of time required until write operations are completed in both systems since write operations began in one of the systems.

#3
If you process an input statistics unload file obtained by a HiRDB version earlier than 08-04 using a statistics analysis utility whose version is 08-04 or later, the utility displays 0 as the average and maximum value and 4,294,967,295 as the minimum value.

#4
If you process an input statistics unload file obtained by a HiRDB version earlier than 08-04 using a statistics analysis utility whose version is 08-04 or later, the utility displays 0 as the count.

#5
This information is output when the -w option is specified in the pdstbegin command to collect the thread-to-thread lock-release wait time. If the wait time is not collected, 0 is displayed. For details about the -w option in the pdstbegin command, see (4) Options under pdstbegin (Start output of statistical information).

#6
Because the precision of the displayed values depends on the OS and the hardware being used, a displayed value might be smaller than the actual value.

#7
If a negative value is obtained because, for example, the OS time was moved back, a value of 0 is output as the statistical information. For a reason such as this, the displayed value might be smaller than the actual value.

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)

Note
For a HiRDB parallel server configuration, Nos. 73, 74, 79 to 102, 126, and 127 indicate the total value for all back-end servers. If overflow occurs while values are being totaled for Nos. 139 to 162, **** is output.

#1
For a HiRDB parallel server configuration, 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 configuration, 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.

#6
This information is for BINARY-type data.

#7
This information is collected when the -w option is specified in the pdstbegin command to collect the thread-to-thread lock-release wait time. For details about the -w option in the pdstbegin command, see (4) Options under pdstbegin (Start output of statistical information).

#8
Because the precision of the displayed values depends on the OS and the hardware being used, a displayed value might be smaller than the actual value.

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

When -y is omitted:
MM/DD/hh:mm format (when -e sec is omitted)
MM/DD/hh:mm:ss format (when -e sec is specified)

When -y is specified:
YYYY/MM/DD hh:mm:ss format
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 --

#1
This information is collected when the -w option is specified in the pdstbegin command to collect the thread-to-thread lock-release wait time. For details about the -w option in the pdstbegin command, see (4) Options under pdstbegin (Start output of statistical information).

#2
Because the precision of the displayed values depends on the OS and the hardware being used, a displayed value might be smaller than the actual value.

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

When -y is omitted:
MM/DD/hh:mm format (when -e sec is omitted)
MM/DD/hh:mm:ss format (when -e sec is specified)

When -y is specified:
YYYY/MM/DD hh:mm:ss format
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)

#
This item might be blank if the open attribute of the RDAREA indicated in 4 is not INITIAL and this RDAREA has never been accessed. Ignore a record whose value for this item is blank. You can check the HiRDB files constituting the RDAREA by using the database condition analysis utility with -k phys -f specified.

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

When -y is omitted:
MM/DD/hh:mm format (when -e sec is omitted)
MM/DD/hh:mm:ss format (when -e sec is specified)

When -y is specified:
YYYY/MM/DD hh:mm:ss format
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.

Note
If the WRITE count is fewer than the total number of pages output (OUT PAGE), information is output in the batch mode. When information is output in the batch mode, the unit value of WRITE in Nos. 9 through 14 may be greater than when information is not output in the batch mode.

#: 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

Notes
  1. If SERVICE KIND is N, P, or R, the utility sets a null value (0 or " ") in items 8 to 11.
  2. The utility sets a null value (0 or " ") in items 19 to 25 in the following cases:
  • The SQL object was found in the SQL object buffer.
  • An error occurred before the SQL object is transferred (the SQL code is a non-zero value).

    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.

Note
SQL statement statistical information is output only when the operation code is AUXI, OPN2, CALL, AUI2, or SET.

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#: *

#
This applies when pdstbegin -D everyfile is specified.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.