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)AttributeMaximum lengthRemarks
101Dictionary information (DICTIONARY)Number of table definition information acquisition requests (TBL-DEF GET REQ)#1Number of occurrences (FREQ)Numeric10Dictionary information is continued to Nos. 200 to 251 and 260 to 267.
102Table definition information buffer hits count (TABLE CACHE HIT)#1Number of occurrences (FREQ)--
103Number of definition information items in table definition information buffer (CASHED TBL-DEF)#1Number of occurrences (FREQ)--
104Maximum value (MAX)
105Minimum value (MIN)
106Average value (AVG)
107Size of table definition information buffer used per table definition information item (USE TBL-DEF SIZE)#1Number of occurrences (FREQ)--
108Maximum value (MAX)In bytes
109Minimum value (MIN)
110Average value (AVG)
111Size of area used by table definition information buffer (CACHED TBL-DEF SIZE)#1Number of occurrences (FREQ)--
112Maximum value (MAX)In bytes
113Minimum value (MIN)
114Average value (AVG)
115Table access privilege information acquisitions count (ACCESS PRIV CHECK)Number of occurrences (FREQ)--
116Table access privilege information buffer hits count (CACHE HIT(ACCESS))Number of occurrences (FREQ)--
117User privilege information acquisition requests (CON/DBA DEF GET REQ)Number of occurrences (FREQ)--
118User privilege information buffer hits count (CON/DBA CACHE HIT)Number of occurrences (FREQ)--
119Number of users using the user privilege information buffer (CON/DBA CACHED USER)Number of occurrences (FREQ)--
120Maximum value (MAX)--
121Minimum value (MIN)--
122Average value (AVG)--
123Length of communication with dictionary server (DIC TRANS DATA LEN)Number of occurrences (FREQ)--
124Maximum value (MAX)In bytes
125Minimum value (MIN)
126Average value (AVG)
127Dictionary server communications count (TRANS)Number of occurrences (FREQ)--
128Number of view analysis information acquisition requests (VIEW DEF GET REQ)Number of occurrences (FREQ)
129View analysis information buffer hits count (VIEW DEF CACHE HIT)Number of occurrences (FREQ)
130Number of view analysis information items in view analysis information buffer (VIEW CACHED DEF)Number of occurrences (FREQ)--
131Size of view analysis information buffer used per view analysis information item (USED VIEW SIZE)Number of occurrences (FREQ)
132Maximum value (MAX)In bytes
133Minimum value (MIN)
134Average value (AVG)
135Length of view analysis information buffer used (VIEW CACHE SIZE)Number of occurrences (FREQ)--
136Maximum value (MAX)In bytes
137Minimum value (MIN)
138Average value (AVG)
139Length of view analysis information resulting in buffer misses (CACHE MISS VIEW SIZE)Number of occurrences (FREQ)--
140Maximum value (MAX)In bytes
141Minimum value (MIN)
142Average value (AVG)
143SQL 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)--
144SQL object buffer hits count (SQLOBJ CACHE HIT)Number of occurrences (FREQ)
145Number of SQL objects in SQL object buffer (CACHED SQLOBJ)Number of occurrences (FREQ)
146Maximum value (MAX)
147Minimum value (MIN)
148Average value (AVG)
149Total length of SQL objects in SQL object buffer (CACHED SQLOBJ SIZE)Number of occurrences (FREQ)--
150Maximum value (MAX)In KB
151Minimum value (MIN)
152Average value (AVG)
153Number of SQL objects swapped out of SQL object buffer (SWAP OUT SQLOBJ)Number of occurrences (FREQ)--
154SQL object length (SQLOBJ LEN)Number of occurrences (FREQ)--
155Maximum value (MAX)In bytes
156Minimum value (MIN)
157Average value (AVG)
158Number of acquisition requests for stored procedure objects (STROBJ GET REQ)Number of occurrences (FREQ)--
159SQL object buffer hits count for stored procedure objects (STROBJ CACHE HIT)Number of occurrences (FREQ)
160Number of stored procedure objects in SQL object buffer (CACHED STROBJ)Number of occurrences (FREQ)--
161Maximum value (MAX)
162Minimum value (MIN)
163Average value (AVG)
164Total length of stored procedure objects in SQL object buffer (CACHED STROBJ SIZE)Number of occurrences (FREQ)--
165Maximum value (MAX)In KB
166Minimum value (MIN)
167Average value (AVG)
168Number of stored procedure objects swapped out of SQL object buffer (SWAP OUT STROBJ)Number of occurrences (FREQ)--
169Stored procedure object length (STROBJ LEN)Number of occurrences (FREQ)
170Maximum value (MAX)In bytes
171Minimum value (MIN)
172Average value (AVG)
173Number of times stored procedure objects were recompiled (STROBJ RECOMPILE)Number of occurrences (FREQ)--
174Process information (PROCESS)Number of server processes under service execution (SERVICE COUNT)Maximum value (MAX)Numeric10--
175Minimum value (MIN)
176Average value (AVG)
177Number of service requests exceeding maximum number of startup processes (REQUEST OVER)Number of requests (FREQ)
178RPC information (RPC)Service response time for local unit's servers (RESPONSE ON OWN UNIT)#2Number of occurrences (FREQ)Numeric10--
179Maximum value (MAX)In 100 microseconds
180Minimum value (MIN)
181Average value (AVG)
182Service response time for remote unit's servers (RESPONSE TO OTHER UNIT)#2Number of occurrences (FREQ)--
183Maximum value (MAX)In 100 microseconds
184Minimum value (MIN)
185Average value (AVG)
186Execution time per service from local unit's servers (EXEC TIME ON OWN UNIT)#2Number of occurrences (FREQ)--
187Maximum value (MAX)In 100 microseconds
188Minimum value (MIN)
189Average value (AVG)
190Execution time per service from remote unit's servers (EXEC TIME FROM OTHER UNIT)#2Number of occurrences (FREQ)--
191Maximum value (MAX)In 100 microseconds
192Minimum value (MIN)
193Average value (AVG)
194Number of SENDs to local process (SEND TO OWN PRCS)Number of occurrences (FREQ)--
195Number of SENDs to other processes on local unit (SEND TO OTHER PRCS)Number of occurrences (FREQ)
196Number of SENDs to remote unit (SEND TO OTHER UNIT)Number of occurrences (FREQ)
197Number of RECEIVEs from local process (RECEIVE FROM OWN PRCS)Number of occurrences (FREQ)
198Number of RECEIVEs from other processes on local unit (RECEIVE FROM OTHER PRCS)Number of occurrences (FREQ)
199Number 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)AttributeMaximum lengthRemarks
200Dictionary information (DICTIONARY)Number of type definition information acquisition requests (TYPE-DEF GET REQ)Number of occurrences (FREQ)Numeric10--
201User-defined type information buffer hits count (TYPE-DEF CACHE HIT)Number of occurrences (FREQ)
202Number of type definition information items in user-defined type information buffer (CACHED TYPE-DEF)Number of occurrences (FREQ)
203Maximum value (MAX)
204Minimum value (MIN)
205Average value (AVG)
206Size of area used by user-defined type information buffer per type definition information item (TYPE-DEF CACHE SIZE)Number of occurrences (FREQ)
207Maximum value (MAX)In bytes
208Minimum value (MIN)
209Average value (AVG)
210Total size of area used by user-defined type information buffer (TYPE-DEF CACHE TOTAL SIZE)Number of occurrences (FREQ)--
211Maximum value (MAX)In bytes
212Minimum value (MIN)
213Average value (AVG)
214Size of user-defined type information buffer allocated (TYPE-DEF CACHE ALLOC SIZE)Number of occurrences (FREQ)--
215Maximum value (MAX)In bytes
216Minimum value (MIN)
217Average value (AVG)
218Number of routine definition information acquisition requests (RTN-DEF GET REQ)Number of occurrences (FREQ)--
219Routine definition information buffer hits count (RTN-DEF CACHE HIT)Number of occurrences (FREQ)--
220Number of routine definition information items in routine definition information buffer (CACHED RTN-DEF)Number of occurrences (FREQ)
221Maximum value (MAX)
222Minimum value (MIN)
223Average value (AVG)
224Size of area used by routine definition information buffer per routine definition information item (RTN-DEF CACHE SIZE)Number of occurrences (FREQ)--
225Maximum value (MAX)In bytes
226Minimum value (MIN)
227Average value (AVG)
228Total size of area used by routine definition information buffer (RTN-DEF CACHE TOTAL SIZE)Number of occurrences (FREQ)--
229Maximum value (MAX)In bytes
230Minimum value (MIN)
231Average value (AVG)
232Size of routine definition information buffer allocated (RTN-DEF CACHE ALLOC SIZE)Number of occurrences (FREQ)--
233Maximum value (MAX)In bytes
234Minimum value (MIN)
235Average value (AVG)
236Number of routine definition acquisition requests for plug-in-provided functions (PLG-RTN GET REQ)Number of occurrences (FREQ)--
237Routine definition information buffer hits count for plug-in provided functions (PLG-RTN CACHE HIT)Number of occurrences (FREQ)
238Number of registry information acquisition requests (REGISTRY GET REQ)Number of occurrences (FREQ)--
239Registry information buffer hits count (REGISTRY CACHE HIT)Number of occurrences (FREQ)
240Number of registry information items in registry information buffer (CACHED REGISTRY-DEF)Number of occurrences (FREQ)
241Maximum value (MAX)
242Minimum value (MIN)
243Average value (AVG)
244Size of registry information buffer per registry information item (REGISTRY CACHE SIZE)Number of occurrences (FREQ)
245Maximum value (MAX)In bytes
246Minimum value (MIN)
247Average value (AVG)
248Total size of area used by registry information buffer (REGISTRY CACHE TOTAL SIZE)Number of occurrences (FREQ)--
249Maximum value (MAX)In bytes
250Minimum value (MIN)
251Average value (AVG)
252RPC information (RPC)Number of HiRDB-reserved ports used (REGISTERED PORTS)Number of occurrences (FREQ)Numeric10--
253Maximum value (MAX)
254Minimum value (MIN)
255Average value (AVG)
256Number of ports automatically assigned by OS when HiRDB-reserved ports ran out (ASSIGNED PORTS)Number of occurrences (FREQ)
257Maximum value (MAX)
258Minimum value (MIN)
259Average value (AVG)
260Dictionary information (DICTIONARY)Directory-registered user authentication time (DIRECTORY USER CHECK TIME)#7Number of occurrences (FREQ)Numeric10--
261Maximum value (MAX)In microseconds
262Minimum value (MIN)
263Average value (AVG)
264Group checking time (GROUP CHECK TIME)#7Number of occurrences (FREQ)--
265Maximum value (MAX)In microseconds
266Minimum value (MIN)
267Average value (AVG)
268Lock information (LOCK)Number of thread-to-thread lock-release waits for the pool partition for locking (REQUEST WAIT QUEUE)#1Count (FREQ)Numeric10--
269Maximum value (MAX)
270Minimum value (MIN)
271Average value (AVG)
272Log information (LOG)File write operation time (FILE WRITE TIME)#2, #7Count (FREQ) #2Numeric10--
273Maximum value (MAX) #2, #3In microseconds
274Minimum value (MIN) #2, #3
275Average value (AVG) #2, #3
276File read operation time (FILE READ TIME)#7Count (FREQ)--
277Maximum value (MAX) #3In microseconds
278Minimum value (MIN)#3
279Average value (AVG) #3
280Buffering count (BUFFERING)Count (FREQ) #4--
281Lock information (LOCK)Number of thread-to-thread lock requests (REQUEST)#1Count (FREQ)--
282Number of thread-to-thread lock-release waits (REQUEST WAIT)#1Count (FREQ)--
283Number of thread-to-thread lock-release wait time (REQUEST WAIT TIME)#1, #5, #6, #7Maximum value (MAX)In microseconds
284Minimum value (MIN)
285Average value (AVG)
286Log information (LOG)Number of requests in the log flush queue (BUF FLUSH WAIT QUEUE)Count (FREQ)--
287Maximum value (MAX)--
288Minimum value (MIN)--
289Average value (AVG)--
290Number of log flush requests (BUF FLUSH)Count (FREQ)--
291Number of log flush waits (BUF FLUSH WAIT)Count (FREQ)--
292Total log flush wait time (BUF FLUSH WAIT TIME)#5, #6, #7Maximum value (MAX)In microseconds
293Minimum value (MIN)
294Average 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3UAP or transaction execution start time (START)Character19Format: MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
4No. 3 in microseconds (START (MICRO))Numeric6Value in seconds is not included.
5UAP or transaction execution termination time (END)Character19Format: MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
6No. 5 in microseconds (END (MICRO))Numeric6Value in seconds is not included.
7Termination status (STATUS)Character1N: Normal termination
E: Termination after rollback
8UAP or transaction execution time (UAP EXEC TIME(S))Numeric10In seconds (value less than a second is rounded)
9Size of table definition information buffer used (CACHE SIZE)In bytes
10Number of SQL object acquisition requests (REQ (SQL))--
11SQL object buffer hits count (HITS (SQL))
12SQL object creations count (CREATE)
13Maximum size of SQL object created (SQL MAX)In bytes
14COMMIT statement executions count (COMMIT)--
15ROLLBACK statement executions count (ROLLBACK)
16Number of rows actually retrieved by FETCH or SELECT statement (FETCH ROW)
17Number of rows actually deleted by DELETE statement (DELETE ROW)
18Number of rows actually inserted by INSERT statement (INSERT ROW)
19Number of rows actually updated by UPDATE statement (UPDATE ROW)
20SQL statement preprocessings count (SET)
21OPEN statement executions count (OPEN)
22FETCH statement executions count (FETCH)
23CLOSE statement executions count (CLOSE)
24DESCRIBE statement executions count (DESCRIBE)
25SELECT statement executions count (SELECT)
26INSERT statement executions count (INSERT)
27UPDATE statement executions count (UPDATE)
28DELETE statement executions count (DELETE)
29LOCK statement executions count (LOCK)
30CREATE TABLE executions count (CREATE TABLE)
31ALTER TABLE executions count (ALTER TABLE)
32DROP TABLE executions count (DROP TABLE)
33CREATE INDEX executions count (CREATE INDEX)
34DROP INDEX executions count (DROP INDEX)
35COMMENT TABLE executions count (COMMENT TABLE)
36COMMENT COLUMN executions count (COMMENT COLUMN)
37CREATE SCHEMA executions count (CREATE SCHEMA)
38DROP SCHEMA executions count (DROP SCHEMA)
39GRANT RDAREA executions count (GRANT RDAREA)
40GRANT SCHEMA executions count (GRANT SCHEMA)
41GRANT access-privilege executions count (GRANT ACCESS)
42GRANT CONNECT executions count (GRANT CONNECT)
43GRANT DBA executions count (GRANT DBA)
44REVOKE RDAREA executions count (REVOKE RDAREA)
45REVOKE SCHEMA executions count (REVOKE SCHEMA)
46REVOKE access-privilege executions count (REVOKE ACCESS)
47REVOKE CONNECT executions count (REVOKE CONNECT)
48REVOKE DBA executions count (REVOKE DBA)
49CREATE VIEW executions count (CREATE VIEW)
50DROP VIEW executions count (DROP VIEW)
51System-specific information (UNUSED)
52System-specific information (UNUSED)
53PURGE TABLE statement executions count (PURGE TABLE)
54Other executions count (MISC)
55Number of acquisition requests for stored procedure objects (SQLOBJ GET REQ)
56SQL object buffer hits count for stored procedure objects (SQLOBJ CACHE HIT)
57CREATE PROCEDURE executions count (CREATE PROCEDURE)
58DROP PROCEDURE executions count (DROP PROCEDURE)
59CALL statement executions count (CALL)
60DESCRIBE statement (INPUT) executions count (DESCRIBE INPUT)
61ALTER PROCEDURE executions count (ALTER PROCEDURE)
62UAP or transaction execution time (UAP EXEC TIME (MS))

In milliseconds (includes a value in seconds; a value less than a millisecond is rounded)
63Service name (SERVICE NAME)Character31--
64Lock release wait time (LOCK TIME)#1Numeric10In seconds
65No. 64 in microseconds (LOCK TIME (MICRO))#16Value in seconds is not included.
66Output timing for the corresponding row (OUTPUT TIMING)Character1C: In UAP executions
T: In transactions
67Front-end server name (FES NAME)8--
68Connect number (CONNECT NO)Numeric10Sequence number assigned to each connection within one front-end server
69Font-end server process ID (FES PROCESS ID)--
70CPU time (CPU TIME)#4In milliseconds
71Single server or front-end server processing time (SERV EXEC TIME)#2In seconds
72No. 71 in microseconds (SERV EXEC TIME (MICRO))6Value in seconds is not included.
73Total input/output time (IO TIME)#510In seconds
74No. 73 in microseconds (IO TIME (MICRO))#56Value in seconds is not included.
75Maximum input/output time (MAX IO TIME)#310In seconds
76No. 75 in microseconds (MAX IO TIME (MICRO))6Value in seconds is not included.
77Minimum input/output time (MIN IO TIME)#310In seconds
78No. 77 in microseconds (MIN IO TIME (MICRO))6Value in seconds is not included.
79Reference operations count on data page, index page, or directory page (DID RF CNT)#510--
80Update operations count on data page, index page, or directory page (DID UPD CNT)#5
81Buffer hits count for data page, index page, or directory page (DID HIT CNT)#5
82Buffer hit ratio for data page, index page, or directory page (DID BUF HIT RATIO)3Percentage
83Real READs count for data page, index page, or directory page (DID READ CNT)#510--
84Real WRITEs count for data page, index page, or directory page (DID WRITE CNT)#5
85Reference operations count on LOB column data page (LOB RF CNT)#5
86Update operations count on LOB column data page (LOB UPD CNT)#5
87Reference buffer hits count for LOB column data page (LOB RF HIT CNT)#5
88Update buffer hits count for LOB column data page (LOB UPD HIT CNT)#5
89Reference buffer hits count for LOB column data page (LOB RF BUF HIT RATIO)3Percentage
90Update buffer hits count for LOB column data page (LOB UPD BUF HIT RATIO)
91Real READs count for LOB column database (LOB READ CNT)#510--
92Real WRITEs count for LOB column database (LOB WRITE CNT)#5
93Global buffer flashes count (BUF FLASH CNT)#5
94READ waits count for global buffer (BUF READ WAIT CNT)#5
95WRITE waits count for global buffer (BUF WRITE WAIT CNT)#5
96Global buffer lock release waits count (BUF LOCK WAIT CNT)#5
97Maximum number of work table files (MAX WKFILE NUM)
98Maximum number of work table file extensions (MAX WKFILE EXP CNT)
99Maximum size of work table file (MAX WKFILE VOLUME)In MB
100Work table file READs count (WKFILE READ CNT)#5--
101Work table file WRITEs count (WKFILE WRITE CNT)#5
102Number of forced outputs on work table buffer (WKFILE BUF FORCED OUT CNT)#5
103Maximum hash table size in batch processing mode (MAX WHOLE HASH TABLE SIZE)In KB
104Maximum level-1 bucket size (MAX BUCKET SIZE LEVEL 1)
105Maximum level-2 bucket size (MAX BUCKET SIZE LEVEL 2)
106Maximum level-3 bucket size (MAX BUCKET SIZE LEVEL 3)
107Number of times page search for reutilization of free space failed (REUSE FAILURE CNT)#5--
108Number of times the mode changed from new page allocate to free page reuse on a table with SEGMENT REUSE specified (REUSE CHANGE CNT)#5
109Number of times data pages and index pages were referenced using the local buffer (LOCAL BUF RF CNT)#5
110Number of times data pages and index pages were updated using the local buffer (LOCAL BUF UPD CNT)#5
111Local buffer hit count for data pages and index pages (LOCAL BUF HIT CNT)#5
112Number of real READs on data pages and index pages using the local buffer (LOCAL BUF READ CNT)#5
113Number of real WRITEs on data pages and index pages using the local buffer (LOCAL BUF WRITE CNT)#5
114Local buffer flush count (LOCAL BUF FLUSH CNT)#5
115Number of asynchronous READ requests (AR REQ CNT)#5
116Number of times synchronization waits occurred during asynchronous READ (AR SYNC WAIT CNT)#5
117Total synchronization wait time during asynchronous READ (AR SYNC WAIT TIME TOTAL)#5In seconds
118No. 177 in microseconds (AR SYNC WAIT TIME TOTAL (MICRO))#56Value in seconds is not included.
119Average synchronization wait time during asynchronous READ (AR SYNC WAIT TIME AVERAGE)10In seconds
120No. 119 in microseconds (AR SYNC WAIT TIME AVERAGE (MICRO))6Value in seconds is not included.
121Total synchronous input/output time during asynchronous READ (AR SYNC IO TIME TOTAL)#510In seconds
122No. 121 in microseconds (AR SYNC IO TIME TOTAL (MICRO))#56Value in seconds is not included.
123Average synchronous input/output time during asynchronous READ (AR SYNC IO TIME AVERAGE)10In seconds
124No. 123 in microseconds (AR SYNC IO TIME AVERAGE (MICRO))6Value in seconds is not included.
125Maximum comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (MAX HASH COMP COUNT)#310--
126Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)#510
127Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)#510
128Total number of segments used during execution of SQL statements that use temporary tables (TOTAL SEGMENTS USED FOR TEMP TABLE)10
129Total number of times data compression processing was performed (COMPRESSION CNT)#610
130Total time spent for data compression processing (COMPRESSION TIME)#610In seconds
131No. 130 in microseconds (COMPRESSION TIME(MICRO))#66Value in seconds is not included.
132Maximum time spent for data compression processing (MAX COMPRESSION TIME)#610In seconds
133No. 132 in microseconds (MAX COMPRESSION TIME(MICRO))#66Value in seconds is not included.
134Total number of times data expansion processing was performed (EXTENSION CNT)#610--
135Total time spent for data expansion processing (milliseconds) (EXTENSION TIME)#610In seconds
136No. 135 in microseconds (EXTENSION TIME(MICRO))#66Value in seconds is not included.
137Maximum time spent for data expansion processing (MAX EXTENSION TIME)#610In seconds
138No. 137 in microseconds (MAX EXTENSION TIME(MICRO))#66Value in seconds is not included.
139Total number of thread-to-thread lock requests for the pool partition for locking (LOCK POOL REQ CNT)10--
140Total number of thread-to-thread lock-release waits for the pool partition for locking (LOCK POOL WAIT CNT)
141Sum of the thread-to-thread lock-release wait times for the pool partition for locking (LOCK POOL WAIT TIME)#7, #8In seconds
142No. 141 in microseconds (LOCK POOL WAIT TIME(MICRO))#7, #86Value in seconds is not included.
143Maximum thread-to-thread lock-release wait time for the pool partition for locking (LOCK POOL MAX WAIT TIME)#7, #810In seconds
144No. 143 in microseconds (LOCK POOL MAX WAIT TIME(MICRO))#7, #86Value in seconds is not included.
145Sum of the numbers of requests in thread-to-thread lock-release wait queues for the pool partition for locking (LOCK POOL WAIT QUEUE)10--
146Maximum number of requests in the thread-to-thread lock-release wait queue for the pool partition for locking (LOCK POOL MAX WAIT QUEUE)
147Total number of log flush requests (BUF FLUSH REQ CNT)
148Total number of log flush waits (BUF FLUSH WAIT CNT)
149Sum of the log flush wait times (BUF FLUSH WAIT TIME)#7, #8In seconds
150No. 149 in microseconds (BUF FLUSH WAIT TIME(MICRO))#7, #86Value in seconds is not included.
151Maximum log flush wait time (BUF FLUSH MAX WAIT TIME)#7, #810In seconds
152No. 151 in microseconds (BUF FLUSH MAX WAIT TIME(MICRO))#7, #86Value in seconds is not included.
153Sum of the numbers of requests in the log flush queue (BUF FLUSH WAIT QUEUE)10--
154Maximum number of requests in the log flush queue (BUF FLUSH MAX WAIT QUEUE)
155Total number of global buffer pool lock requests (BUF POOL LOCK REQ CNT)
156Total number of thread-to-thread lock-release waits for global buffer pool (BUF POOL LOCK WAIT CNT)
157Sum of the thread-to-thread lock-release wait times for global buffer pool (BUF POOL LOCK WAIT TIME)#7, #8In seconds
158No. 157 in microseconds (BUF POOL LOCK WAIT TIME(MICRO))#7, #86Value in seconds is not included.
159Maximum thread-to-thread lock-release wait time for global buffer pool (BUF POOL LOCK MAX WAIT TIME)#7, #810In seconds
160No. 159 in microseconds (BUF POOL LOCK MAX WAIT TIME(MICRO))#7, #86Value in seconds is not included.
161Sum of the numbers of requests in thread-to-thread lock-release wait queue for global buffer pool (BUF POOL LOCK WAIT QUEUE)10--
162Maximum 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3SQL execution start time (START)19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
4No. 3 in microseconds (START (MICRO))Numeric6Value in seconds is not included.
5SQL execution termination time (END)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
6No. 5 in microseconds (END (MICRO))Numeric6Value in seconds is not included.
7Length of created SQL object (PDATA)10In bytes
8Number of back-end servers that sent SQL object (BES COUNT)--
9SQL execution time (SQL EXEC TIME (MICRO))In microseconds (includes the value in seconds)
10Number of rows retrieved (FETCH ROW)--
11Number of rows inserted (INSERT ROW)
12Number of rows updated (UPDATE ROW)
13Number of rows deleted (DELETE ROW)
14Number of rows created in work table (CREATE LIST)
15Number of rows deleted from work table (DROP LIST)
16SQL execution time (SQL EXEC TIME (SEC))In seconds (value is rounded off)
17Service name (SERVICE NAME)Character31--
18Front-end server name (FES NAME)8
19Connection number (CONNECT NO)Numeric10Sequence number assigned to each connection in one front-end server.
20SQL counter (SQL COUNTER)--
21Front-end server process ID (FES PROCESS ID)
22Operation code (OPERATION CODE)#1Character4--
23Section number (SECTION NO)Numeric5
24SQL type code (SQL TYPE CODE)#2Character4
25SQL code (SQLCODE)Numeric10
26Server name (SERVER NAME)Character8
27System-specific information (FOREIGN REQUEST COUNT)Numeric10
28System-specific information (FOREIGN EXEC TIME)
29System-specific information (FOREIGN EXEC TIME(MICRO))
30System-specific information (FOREIGN FETCH ROW)
31Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)Numeric10
32Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)Numeric10
33System-specific information (FOREIGN INSERT ROW)Numeric10
34System-specific information (FOREIGN UPDATE ROW)Numeric10
35System-specific information (FOREIGN DELETE ROW)Numeric10

#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 codeCorresponding SQL statements
ALCRALLOCATE CURSOR statement
AUI2DELETE 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)
AUI3Assignment statement (static SQL)
AUXEXECUTE statement
AUXIEXECUTE IMMEDIATE statement and all definition SQL statements
AUXOEXECUTE statement (INTO specified)
CALLCALL statement
CLININSTALL CLIB
CLRPREPLACE CLIB
CLRMREMOVE CLIB
CLOSCLOSE statement
CMITCOMMIT statement
CNCTCONNECT statement
CPRPCommit Prepare#
DESCDESCRIBE statement (OUTPUT specified)
DESTDESCRIBE TYPE statement
DISCDISCONNECT statement, COMMIT statement (RELEASE specified)
DISRROLLBACK statement (RELEASE specified)
DISTDisconnect + Tran Check#
DSCMUsed by system
DSETDEALLOCATE PREPARE statement
DSPRUsed by system
DSRLUsed by system
FETCFETCH statement
GETDGET DIAGNOSTICS
HVARDESCRIBE statement (INPUT specified)
JARIINSTALL JAR
JARRREPLACE JAR
JARUREMOVE JAR
OPENOPEN statement (dynamic SQL)
OPN2OPEN statement (static SQL)
OPNROPEN statement (dynamic SQL (multiple cursors))
RENVUsed by system
RNCNCONNECT statement (TO specified)
RNDSDISCONNECT statement (TO specified)
ROLLROLLBACK statement
RSDCDESCRIBE statement (OUTPUT, RESULT SET specified)
RSFTFETCH statement (RESULT SET specified)
RSCLCLOSE statement (RESULT SET specified)
SAUHSET SESSION AUTHORIZATION statement
SETPREPARE statement
SINFUsed by system
SOPTUsed by system
SVLSUsed by system
THREUsed by system
THSUUsed by system
TRCKUsed by system
TRC2Used by system
TRSTUsed by system
TSCMUsed by system
TSRLTransfer Rollback#
TSPRTransfer Prepare#

#: Output only when the XA interface is used.

Table 14-12 SQL type codes

No.SQL statementSQL type code (hexadecimal)
1CREATE TABLE1038
2DROP TABLE103C
3ALTER TABLE1040
4CREATE INDEX1044
5DROP INDEX1048
6COMMENT ON TABLE104C
7COMMENT ON COLUMN1050
8CREATE SCHEMA1054
9DROP SCHEMA1058
10GRANT RDAREA105C
11GRANT SCHEMA1060
12GRANT ACCESS1064
13REVOKE RDAREA1068
14REVOKE SCHEMA106C
15REVOKE ACCESS1070
16CREATE VIEW1074
17DROP VIEW1078
18ALTER INDEX1079
19GRANT CONNECT1098
20GRANT DBA109C
21REVOKE CONNECT10A0
22REVOKE DBA10A4
23CREATE PROCEDURE10B0
24DROP PROCEDURE10B4
25ALTER PROCEDURE10B8
26CREATE TYPE10C0
27DROP DATA TYPE10C4
28CREATE FUNCTION10C8
29DROP FUNCTION10CC
30ALTER ROUTINE10E8
31LOCK statement2134
32SELECT statement4000, 4900, 4100, 4A04, 4204
33INSERT statement4108
34UPDATE statement4114
35DELETE statement411C
36ASSIGN LIST statement4224, 4324
37DROP LIST statement422C
38PURGE TABLE statement4184
39CALL PROCEDURE40BC
40GET DIAGNOSTICS40C0
41Assignment statement40C4
42FREE LOCATOR statement40C8

Table 14-13 Record format of a DAT-format file (global buffer pool statistical information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2Server name (SERVER)8
3Global buffer name (BUFFER NAME)16
4Statistics 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
5Number of buffer sectors in global buffer pool (BUFFER COUNT)Numeric10--
6Number of synchronization point dump pages (SYNC POINT)
7Maximum number of concurrently requested buffer sectors (BUFFER MAX)
8Update GETs count (UPDATE GET)
9Update buffer hits count (UPDATE HIT)
10Update buffer hit rate (UPDATE HIT RATIO)3Percentage
11Update buffer flushes count (UPDATE FLUSH)10--
12Reference GETs count (REF GET)
13Reference buffer hits count (REF HIT)
14Reference buffer hit rate (REF HIT RATIO)3Percentage
15Reference buffer flushes count (REF FLUSH)10--
16Real READs count (READ)
17Input waits count (WAIT READ)
18Real WRITEs count (WRITE)
19Output waits count (WAIT WRITE)
20Buffer 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)
21Buffer shortages count (BUFFER INSUFFICIENCY)
22Prefetch input pages count (PRRED)
23Prefetch hit pages count (PRHIT)
24Prefetch hit ratio (PRHIT RATIO)3Percentage
25Prefetch execution resources shortage count (PR INSUFFICIENCY)10--
26Global buffer hit ratio (BUFHIT RATIO)3Percentage
27Current reference buffers count (CUR REF BUFNUM)10--
28Current update buffers count (CUR UPDATE BUFNUM)
29Deferred write trigger update buffers count (TRG UPDATE BUFNUM)
30Synchronization points count (SYNC COUNT)
31Number of prefetch READ requests (PR READ REQ CNT)
32Number of READ requests for LOB global buffer (LOB READ REQ CNT)
33Number of WRITE requests for LOB global buffer (LOB WRITE REQ CNT)
34Batch input pages count for LOB global buffer (LOB BLK READ PGNUM)
35Batch output pages count for LOB global buffer (LOB BLK WRITE PGNUM)
36System-specific information (CACHE BUFFER INSUFFICIENCY)
37System-specific information (CACHE BUFFER FLUSH MAX)
38System-specific information (CACHE BUFFER FLUSH AVERAGE)
39Global buffer pool lock release waits count (entire buffer defined by a single pdbuffer) (LOCK WAIT CNT)Exponent representation
40Percentage of global buffer pool lock contention-release wait (entire buffer defined by a single pdbuffer) (LOCK WAIT RATIO)5% (up to 1 decimal place)
41System-specific information (SLEEP EXEC AVERAGE)10Exponent representation
42Percentage rate of spin loop (SPIN EXEC RATIO)5% (up to 1 decimal place)
43Average spin loop count (SPIN EXEC AVERAGE)10Exponent representation
44Global buffer pool lock exclusive time during synchronization point processing (entire buffer defined by a single pdbuffer) (SYNC LOCK)10--
45No. 44 in microseconds (SYNC LOCK(MICRO))6Value in seconds is not included
46Number 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--
47Take-over count of database write processing by reference request hit during synchronization point processing (REF ALTWRITE)
48Take-over count of database write processing by update request hit during synchronization point processing (UPD ALTWRITE)
49Sum of the contention-lock release wait times (LOCK WAIT TIME)#1, #2In seconds
50No. 49 in microseconds (LOCK WAIT TIME(MICRO))#1, #26Value in seconds is not included
51Sum 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2Server name (SERVER)8
3HiRDB file name (FILE NAME)#167
4RDAREA name (RDAREA NAME)30
5Statistics 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
6Synchronous READs count (SYNC READ)Numeric10--
7Synchronous WRITEs count (SYNC WRITE)
8System-specific information (AIO READ)
9Asynchronous WRITEs count (AIO WRITE)
10System-specific information (LIST IO)
11Opens count (OPEN)
12Closes count (CLOSE)
13I/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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2Server name (SERVER)8
3Log 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
4Cause (CAUSE)1Trigger: T
Pre-sync: P
Synchronization point: S
Database synchronization point: D
RDAREA synchronization point: R
5Pre-sync completion status (STATUS)#Pre-sync completed: P
Complete and terminated: E
6I/O parallel level (PARALLEL)Numeric10--
7Total number of pages output (OUT PAGE)Total number of pages output by deferred write processing for each cause
8WRITE count (DWEXEC)--
9Minimum unit value of WRITE (DWMIN)In seconds (rounded off)
10No. 9 in microseconds (DWMINM)6Value in seconds is not included.
11Maximum unit value of WRITE (DWMAX)10In seconds (rounded off)
12No. 11 in microseconds (DWMAXM)6Value in seconds is not included.
13Average unit value of WRITE (DWAVG)10In seconds (rounded off)
14No. 13 in microseconds (DWAVGM)6Value in seconds is not included.
15Total WRITE time (DWSUM)10In seconds (rounded off)
16No. 15 in microseconds (DWSUMM)6Value in seconds is not included.
17Parallel WRITE time (DWPARA)10In seconds (rounded off)
18No. 17 in microseconds (DWPARAM)6Value in seconds is not included.
19Execution time (DWTOTAL)10In seconds (rounded off)
20No. 19 in microseconds (DWTOTALM)6Value in seconds is not included.
21System-specific information (DWLSNGET)10In seconds (rounded off)
22System-specific information (DWLSNGETM)6Value in seconds is not included.
23System-specific information (DWSYNCLIST)10In seconds (rounded off)
24System-specific information (DWSYNCLISTM)6Value in seconds is not included.
25System-specific information (DWSEMOP)10In seconds (rounded off)
26System-specific information (DWSEMOPM)6Value 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Sequence number assigned to each connection in one front-end server
6SQL counter (SQL COUNTER)--
7Front-end server process ID (FES PROCESS ID)
8Operation code (OPERATION CODE)Character4For the operation codes, see Table 14-11.
9Section number (SECTION NO)Numeric5--
10SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-12.
11Server name (SERVER NAME)8--
12Syntax analysis start time (PARSE START(S))19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
13No. 12 in microseconds (PARSE START (MICRO))Numeric6Value in seconds is not included.
14Syntax analysis termination time (PARSE END(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
15No. 14 in microseconds (PARSE END (MICRO))Numeric6Value in seconds is not included.
16Syntax analysis execution time (PARSE EXEC TIME(SEC))10In seconds (value is rounded off)
17No. 16 in microseconds (PARSE EXEC TIME(MICRO))Value in seconds is included.
18Semantic analysis start time (SEMAN START(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
19No. 18 in microseconds (SEMAN START(MICRO))Numeric6Value in seconds is not included.
20Semantic analysis termination time (SEMAN END(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
21No. 20 in microseconds (SEMAN END(MICRO))Numeric6Value in seconds is not included.
22Semantic analysis execution time (SEMAN EXEC TIME(SEC))10In seconds (Value is rounded off.)
23No. 22 in microseconds (SEMAN EXEC TIME(MICRO))Value in seconds is included.
24Optimization start time (OPT START(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
25No. 24 in microseconds (OPT START(MICRO))Numeric6Value in seconds is not included.
26Optimization termination time (OPT END(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
27No. 26 in microseconds (OPT END(MICRO))Numeric6Value in seconds is not included.
28Optimization execution time (OPT EXEC TIME(SEC))10In seconds (value is rounded off)
29No. 28 in microseconds (OPT EXEC TIME(MICRO))Value in seconds is included.
30SQL object generation start time (SQLOBJ GEN START(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
31No. 30 in microseconds (SQLOBJ GEN START(MICRO))Numeric6Value in seconds is not included.
32SQL object generation termination time (SQLOBJ GEN END(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
33No. 32 in microseconds (SQLOBJ GEN END(MICRO))Numeric6Value in seconds is not included.
34SQL object generation execution time (SQLOBJ GEN EXEC TIME(SEC))10In seconds (value is rounded off)
35No. 34 in microseconds (SQLOBJ GEN EXEC TIME(MICRO))Value in seconds is included.
36SQL object registration start time (SQLOBJ ENT START(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
37No. 36 in microseconds (SQLOBJ ENT START(MICRO))Numeric6Value in seconds is not included.
38SQL object registration termination time (SQLOBJ ENT END(S))Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
39No. 38 in microseconds (SQLOBJ ENT END(MICRO))Numeric6Value in seconds is not included.
40SQL object registration execution time (SQLOBJ ENT EXEC TIME(SEC))10In seconds (value is rounded off)
41No. 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Sequence number assigned to each connection in one front-end server
6SQL counter (SQL COUNTER)--
7Front-end server process ID (FES PROCESS ID)
8Operation code (OPERATION CODE)Character4For operation codes, see Table 14-11.
9Section number (SECTION NO)Numeric5--
10SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-12.
11Server name (SERVER NAME)8--
12Dynamic optimization start time (DYNAMIC START)19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
13No. 12 in microseconds (START(MICRO))Numeric6Value in seconds is not included.
14Dynamic optimization termination time (DYNAMIC END)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
15No. 14 in microseconds (END(MICRO))Numeric6Value in seconds is not included.
16Dynamic optimization execution time (DYNAMIC EXEC TIME(SEC))10In seconds
17No. 16 in microseconds (DYNAMIC EXEC TIME(MICRO))Value in seconds is included.
18System-specific information (SUB SECTION COUNT)5--
19System-specific information (SUB SECTION NO)
20SQL object type (SQLOBJ KIND)Character1F: Front end
J: Sort/join
T: Base table scan
21Requested servers count (REQ SERVER)Numeric10--
22Allocated servers count (ALC SERVER)
23Allocated server name (ALC SERVER NAME)Character8
24RDAREA ID (RDAREA ID)Numeric10

Table 14-18 Record format of a DAT-format file (SQL object execution information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Sequence number assigned to each connection in one front-end server.
6SQL counter (SQL COUNTER)--
7Front-end server process ID (FES PROCESS ID)
8Server name (SERVER NAME)Character8
9Thread number (THREAD NO)Numeric5
10Operation code (OPERATION CODE)Character4For operation codes, see Table 14-11.
11Section number (SECTION NO)Numeric5--
12System-specific information (SUB SECTION NO)
13SQL code (SQLCODE)10
14SQL object execution start time (SQLOBJ START)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
15No. 14 in microseconds (START(MICRO))Numeric6Value in seconds is not included.
16SQL object execution termination time (SQLOBJ END)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
Format YYYY/MM/DD hh:mm:ss (when -y is specified)
17No. 16 in microseconds (END(MICRO))Numeric6Value in seconds is not included.
18SQL object execution time (SQLOBJ EXEC TIME(SEC))10In seconds (value is rounded off)
19No. 18 in microseconds (SQLOBJ EXEC TIME(MICRO))Value in seconds is included.
20Number of rows retrieved for SQL object (FETCH ROW)--
21Number of rows inserted for SQL object (INSERT ROW)
22Number of rows updated for SQL object (UPDATE ROW)
23Number of rows deleted for SQL object (DELETE ROW)
24Number of work table rows created (CREATE LIST)
25Number of work table rows deleted (DROP LIST)
26Send operations count (SEND)
27Length of send data (SEND DATA SIZE)
28Receive operations count (RECEIVE)
29Length of receive data (RECEIVE DATA SIZE)
30Number of times work tables were created (CREATE TMP LIST)
31Number of times work tables were deleted (DROP TMP LIST)
32HiRDB file output operations count (IOS OUTPUT)
33Buffer input operations count (BUFFER INPUT)
34SELECT APSL number (SEL APSL NO)
35SQL object type (SQLOBJ KIND)Character1F: Front end
J: Sort/join
T: Base table scan
36System-specific information (FOREIGN REQUEST COUNT)Numeric10--
37System-specific information (FOREIGN EXEC TIME)
38System-specific information (FOREIGN EXEC TIME(MICRO))
39System-specific information (FOREIGN FETCH ROW)
40System-specific information (FOREIGN INSERT ROW)
41System-specific information (FOREIGN UPDATE ROW)
42System-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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3Front-end server name (FES NAME)8
4Connection number (CONNECT NO)Numeric10
5Front-end server process ID (FES PROCESS ID)
6Server name (SERVER)Character8--
7System-specific information (SERVICE KIND)1--
8Operation code (OPERATION CODE)4For operation codes, see Table 14-11.
9Section number (SECTION NO)Numeric5--
10System-specific information (SUB SECTION NO)
11SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-12.
12SQL code (SQLCODE)Numeric10--
13Service start time (SERVICE START)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
14No. 13 in microseconds (SERVICE START(MICRO))Numeric6Value in seconds is not included.
15Service termination time (SERVICE END)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
16No. 15 in microseconds (SERVICE END(MICRO))Numeric6Value in seconds is not included.
17Service execution time (SERVICE EXEC TIME(SEC))10In seconds (value is rounded off)
18No. 17 in microseconds (SERVICE EXEC TIME(MICRO))Value in seconds is included.
19SQL object transfer start time (TRANSFER START)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
20No. 19 in microseconds (TRANSFER START(MICRO))Numeric6Value in seconds is not included.
21SQL object transfer end time (TRANSFER END)Character19Format:
MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
22No. 21 in microseconds (TRANSFER END(MICRO))Numeric6Value in seconds is not included.
23SQL object transfer time (TRANSFER TIME(SEC))10In seconds (value is rounded off)
24No. 23 in microseconds (TRANSFER TIME(MICRO))Value in seconds is included.
25SQL object transfer size (TRANSFER SIZE)10In 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)AttributeMaximum lengthRemarks
    1Host name (HOST)Character32--
    2UAP name (UAP NAME)
    3Module name (MODULE NAME)
    4Service name (SERVICE NAME)31
    5Front-end server name (FES NAME)8
    6Connection number (CONNECT NO)Numeric10Sequence number assigned to each connection in one front-end server
    7SQL counter (SQL COUNTER)--
    8Front-end server process ID (FES PROCESS ID)
    9Operation code (OPERATION CODE)Character4For operation codes, see Table 14-11.
    10Section number (SECTION NO)Numeric5--
    11SQL length (SQL LENGTH)10
    12SQL statement (SQL STRING)Character2MAn 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2UAP name (UAP NAME)
3Connect/disconnect time (CONNECT/DISCONNECT TIME)19Format: MM/DD/hh:mm:ss (when -y is omitted)
YYYY/MM/DD hh:mm:ss (when -y is specified)
4No. 3 in microseconds (CONNECT/DISCONNECT TIME(MICRO))Numeric6Value in seconds is not included.
5Front-end server process ID (FES PROCESS ID)10--
6SQL code (SQLCODE)
7Connect/disconnect status (CONNECT/DISCONNECT STATUS)Character1C: CONNECT
D: DISCONNECT
8Client 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)
9Privilege information (PRIVILEGE)C: CONNECT privilege
D: DBA privilege
blank: None (space: 0x20)
10Connect/disconnect type (CONNECT/DISCONNECT KIND)N: Normal (CONNECT/DISCONNECT)
S: set session authorization
I: Internal disconnect
T: Transaction resolution (OLTP only)
11Authorization identifier (USER NAME)30--
12Password (PASSWORD)Upon KFPA11560-E error (invalid password)
13CLT IP address (CLT IP ADDRESS)15Format: 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)AttributeMaximum lengthRemarks
1Host name (HOST)Character32--
2Server name (SERVER)8--
3Name of the RDAREA in which I/O operations occurred (RDAREA NAME)30--
4Sequence number of the HiRDB file constituting the RDAREA indicated in 3 (FILE NUMBER)Numeric2--
5Time the statistics log was acquired (LOG GET TIME)Character19Format: YYYY/MM/DD hh:mm:ss
6Page length of the HiRDB file (PAGE SIZE(K))Numeric6In kilobytes
7Reads count per acquisition interval (READ CNT)10--
8Number of reads for which time was measured among all reads that occurred within the acquisition interval (READ MEASURE CNT)--
9Time in microseconds for the reads for which time was measured (READ TIME(MICRO))Total value (SUM)12Includes the time in seconds.
10Maximum value (MAX)
11Writes count per acquisition interval (WRITE CNT)10--
12Number of writes for which time was measured among all writes that occurred within the acquisition interval (WRITE MEASURE CNT)--
13Time in microseconds for the writes for which time was measured (WRITE TIME(MICRO))Total value (SUM)12Includes the time in seconds.
14Maximum value (MAX)--
15Rank type (RANK KIND)Character2The 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.