14.4.3 Record formats of DAT-format files

Tables 14-5 through 14-22 show the record formats of the DAT-format files.

The following notes apply to these tables:

Note
For a HiRDB/Parallel Server, Nos. 73, 74, 79-102, 126, and 127 indicate the total value for all back-end servers.

1 For a HiRDB/Parallel Server, this is the total lock release wait time (including parallel processing) resulting in the transaction.

2 If the pdstbegin command is executed while being connected, or transaction processing is underway, statistical information is collected for the next connection or transaction, not the current connection or transaction.

3 For a HiRDB/Parallel Server, the value is for all back-end servers.

4 This is the total CPU time for all servers in the transaction.

5 If the information is output for each transaction, this is the cumulative CONNECT value.

Table 14-9 Record format of a DAT-format file (SQL statistical information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)
3SQL execution start time (START)14Format:
MM/DD/hh:mm:ss
4No. 3 in microseconds (START (MICRO))Numeric6Value in seconds is not included.
5SQL execution termination time (END)Character14Format:
MM/DD/hh:mm:ss
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)[Figure]
9SQL execution time (SQL EXEC TIME (MICRO))In microseconds (includes the value in seconds)
10Number of rows retrieved (FETCH ROW)[Figure]
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[Figure]
18Front-end server name (FES NAME)8
19Connection number (CONNECT NO)Numeric10Serial number assigned to each connection in one front-end server.
20SQL counter (SQL COUNTER)[Figure]
21Front-end server process ID (FES PROCESS ID)
22Operation code (OPERATION CODE)1Character4[Figure]
23Section number (SECTION NO)Numeric5
24SQL type code (SQL TYPE CODE)2Character4
25SQL code (SQLCODE)Numeric10
26Server name (SERVER NAME)Character8
27Number of times processing requests were issued to the foreign server (FOREIGN REQUEST COUNT)Numeric10[Figure]
28Foreign server processing time (FOREIGN EXEC TIME)In seconds
29No. 28 in microseconds (FOREIGN EXEC TIME(MICRO))In microseconds (includes the value in seconds)
30Number of rows retrieved on the foreign server (FOREIGN FETCH ROW)[Figure]
31Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)Numeric10[Figure]
32Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)Numeric10[Figure]
33Number of rows inserted in the foreign server (FOREIGN INSERT ROW)Numeric10[Figure]
34Number of rows updated on the foreign server (FOREIGN UPDATE ROW)Numeric10[Figure]
35Number of rows deleted on the foreign server (FOREIGN DELETE ROW)Numeric10[Figure]
Note
Nos. 27-30 and 33-35 are output when the HiRDB External Data Access facility is used. If this facility is not used, 0 or **** is output.

1 See Table 14-10 for the operation codes.

2 See Table 14-11 for the SQL type codes.

Table 14-10 Operation codes

Operation codeCorresponding SQL statements
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
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
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)
RNSCSET CONNECTION statement
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*
ALCRALLOCATE CURSOR statement
DSETDEALLOCATE PREPARE statement

* Output only when the XA interface is used.

Table 14-11 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
18GRANT CONNECT1098
19GRANT DBA109C
20REVOKE CONNECT10A0
21REVOKE DBA10A4
22CREATE ALIAS10A8
23DROP ALIAS10AC
24CREATE PROCEDURE10B0
25DROP PROCEDURE10B4
26ALTER PROCEDURE10B8
27CREATE TYPE10C0
28DROP DATA TYPE10C4
29CREATE FUNCTION10C8
30DROP FUNCTION10CC
31ALTER ROUTINE10E8
32LOCK statement2134
33SELECT statement4000, 4900, 4100, 4A04, 4204
34INSERT statement4108
35UPDATE statement4114
36DELETE statement411C
37ASSIGN LIST statement4224, 4324
38DROP LIST statement422C
39PURGE TABLE statement4184
40CALL PROCEDURE40BC
41GET DIAGNOSTICS40C0
42Assignment statement40C4
43FREE LOCATOR statement40C8

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

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2Server name (SERVER)8
3Global buffer name (BUFFER NAME)16
4Statistics log acquisition time (LOG GET TIME)14Format:
MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified
5Number of buffer sectors in global buffer pool (BUFFER COUNT)Numeric10[Figure]
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[Figure]
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[Figure]
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)
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[Figure]
26Global buffer hit ratio (BUFHIT RATIO)3Percentage
27Current reference buffers count (CUR REF BUFNUM)10[Figure]
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)
39System-specific information (LOCK WAIT CNT)Exponent representation
40Percentage of lock contention-release wait (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
44Buffer pool lock exclusive time during synchronization point processing10[Figure]
45No. 44 in microseconds6Value in seconds is not included
46Number of buffers processed within buffer pool lock exclusive time during synchronization point processing10[Figure]
47Take-over count of database write processing by reference request hit during synchronization point processing
48Take-over count of database write processing by update request hit during synchronization point processing

Table 14-13 Record format of a DAT-format file (statistical information on HiRDB files for database manipulation)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2Server name (SERVER)8
3HiRDB file name (FILE NAME)167
4RDAREA name (RDAREA NAME)30
5Statistics log acquisition time (LOG GET TIME)14Format:
MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified
6Synchronous READs count (SYNC READ)Numeric10[Figure]
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)

Table 14-14 Record format of a DAT-format file (deferred write processing statistical information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2Server name (SERVER)8
3Log acquisition time (LOG GET TIME)11Format:
MM/DD/hh:mm:ss
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[Figure]
7Total number of pages output (OUT PAGE)Total number of pages output by deferred write processing for each cause
8WRITE count (DWEXEC)[Figure]
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. 17 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-15 Record format of a DAT-format file (SQL static optimization information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Serial number assigned to each connection in one front-end server
6SQL counter (SQL COUNTER)[Figure]
7Front-end server process ID (FES PROCESS ID)
8Operation code (OPERATION CODE)Character4For the operation codes, see Table 14-10.
9Section number (SECTION NO)Numeric5[Figure]
10SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-11.
11Server name (SERVER NAME)8[Figure]
12Syntax analysis start time (PARSE START(S))14Format:
MM/DD/hh:mm:ss
13No. 12 in microseconds (PARSE START (MICRO))Numeric6Value in seconds is not included.
14Syntax analysis termination time (PARSE END(S))Character14Format:
MM/DD/hh:mm:ss
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))Character14Format:
MM/DD/hh:mm:ss
19No. 18 in microseconds (SEMAN START(MICRO))Numeric6Value in seconds is not included.
20Semantic analysis termination time (SEMAN END(S))Character14Format:
MM/DD/hh:mm:ss
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))Character14Format:
MM/DD/hh:mm:ss
25No. 24 in microseconds (OPT START(MICRO))Numeric6Value in seconds is not included.
26Optimization termination time (OPT END(S))Character14Format:
MM/DD/hh:mm:ss
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))Character14Format:
MM/DD/hh:mm:ss
31No. 30 in microseconds (SQLOBJ GEN START(MICRO))Numeric6Value in seconds is not included.
32SQL object generation termination time (SQLOBJ GEN END(S))Character14Format:
MM/DD/hh:mm:ss
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))Character14Format:
MM/DD/hh:mm:ss
37No. 36 in microseconds (SQLOBJ ENT START(MICRO))Numeric6Value in seconds is not included.
38SQL object registration termination time (SQLOBJ ENT END(S))Character14Format:
MM/DD/hh:mm:ss
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-16 Record format of a DAT-format file (SQL dynamic optimization information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Serial number assigned to each connection in one front-end server
6SQL counter (SQL COUNTER)[Figure]
7Front-end server process ID (FES PROCESS ID)
8Operation code (OPERATION CODE)Character4For operation codes, see Table 14-10.
9Section number (SECTION NO)Numeric5[Figure]
10SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-11.
11Server name (SERVER NAME)8[Figure]
12Dynamic optimization start time (DYNAMIC START)14Format:
MM/DD/hh:mm:ss
13No. 12 in microseconds (START(MICRO))Numeric6Value in seconds is not included.
14Dynamic optimization termination time (DYNAMIC END)Character14Format:
MM/DD/hh:mm:ss
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[Figure]
19System-specific information (SUB SECTION NO)
20SQL object type (SQLOBJ KIND)Character1F: Front end
H: Foreign table access
J: Sort/join
T: Base table scan
21Requested servers count (REQ SERVER)Numeric10[Figure]
22Allocated servers count (ALC SERVER)
23Allocated server name (ALC SERVER NAME)Character8
24RDAREA ID (RDAREA ID)Numeric10

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

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10Serial number assigned to each connection in one front-end server.
6SQL counter (SQL COUNTER)[Figure]
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-10.
11Section number (SECTION NO)Numeric5[Figure]
12System-specific information (SUB SECTION NO)
13SQL code (SQLCODE)10
14SQL object execution start time (SQLOBJ START)Character14Format:
MM/DD/hh:mm:ss
15No. 14 in microseconds (START(MICRO))Numeric6Value in seconds is not included.
16SQL object execution termination time (SQLOBJ END)Character14Format:
MM/DD/hh:mm:ss
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)[Figure]
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
36Number of times processing requests were issued to foreign server (FOREIGN REQUEST COUNT)Numeric10[Figure]
37Foreign server processing time (FOREIGN EXEC TIME)In seconds
38No. 37 in microseconds (FOREIGN EXEC TIME(MICRO))In microseconds (includes the value in seconds)
39Number of rows retrieved on the foreign server (FOREIGN FETCH ROW)[Figure]
40Number of rows inserted in the foreign server (FOREIGN INSERT ROW)[Figure]
41Number of rows updated on the foreign server (FOREIGN UPDATE ROW)[Figure]
42Number of rows deleted on the foreign server (FOREIGN DELETE ROW)[Figure]
Note
Nos. 36-42 are output when the HiRDB External Data Access facility is used. If this facility is not used, 0 or **** is output.

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

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
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[Figure]
7System-specific information (SERVICE KIND)1[Figure]
8Operation code (OPERATION CODE)4For operation codes, see Table 14-10.
9Section number (SECTION NO)Numeric5[Figure]
10System-specific information (SUB SECTION NO)
11SQL type code (SQL TYPE CODE)Character4For SQL type codes, see Table 14-11.
12SQL code (SQLCODE)Numeric10[Figure]
13Service start time (SERVICE START)Character14Format:
MM/DD/hh:mm:ss
14No. 13 in microseconds (SERVICE START(MICRO))Numeric6Value in seconds is not included.
15Service termination time (SERVICE END)Character14Format:
MM/DD/hh:mm:ss
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)Character14Format:
MM/DD/hh:mm:ss
20No. 19 in microseconds (TRANSFER START(MICRO))Numeric6Value in seconds is not included.
21SQL object transfer end time (TRANSFER END)Character14Format:
MM/DD/hh:mm:ss
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-19 Record format of a DAT-format file (SQL statement statistical information)

    No.Field name (title bar)AttributeMaximum lengthRemarks
    1Host name (HOST)Character32[Figure]
    2UAP name (UAP NAME)
    3Module name (MODULE NAME)
    4Service name (SERVICE NAME)31
    5Front-end server name (FES NAME)8
    6Connection number (CONNECT NO)Numeric10Serial number assigned to each connection in one front-end server
    7SQL counter (SQL COUNTER)[Figure]
    8Front-end server process ID (FES PROCESS ID)
    9Operation code (OPERATION CODE)Character4For operation codes, see Table 14-10.
    10Section number (SECTION NO)Numeric5[Figure]
    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 history statistics are output only when the operation code is one of the following: AUXI, OPN2, CALL, AUX2, or SET.

Table 14-20 Record format of a DAT-format file (CONNECT/DISCONNECT statistical information)

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)
3Connect/disconnect time (CONNECT/DISCONNECT TIME)14Format: MM/DD/hh:mm:ss
4No. 3 in microseconds (CONNECT/DISCONNECT TIME(MICRO))Numeric6Value in seconds is not included.
5Front-end server process ID (FES PROCESS ID)10[Figure]
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
9: Distributed client
0: Utility
#: Other
blank: None (space: 0[Figure]20)
9Privilege information (PRIVILEGE)C: CONNECT privilege
D: DBA privilege
blank: None (space: 0[Figure]20)
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[Figure]
12Password (PASSWORD)Upon KFPA11560-E error (invalid password)
13CLT IP address (CLT IP ADDRESS)15Format: XXX.XXX.XXX.XXX

Table 14-21 Foreign server operation statistical information

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2Server name (SERVER NAME)8
3Foreign server ID (FOREIGN SERVER ID)Numeric10[Figure]
4Foreign server name (FOREIGN SERVER)Character30
5DBMS type of the foreign server (DBMS KIND)1P: HiRDB
R: XDM/RD
O: Oracle
I: DB2
6Number of times connection was established (CONNECT COUNT)Numeric10[Figure]
7Number of connection errors (CONNECT ERROR COUNT)
8Number of connection errors due to number of licenses exceeded (LICENSE OVER COUNT)
9Commits count (COMMIT COUNT)
10Rollbacks count (ROLLBACK COUNT)
11Number of rows retrieved (FETCH ROW)
12Information used by the system (DBA CONNECT COUNT)
13Information used by the system (DBA DISCONNECT COUNT)
14Information used by the system (DBA PREPARE COUNT)
15Information used by the system (DBA OPEN COUNT)
16Information used by the system (DBA FETCH COUNT)
17Information used by the system (DBA CLOSE COUNT)
18Information used by the system (DBA EXECUTEIMD COUNT)
19Information used by the system (DBA EXECUTE COUNT)
20Information used by the system (DBA LOCKTABLE COUNT)
21Foreign server processing time (FOREIGN EXEC TIME)In seconds
22No. 21 in microseconds (FOREIGN EXEC TIME(MICRO))In microseconds (includes the value in seconds)
23Foreign server processing request count (FOREIGN EXEC COUNT)[Figure]
24Number of rows inserted in the foreign server (FOREIGN INSERT ROW)[Figure]
25Number of rows updated on the foreign server (FOREIGN UPDATE ROW)[Figure]
26Number of rows deleted on the foreign server (FOREIGN DELETE ROW)[Figure]

Table 14-22 Foreign server utilization statistical information

No.Field name (title bar)AttributeMaximum lengthRemarks
1Host name (HOST)Character32[Figure]
2UAP name (UAP NAME)30
3Service name (SERVICE NAME)31
4Front-end server name (FES NAME)8
5Connection number (CONNECT NO)Numeric10[Figure]
6SQL counter (SQL COUNTER)
7Front-end server's process ID (FES PROCESS ID)
8Back-end server name (BES NAME)Character8[Figure]
9Back-end server's process ID (BES PROCESS ID)Numeric10[Figure]
10Thread number (THREAD ID)
11Section number (SECTION NO)5
12Information used by the system (SUB SECTION NO)
13Foreign server ID (FOREIGN SERVER ID)10
14Foreign server name (FOREIGN SERVER)Character30[Figure]
15SQL type code (SQL TYPE CODE)14
16Array FETCH count on the foreign server (ARRAY FETCH ROW)Numeric10[Figure]
17FETCH count on the foreign server (ARRAY FETCH COUNT)
18Number of rows retrieved on the foreign server (FETCH ROW)
19SQL execution start time at the foreign server (EXEC START)Character14Format: MM/DD/hh:mm:ss
20No. 19 in microseconds (START(MICRO))Numeric6Value in seconds is not included.
21SQL execution end time at the foreign server (EXEC END)Character14Format: MM/DD/hh:mm:ss
22No. 21 in microseconds (END(MICRO))Numeric6Value in seconds is not included.
23SQL execution time at the foreign server (EXEC TIME(SEC))10In seconds
24No. 23 in microseconds (EXEC TIME(MICRO))In microseconds (includes the value in seconds)
25Foreign server processing request count (EXEC COUNT)[Figure]
26Number of rows inserted in the foreign server (FOREIGN INSERT ROW)[Figure]
27Number of rows updated on the foreign server (FOREIGN UPDATE ROW)[Figure]
28Number of rows deleted on the foreign server (FOREIGN DELETE ROW)[Figure]
1 For details about SQL TYPE CODE, see Table 14-11.