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

The following notes apply to these tables:

• The title bars shown in the tables are displayed when the -b option is specified. For system activity statistical information, three title bar lines are displayed at the beginning of the file; in the case of all other statistical information types, one title bar line is displayed at the beginning of the file.
• The length of the title bar for each field is not included in the maximum length displayed in the tables. You should take this into account when you process data in DAT-format files that includes the title bars.
• In the Remarks column, means that there are no remarks.
• If a data item's attribute is character string, the maximum length of the data does not include the double quotation marks ("") that enclose the character string data. If the utility detects uneditable data for an item whose attribute is numeric, it displays 10 asterisks (**********), which may exceed the maximum length (of 3, 5, or 6 bytes).
  

  Table 14-5 Record format of a DAT-format file (system activity statistical information (1))

  No.	Field name (title bar)			Attribute	Maximum length	Remarks
  1	Host name (HOST)			Character	32
  2	Server name (SERVER)				8	******** for overall statistical information
  3	Edit time (START)				11	Format MM/DD/hh:mm
  4	Schedule information (SCHEDULE)	Length of schedule queue (QUEUE LEN(SCH))	Number of occurrences (FREQ)	Numeric	10
  5			Maximum value (MAX)
  6			Minimum value (MIN)
  7			Average value (AVG)
  8		Scheduled message length (MESSAGE LEN)	Number of occurrences (FREQ)
  9			Maximum value (MAX)			In bytes
  10			Minimum value (MIN)
  11			Average value (AVG)
  12	Process information (PROCESS)	Server abnormal terminations count (SERVER ABORT)	Number of occurrences (FREQ)	Numeric	10	Processing information continues with Nos. 174-177.
  13		Server abnormal terminations count for HiRDB internal server (SYSTEM SERVER ABORT)	Number of occurrences (FREQ)
  14		Number of processes (PROCESS COUNT)	Maximum value (MAX)
  15			Minimum value (MIN)
  16			Average value (AVG)
  17	Transaction information (TRANSACTION)	Commits count (COMMIT)	Number of occurrences (FREQ)	Numeric	10
  18		Rollbacks count (ROLLBACK)	Number of occurrences (FREQ)
  19	Name server information (NAME)	System-specific information (CACHE HIT)	Number of occurrences (FREQ)	Numeric	10
  20		System-specific information (LOCAL HIT)	Number of occurrences (FREQ)
  21		System-specific information (LOOK UP)	Number of occurrences (FREQ)
  22	RPC information (RPC)	System-specific information (RESPONSE TIME)	Number of occurrences (FREQ)	Numeric	10	RPC information for users is listed in Nos. 178-199 and 252-259.
  23			Maximum value (MAX)
  24			Minimum value (MIN)
  25			Average value (AVG)
  26		System-specific information (USER SERVICE TIME)	Number of occurrences (FREQ)
  27			Maximum value (MAX)
  28			Minimum value (MIN)
  29			Average value (AVG)
  30		System-specific information (TIME OUT)	Number of occurrences (FREQ)
  31		System-specific information (ERROR)	Number of occurrences (FREQ)
  32		System-specific information (SEND)	Number of occurrences (FREQ)
  33		System-specific information (RECEIVE)	Number of occurrences (FREQ)
  34	Lock information (LOCK)	Lock release wait time (WAIT TIME)	Number of occurrences (FREQ)	Numeric	10
  35			Maximum value (MAX)			In milliseconds
  36			Minimum value (MIN)
  37			Average value (AVG)
  38		Lock queue length (number of users) (QUEUE LEN)	Number of occurrences (FREQ)
  39			Maximum value (MAX)
  40			Minimum value (MIN)
  41			Average value (AVG)
  42		Deadlocks count (DEADLOCK)	Number of occurrences (FREQ)
  43		Utilization factor of locked resources management table (USE LOCK TABLE)	Number of occurrences (FREQ)
  44			Maximum value (MAX)		3	Percentage
  45			Minimum value (MIN)
  46			Average value (AVG)
  47	Shared memory information (SHARED MEMORY)	System-specific information (STATIC GET SIZE)	Number of occurrences (FREQ)	Numeric	10
  48			Maximum value (MAX)			In bytes
  49			Minimum value (MIN)
  50			Average value (AVG)
  51		System-specific information (STATIC POOL SIZE)	Number of occurrences (FREQ)
  52			Maximum value (MAX)			In bytes
  53			Minimum value (MIN)
  54			Average value (AVG)
  55		System-specific information (DYNAMIC GET SIZE)	Number of occurrences (FREQ)
  56			Maximum value (MAX)			In bytes
  57			Minimum value (MIN)
  58			Average value (AVG)
  59		System-specific information (DYNAMIC POOL SIZE)	Number of occurrences (FREQ)
  60			Maximum value (MAX)			In bytes
  61			Minimum value (MIN)
  62			Average value (AVG)
  63		Size of shared memory allocated for server or for HiRDB internal server (SEGMENT SIZE)	Average value (AVG)			In KB
  64		Shared static memory allocation size (STATIC SIZE)	Average value (AVG)
  65		Shared dynamic memory allocation size (DYNAMIC SIZE)	Average value (AVG)
  66		Shared memory allocation size for global buffer (SIZE FOR BUFFER)	Average value (AVG)
  67	Synchronization point information (SYNC POINT)	Synchronization point dump collection time (GET INTERVAL TIME)	Number of occurrences (FREQ)	Numeric	10
  68			Maximum value (MAX)			In milliseconds
  69			Minimum value (MIN)
  70			Average value (AVG)
  71		Synchronization point dump interval (GET TIME)	Number of occurrences (FREQ)
  72			Maximum value (MAX)			In milliseconds
  73			Minimum value (MIN)
  74			Average value (AVG)
  75	Log information (LOG)	Buffer-fulls count (BUFFER FULL)	Number of occurrences (FREQ)	Numeric	10
  76		Waits count due to no current buffer (WAIT THREAD)	Number of occurrences (FREQ)
  77		Output block length (OUTPUT BLOCK LEN)	Number of occurrences (FREQ)
  78			Maximum value (MAX)			In bytes
  79			Minimum value (MIN)
  80			Average value (AVG)
  81		Non-bus data length (NOT BUS LEN)	Number of occurrences (FREQ)
  82			Maximum value (MAX)			In bytes
  83			Minimum value (MIN)
  84			Average value (AVG)
  85		Number of buffer sectors waiting for I/O (WAIT BUFFER FOR IO)	Number of occurrences (FREQ)
  86			Maximum value (MAX)
  87			Minimum value (MIN)
  88			Average value (AVG)
  89		Number of file write operations (WRITE TO FILE)	Number of occurrences (FREQ)
  90		Write errors count (WRITE ERROR)	Number of occurrences (FREQ)
  91		Log file swapping time (LOG FILE SWAP TIME)	Number of occurrences (FREQ)
  92			Maximum value (MAX)			In milliseconds
  93			Minimum value (MIN)
  94			Average value (AVG)
  95		Log input data length (LOG INPUT DATA)	Number of occurrences (FREQ)
  96			Maximum value (MAX)			In bytes
  97			Minimum value (MIN)
  98			Average value (AVG)
  99		Number of file read operations (READ FROM FILE)	Number of occurrences (FREQ)
  100		Read errors count (READ ERROR)	Number of occurrences (FREQ)

  Table 14-6 Record format of a DAT-format file (system activity statistical information (2))

  No.	Field name (title bar)			Attribute	Maximum length	Remarks
  101	Dictionary information (DICTIONARY)	Number of table definition information acquisition requests (TBL-DEF GET REQ)	Number of occurrences (FREQ)	Numeric	10	Dictionary information is continued to Nos. 200-251 and 260-267.
  102		Table definition information buffer hits count (TABLE CACHE HIT)	Number of occurrences (FREQ)
  103		Number of definition information items in table definition information buffer (CASHED TBL-DEF)	Number of occurrences (FREQ)
  104			Maximum value (MAX)
  105			Minimum value (MIN)
  106			Average value (AVG)
  107		Size of table definition information buffer used per table definition information item (USE TBL-DEF SIZE)	Number of occurrences (FREQ)
  108			Maximum value (MAX)			In bytes
  109			Minimum value (MIN)
  110			Average value (AVG)
  111		Size of area used by table definition information buffer (CACHED TBL-DEF SIZE)	Number of occurrences (FREQ)
  112			Maximum value (MAX)			In bytes
  113			Minimum value (MIN)
  114			Average value (AVG)
  115		Table access privilege information acquisitions count (ACCESS PRIV CHECK)	Number of occurrences (FREQ)
  116		Table access privilege information buffer hits count (CACHE HIT(ACCESS))	Number of occurrences (FREQ)
  117		User privilege information acquisition requests (CON/DBA DEF GET REQ)	Number of occurrences (FREQ)
  118		User privilege information buffer hits count (CON/DBA CACHE HIT)	Number of occurrences (FREQ)
  119		Number of users using the user privilege information buffer (CON/DBA CACHED USER)	Number of occurrences (FREQ)
  120			Maximum value (MAX)
  121			Minimum value (MIN)
  122			Average value (AVG)
  123		Length of communication with dictionary server (DIC TRANS DATA LEN)	Number of occurrences (FREQ)
  124			Maximum value (MAX)			In bytes
  125			Minimum value (MIN)
  126			Average value (AVG)
  127		Dictionary server communications count (TRANS)	Number of occurrences (FREQ)
  128		Number of view analysis information acquisition requests (VIEW DEF GET REQ)	Number of occurrences (FREQ)
  129		View analysis information buffer hits count (VIEW DEF CACHE HIT)	Number of occurrences (FREQ)
  130		Number of view analysis information items in view analysis information buffer (VIEW CACHED DEF)	Number of occurrences (FREQ)
  131		Size of view analysis information buffer used per view analysis information item (USED VIEW SIZE)	Number of occurrences (FREQ)
  132			Maximum value (MAX)			In bytes
  133			Minimum value (MIN)
  134			Average value (AVG)
  135		Length of view analysis information buffer used (VIEW CACHE SIZE)	Number of occurrences (FREQ)
  136			Maximum value (MAX)			In bytes
  137			Minimum value (MIN)
  138			Average value (AVG)
  139		Length of view analysis information resulting in buffer miss (CACHE MISS VIEW SIZE)	Number of occurrences (FREQ)
  140			Maximum value (MAX)			In bytes
  141			Minimum value (MIN)
  142			Average value (AVG)
  143	SQL object information for single server, front-end server, back-end server, or dictionary server (FES-BES-DIC(SDS) INFORMATION)	Number of SQL object acquisition requests (SQLOBJ GET REQ)	Number of occurrences (FREQ)
  144		SQL object buffer hits count (SQLOBJ CACHE HIT)	Number of occurrences (FREQ)
  145		Number of SQL objects in SQL object buffer (CACHED SQLOBJ)	Number of occurrences (FREQ)
  146			Maximum value (MAX)
  147			Minimum value (MIN)
  148			Average value (AVG)
  149		Total length of SQL objects in SQL object buffer (CACHED SQLOBJ SIZE)	Number of occurrences (FREQ)
  150			Maximum value (MAX)			In KB
  151			Minimum value (MIN)
  152			Average value (AVG)
  153		Number of SQL objects swapped out of SQL object buffer (SWAP OUT SQLOBJ)	Number of occurrences (FREQ)
  154		SQL object length (SQLOBJ LEN)	Number of occurrences (FREQ)
  155			Maximum value (MAX)			In bytes
  156			Minimum value (MIN)
  157			Average value (AVG)
  158		Number of acquisition requests for stored procedure objects (STROBJ GET REQ)	Number of occurrences (FREQ)
  159		SQL object buffer hits count for stored procedure objects (STROBJ CACHE HIT)	Number of occurrences (FREQ)
  160		Number of stored procedure objects in SQL object buffer (CACHED STROBJ)	Number of occurrences (FREQ)
  161			Maximum value (MAX)
  162			Minimum value (MIN)
  163			Average value (AVG)
  164		Total length of stored procedure objects in SQL object buffer (CACHED STROBJ SIZE)	Number of occurrences (FREQ)
  165			Maximum value (MAX)	In KB
  166			Minimum value (MIN)
  167			Average value (AVG)
  168		Number of stored procedure objects swapped out of SQL object buffer (SWAP OUT STROBJ)	Number of occurrences (FREQ)
  169		Stored procedure object length (STROBJ LEN)	Number of occurrences (FREQ)
  170			Maximum value (MAX)	In bytes
  171			Minimum value (MIN)
  172			Average value (AVG)
  173		Number of times stored procedure objects were recompiled (STROBJ RECOMPILE)	Number of occurrences (FREQ)
  174	Process information (PROCESS)	Number of server processes under service execution (SERVICE COUNT)	Maximum value (MAX)	Numeric	10
  175			Minimum value (MIN)
  176			Average value (AVG)
  177		Number of service requests exceeding maximum number of startup processes (REQUEST OVER)	Number of requests (FREQ)
  178	RPC information (RPC)	Service response time for local unit's servers (RESPONSE ON OWN UNIT)	Number of occurrences (FREQ)	Numeric	10
  179			Maximum value (MAX)			In 100 microseconds
  180			Minimum value (MIN)
  181			Average value (AVG)
  182		Service response time for remote unit's servers (RESPONSE TO OTHER UNIT)	Number of occurrences (FREQ)
  183			Maximum value (MAX)			In 100 microseconds
  184			Minimum value (MIN)
  185			Average value (AVG)
  186		Execution time per service from local unit's servers (EXEC TIME ON OWN UNIT)	Number of occurrences (FREQ)
  187			Maximum value (MAX)			In 100 microseconds
  188			Minimum value (MIN)
  189			Average value (AVG)
  190		Execution time per service from remote unit's servers (EXEC TIME FROM OTHER UNIT)	Number of occurrences (FREQ)
  191			Maximum value (MAX)			In 100 microseconds
  192			Minimum value (MIN)
  193			Average value (AVG)
  194		Number of SENDs to local process (SEND TO OWN PRCS)	Number of occurrences (FREQ)
  195		Number of SENDs to other processes on local unit (SEND TO OTHER PRCS)	Number of occurrences (FREQ)
  196		Number of SENDs to remote unit (SEND TO OTHER UNIT)	Number of occurrences (FREQ)
  197		Number of RECEIVEs from local process (RECEIVE FROM OWN PRCS)	Number of occurrences (FREQ)
  198		Number of RECEIVEs from other processes on local unit (RECEIVE FROM OTHER PRCS)	Number of occurrences (FREQ)
  199		Number of RECEIVEs from remote unit (RECEIVE FROM OTHER UNIT)	Number of occurrences (FREQ)

  Table 14-7 Record format of a DAT-format file (system activity statistical information (3))

  No.	Field name (title bar)			Attribute	Maximum length	Remarks
  200	Dictionary information (DICTIONARY)	Number of type definition information acquisition requests (TYPE-DEF GET REQ)	Number of occurrences (FREQ)	Numeric	10
  201		User-defined type information buffer hits count (TYPE-DEF CACHE HIT)	Number of occurrences (FREQ)
  202		Number of type definition information items in user-defined type information buffer (CACHED TYPE-DEF)	Number of occurrences (FREQ)
  203			Maximum value (MAX)
  204			Minimum value (MIN)
  205			Average value (AVG)
  206		Size of area used by user-defined type information buffer per type definition information item (TYPE-DEF CACHE SIZE)	Number of occurrences (FREQ)
  207			Maximum value (MAX)			In bytes
  208			Minimum value (MIN)
  209			Average value (AVG)
  210		Total size of area used by user-defined type information buffer (TYPE-DEF CACHE TOTAL SIZE)	Number of occurrences (FREQ)
  211			Maximum value (MAX)			In bytes
  212			Minimum value (MIN)
  213			Average value (AVG)
  214		Size of user-defined type information buffer allocated (TYPE-DEF CACHE ALLOC SIZE)	Number of occurrences (FREQ)
  215			Maximum value (MAX)			In bytes
  216			Minimum value (MIN)
  217			Average value (AVG)
  218		Number of routine definition information acquisition requests (RTN-DEF GET REQ)	Number of occurrences (FREQ)
  219		Routine definition information buffer hits count (RTN-DEF CACHE HIT)	Number of occurrences (FREQ)
  220		Number of routine definition information items in routine definition information buffer (CACHED RTN-DEF)	Number of occurrences (FREQ)
  221			Maximum value (MAX)
  222			Minimum value (MIN)
  223			Average value (AVG)
  224		Size of area used by routine definition information buffer per routine definition information item (RTN-DEF CACHE SIZE)	Number of occurrences (FREQ)
  225			Maximum value (MAX)			In bytes
  226			Minimum value (MIN)
  227			Average value (AVG)
  228		Total size of area used by routine definition information buffer (RTN-DEF CACHE TOTAL SIZE)	Number of occurrences (FREQ)
  229			Maximum value (MAX)			In bytes
  230			Minimum value (MIN)
  231			Average value (AVG)
  232		Size of routine definition information buffer allocated (RTN-DEF CACHE ALLOC SIZE)	Number of occurrences (FREQ)
  233			Maximum value (MAX)			In bytes
  234			Minimum value (MIN)
  235			Average value (AVG)
  236		Number of routine definition acquisition requests for plug-in-provided functions (PLG-RTN GET REQ)	Number of occurrences (FREQ)
  237		Routine definition information buffer hits count for plug-in provided functions (PLG-RTN CACHE HIT)	Number of occurrences (FREQ)
  238		Number of registry information acquisition requests (REGISTRY GET REQ)	Number of occurrences (FREQ)
  239		Registry information buffer hits count (REGISTRY CACHE HIT)	Number of occurrences (FREQ)
  240		Number of registry information items in registry information buffer (CACHED REGISTRY-DEF)	Number of occurrences (FREQ)
  241			Maximum value (MAX)
  242			Minimum value (MIN)
  243			Average value (AVG)
  244		Size of registry information buffer per registry information item (REGISTRY CACHE SIZE)	Number of occurrences (FREQ)
  245			Maximum value (MAX)			In bytes
  246			Minimum value (MIN)
  247			Average value (AVG)
  248		Total size of area used by registry information buffer (REGISTRY CACHE TOTAL SIZE)	Number of occurrences (FREQ)
  249			Maximum value (MAX)			In bytes
  250			Minimum value (MIN)
  251			Average value (AVG)
  252	RPC information (RPC)	Number of HiRDB-reserved ports used (REGISTERED PORTS)	Number of occurrences (FREQ)	Numeric	10
  253			Maximum value (MAX)
  254			Minimum value (MIN)
  255			Average value (AVG)
  256		Number of ports automatically assigned by OS when HiRDB-reserved ports ran out (ASSIGNED PORTS)	Number of occurrences (FREQ)
  257			Maximum value (MAX)
  258			Minimum value (MIN)
  259			Average value (AVG)
  260	Dictionary information (DICTIONARY)	Directory-registered user authentication time (DIRECTORY USER CHECK TIME)	Number of occurrences (FREQ)	Numeric	10
  261			Maximum value (MAX)			In microseconds
  262			Minimum value (MIN)
  263			Average value (AVG)
  264		Group checking time (GROUP CHECK TIME)	Number of occurrences (FREQ)
  265			Maximum value (MAX)			In microseconds
  266			Minimum value (MIN)
  267			Average value (AVG)

  Table 14-8 Record format of a DAT-format file: UAP statistical information

  No.	Field name (title bar)	Attribute	Maximum length	Remarks
  1	Host name (HOST)	Character	32
  2	UAP name (UAP NAME)
  3	UAP or transaction execution start time (START)	Character	14	Format: MM/DD/hh:mm:ss
  4	No. 3 in microseconds (START (MICRO))	Numeric	6	Value in seconds is not included.
  5	UAP or transaction execution termination time (END)	Character	14	Format: MM/DD/hh:mm:ss
  6	No. 5 in microseconds (END (MICRO))	Numeric	6	Value in seconds is not included.
  7	Termination status (STATUS)	Character	1	N: Normal termination E: Termination after rollback
  8	UAP or transaction execution time (UAP EXEC TIME(S))	Numeric	10	In seconds (value less than a second is rounded)
  9	Size of table definition information buffer used (CACHE SIZE)			In bytes
  10	Number of SQL object acquisition requests (REQ (SQL))
  11	SQL object buffer hits count (HITS (SQL))
  12	SQL object creations count (CREATE)
  13	Maximum size of SQL object created (SQL MAX)			In bytes
  14	COMMIT statement executions count (COMMIT)
  15	ROLLBACK statement executions count (ROLLBACK)
  16	Number of rows actually retrieved by FETCH or SELECT statement (FETCH ROW)
  17	Number of rows actually deleted by DELETE statement (DELETE ROW)
  18	Number of rows actually inserted by INSERT statement (INSERT ROW)
  19	Number of rows actually updated by UPDATE statement (UPDATE ROW)
  20	SQL statement preprocessings count (SET)
  21	OPEN statement executions count (OPEN)
  22	FETCH statement executions count (FETCH)
  23	CLOSE statement executions count (CLOSE)
  24	DESCRIBE statement executions count (DESCRIBE)
  25	SELECT statement executions count (SELECT)
  26	INSERT statement executions count (INSERT)
  27	UPDATE statement executions count (UPDATE)
  28	DELETE statement executions count (DELETE)
  29	LOCK statement executions count (LOCK)
  30	CREATE TABLE executions count (CREATE TABLE)
  31	ALTER TABLE executions count (ALTER TABLE)
  32	DROP TABLE executions count (DROP TABLE)
  33	CREATE INDEX executions count (CREATE INDEX)
  34	DROP INDEX executions count (DROP INDEX)
  35	COMMENT TABLE executions count (COMMENT TABLE)
  36	COMMENT COLUMN executions count (COMMENT COLUMN)
  37	CREATE SCHEMA executions count (CREATE SCHEMA)
  38	DROP SCHEMA executions count (DROP SCHEMA)
  39	GRANT RDAREA executions count (GRANT RDAREA)
  40	GRANT SCHEMA executions count (GRANT SCHEMA)
  41	GRANT access-privilege executions count (GRANT ACCESS)
  42	GRANT CONNECT executions count (GRANT CONNECT)
  43	GRANT DBA executions count (GRANT DBA)
  44	REVOKE RDAREA executions count (REVOKE RDAREA)
  45	REVOKE SCHEMA executions count (REVOKE SCHEMA)
  46	REVOKE access-privilege executions count (REVOKE ACCESS)
  47	REVOKE CONNECT executions count (REVOKE CONNECT)
  48	REVOKE DBA executions count (REVOKE DBA)
  49	CREATE VIEW executions count (CREATE VIEW)
  50	DROP VIEW executions count (DROP VIEW)
  51	System-specific information (UNUSED)
  52	System-specific information (UNUSED)
  53	PURGE TABLE statement executions count (PURGE TABLE)
  54	Other executions count (MISC)
  55	Number of acquisition requests for stored procedure objects (SQLOBJ GET REQ)
  56	SQL object buffer hits count for stored procedure objects (SQLOBJ CACHE HIT)
  57	CREATE PROCEDURE executions count (CREATE PROCEDURE)
  58	DROP PROCEDURE executions count (DROP PROCEDURE)
  59	CALL statement executions count (CALL)
  60	DESCRIBE statement (INPUT) executions count (DESCRIBE INPUT)
  61	ALTER PROCEDURE executions count (ALTER PROCEDURE)
  62	UAP or transaction execution time (UAP EXEC TIME (MS))			In milliseconds (includes a value in seconds; a value less than a millisecond is rounded)
  63	Service name (SERVICE NAME)	Character	31
  64	Lock release wait time (LOCK TIME)1	Numeric	10	In seconds
  65	No. 64 in microseconds (LOCK TIME (MICRO))1		6	Value in seconds is not included.
  66	Output timing for the corresponding row (OUTPUT TIMING)	Character	1	C: In UAP executions T: In transactions
  67	Front-end server name (FES NAME)		8
  68	Connect number (CONNECT NO)	Numeric	10	Sequence number assigned to each connection within one front-end server
  69	Font-end server process ID (FES PROCESS ID)
  70	CPU time (CPU TIME)4			In milliseconds
  71	Single server or front-end server processing time (SERV EXEC TIME)2			In seconds
  72	No. 71 in microseconds (SERV EXEC TIME (MICRO))		6	Value in seconds is not included.
  73	Total input/output time (IO TIME)5		10	In seconds
  74	No. 73 in microseconds (IO TIME (MICRO))5		6	Value in seconds is not included.
  75	Maximum input/output time (MAX IO TIME)3		10	In seconds
  76	No. 75 in microseconds (MAX IO TIME (MICRO))		6	Value in seconds is not included.
  77	Minimum input/output time (MIN IO TIME)3		10	In seconds
  78	No. 77 in microseconds (MIN IO TIME (MICRO))		6	Value in seconds is not included.
  79	Reference operations count on data page, index page, or directory page (DID RF CNT)5		10
  80	Update operations count on data page, index page, or directory page (DID UPD CNT)5
  81	Buffer hits count for data page, index page, or directory page (DID HIT CNT)5
  82	Buffer hit ratio for data page, index page, or directory page (DID BUF HIT RATIO)		3	Percentage
  83	Real READs count for data page, index page, or directory page (DID READ CNT)5		10
  84	Real WRITEs count for data page, index page, or directory page (DID WRITE CNT)5
  85	Reference operations count on LOB column data page (LOB RF CNT)5
  86	Update operations count on LOB column data page (LOB UPD CNT)5
  87	Reference buffer hits count for LOB column data page (LOB RF HIT CNT)5
  88	Update buffer hits count for LOB column data page (LOB UPD HIT CNT)5
  89	Reference buffer hits count for LOB column data page (LOB RF BUF HIT RATIO)		3	Percentage
  90	Update buffer hits count for LOB column data page (LOB UPD BUF HIT RATIO)
  91	Real READs count for LOB column database (LOB READ CNT)5		10
  92	Real WRITEs count for LOB column database (LOB WRITE CNT)5
  93	Global buffer flashes count (BUF FLASH CNT)5
  94	READ waits count for global buffer (BUF READ WAIT CNT)5
  95	WRITE waits count for global buffer (BUF WRITE WAIT CNT)5
  96	Global buffer lock release waits count (BUF LOCK WAIT CNT)5
  97	Maximum number of work table files (MAX WKFILE NUM)
  98	Maximum number of work table file extensions (MAX WKFILE EXP CNT)
  99	Maximum size of work table file (MAX WKFILE VOLUME)			In MB
  100	Work table file READs count (WKFILE READ CNT)5
  101	Work table file WRITEs count (WKFILE WRITE CNT)5
  102	Number of forced outputs on work table buffer (WKFILE BUF FORCED OUT CNT)5
  103	Maximum hash table size in batch processing mode (MAX WHOLE HASH TABLE SIZE)			In KB
  104	Maximum level-1 bucket size (MAX BUCKET SIZE LEVEL 1)
  105	Maximum level-2 bucket size (MAX BUCKET SIZE LEVEL 2)
  106	Maximum level-3 bucket size (MAX BUCKET SIZE LEVEL 3)
  107	Number of times page search for reutilization of free space failed (REUSE FAILURE CNT)5
  108	Number of times the mode changed from new page allocate to free page reuse on a table with SEGMENT REUSE specified (REUSE CHANGE CNT)5
  109	Number of times data pages and index pages were referenced using the local buffer (LOCAL BUF RF CNT)5
  110	Number of times data pages and index pages were updated using the local buffer (LOCAL BUF UPD CNT)5
  111	Local buffer hit count for data pages and index pages (LOCAL BUF HIT CNT)5
  112	Number of real READs on data pages and index pages using the local buffer (LOCAL BUF READ CNT)5
  113	Number of real WRITEs on data pages and index pages using the local buffer (LOCAL BUF WRITE CNT)5
  114	Local buffer flush count (LOCAL BUF FLUSH CNT)5
  115	Number of asynchronous READ requests (AR REQ CNT)5
  116	Number of times synchronization waits occurred during asynchronous READ (AR SYNC WAIT CNT)5
  117	Total synchronization wait time during asynchronous READ (AR SYNC WAIT TIME TOTAL)5			In seconds
  118	No. 177 in microseconds (AR SYNC WAIT TIME TOTAL (MICRO))5		6	Value in seconds is not included.
  119	Average synchronization wait time during asynchronous READ (AR SYNC WAIT TIME AVERAGE)		10	In seconds
  120	No. 119 in microseconds (AR SYNC WAIT TIME AVERAGE (MICRO))		6	Value in seconds is not included.
  121	Total synchronous input/output time during asynchronous READ (AR SYNC IO TIME TOTAL)5		10	In seconds
  122	No. 121 in microseconds (AR SYNC IO TIME TOTAL (MICRO))5		6	Value in seconds is not included.
  123	Average synchronous input/output time during asynchronous READ (AR SYNC IO TIME AVERAGE)		10	In seconds
  124	No. 123 in microseconds (AR SYNC IO TIME AVERAGE (MICRO))		6	Value in seconds is not included.
  125	Maximum comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (MAX HASH COMP COUNT)3		10
  126	Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)5		10
  127	Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)5		10

Note

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

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

² 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.

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

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

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

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

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	SQL execution start time (START)		14	Format: MM/DD/hh:mm:ss
4	No. 3 in microseconds (START (MICRO))	Numeric	6	Value in seconds is not included.
5	SQL execution termination time (END)	Character	14	Format: MM/DD/hh:mm:ss
6	No. 5 in microseconds (END (MICRO))	Numeric	6	Value in seconds is not included.
7	Length of created SQL object (PDATA)		10	In bytes
8	Number of back-end servers that sent SQL object (BES COUNT)
9	SQL execution time (SQL EXEC TIME (MICRO))			In microseconds (includes the value in seconds)
10	Number of rows retrieved (FETCH ROW)
11	Number of rows inserted (INSERT ROW)
12	Number of rows updated (UPDATE ROW)
13	Number of rows deleted (DELETE ROW)
14	Number of rows created in work table (CREATE LIST)
15	Number of rows deleted from work table (DROP LIST)
16	SQL execution time (SQL EXEC TIME (SEC))			In seconds (value is rounded off)
17	Service name (SERVICE NAME)	Character	31
18	Front-end server name (FES NAME)		8
19	Connection number (CONNECT NO)	Numeric	10	Serial number assigned to each connection in one front-end server.
20	SQL counter (SQL COUNTER)
21	Front-end server process ID (FES PROCESS ID)
22	Operation code (OPERATION CODE)1	Character	4
23	Section number (SECTION NO)	Numeric	5
24	SQL type code (SQL TYPE CODE)2	Character	4
25	SQL code (SQLCODE)	Numeric	10
26	Server name (SERVER NAME)	Character	8
27	Number of times processing requests were issued to the foreign server (FOREIGN REQUEST COUNT)	Numeric	10
28	Foreign server processing time (FOREIGN EXEC TIME)			In seconds
29	No. 28 in microseconds (FOREIGN EXEC TIME(MICRO))			In microseconds (includes the value in seconds)
30	Number of rows retrieved on the foreign server (FOREIGN FETCH ROW)
31	Total comparison count when a hash row partitioning table was searched during hash join, subquery hash execution (HASH COMP COUNT)	Numeric	10
32	Total hash row partitioning table search count during hash join, subquery hash execution (HASH HIT COUNT)	Numeric	10
33	Number of rows inserted in the foreign server (FOREIGN INSERT ROW)	Numeric	10
34	Number of rows updated on the foreign server (FOREIGN UPDATE ROW)	Numeric	10
35	Number of rows deleted on the foreign server (FOREIGN DELETE ROW)	Numeric	10

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.

¹ See Table 14-10 for the operation codes.

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

Table 14-10 Operation codes

Operation code	Corresponding SQL statements
AUI2	DELETE statement (static SQL), INSERT statement (static SQL), UPDATE statement (static SQL), LOCK statement (static SQL), PURGE TABLE statement (static SQL), single-row SELECT statement (static SQL), FREE LOCATOR statement (static SQL)
AUI3	Assignment statement (static SQL)
AUX	EXECUTE statement
AUXI	EXECUTE IMMEDIATE statement and all definition SQL statements
AUXO	EXECUTE statement (INTO specified)
CALL	CALL statement
CLOS	CLOSE statement
CMIT	COMMIT statement
CNCT	CONNECT statement
CPRP	Commit Prepare*
DESC	DESCRIBE statement (OUTPUT specified)
DEST	DESCRIBE TYPE statement
DISC	DISCONNECT statement, COMMIT statement (RELEASE specified)
DISR	ROLLBACK statement (RELEASE specified)
DIST	Disconnect + Tran Check*
DSCM	Used by system
DSPR	Used by system
DSRL	Used by system
FETC	FETCH statement
GETD	GET DIAGNOSTICS
HVAR	DESCRIBE statement (INPUT specified)
JARI	INSTALL JAR
JARR	REPLACE JAR
JARU	REMOVE JAR
OPEN	OPEN statement (dynamic SQL)
OPN2	OPEN statement (static SQL)
OPNR	OPEN statement (dynamic SQL (multiple cursors))
RENV	Used by system
RNCN	CONNECT statement (TO specified)
RNDS	DISCONNECT statement (TO specified)
ROLL	ROLLBACK statement
RSDC	DESCRIBE statement (OUTPUT, RESULT SET specified)
RSFT	FETCH statement (RESULT SET specified)
RSCL	CLOSE statement (RESULT SET specified)
SAUH	SET SESSION AUTHORIZATION statement
SET	PREPARE statement
SINF	Used by system
SOPT	Used by system
SVLS	Used by system
THRE	Used by system
THSU	Used by system
TRCK	Used by system
TRC2	Used by system
TRST	Used by system
TSCM	Used by system
TSRL	Transfer Rollback*
TSPR	Transfer Prepare*
ALCR	ALLOCATE CURSOR statement
DSET	DEALLOCATE PREPARE statement

* Output only when the XA interface is used.

Table 14-11 SQL type codes

No.	SQL statement	SQL type code (hexadecimal)
1	CREATE TABLE	1038
2	DROP TABLE	103C
3	ALTER TABLE	1040
4	CREATE INDEX	1044
5	DROP INDEX	1048
6	COMMENT ON TABLE	104C
7	COMMENT ON COLUMN	1050
8	CREATE SCHEMA	1054
9	DROP SCHEMA	1058
10	GRANT RDAREA	105C
11	GRANT SCHEMA	1060
12	GRANT ACCESS	1064
13	REVOKE RDAREA	1068
14	REVOKE SCHEMA	106C
15	REVOKE ACCESS	1070
16	CREATE VIEW	1074
17	DROP VIEW	1078
18	GRANT CONNECT	1098
19	GRANT DBA	109C
20	REVOKE CONNECT	10A0
21	REVOKE DBA	10A4
22	CREATE PROCEDURE	10B0
23	DROP PROCEDURE	10B4
24	ALTER PROCEDURE	10B8
25	CREATE TYPE	10C0
26	DROP DATA TYPE	10C4
27	CREATE FUNCTION	10C8
28	DROP FUNCTION	10CC
29	ALTER ROUTINE	10E8
30	LOCK statement	2134
31	SELECT statement	4000, 4900, 4100, 4A04, 4204
32	INSERT statement	4108
33	UPDATE statement	4114
34	DELETE statement	411C
35	ASSIGN LIST statement	4224, 4324
36	DROP LIST statement	422C
37	PURGE TABLE statement	4184
38	CALL PROCEDURE	40BC
39	GET DIAGNOSTICS	40C0
40	Assignment statement	40C4
41	FREE LOCATOR statement	40C8

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

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	Server name (SERVER)		8
3	Global buffer name (BUFFER NAME)		16
4	Statistics log acquisition time (LOG GET TIME)		14	Format: MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified
5	Number of buffer sectors in global buffer pool (BUFFER COUNT)	Numeric	10
6	Number of synchronization point dump pages (SYNC POINT)
7	Maximum number of concurrently requested buffer sectors (BUFFER MAX)
8	Update GETs count (UPDATE GET)
9	Update buffer hits count (UPDATE HIT)
10	Update buffer hit rate (UPDATE HIT RATIO)		3	Percentage
11	Update buffer flushes count (UPDATE FLUSH)		10
12	Reference GETs count (REF GET)
13	Reference buffer hits count (REF HIT)
14	Reference buffer hit rate (REF HIT RATIO)		3	Percentage
15	Reference buffer flushes count (REF FLUSH)		10
16	Real READs count (READ)
17	Input waits count (WAIT READ)
18	Real WRITEs count (WRITE)
19	Output waits count (WAIT WRITE)
20	Buffer lock release waits count (WAIT EXCLUSIVE)
21	Buffer shortages count (BUFFER INSUFFICIENCY)
22	Prefetch input pages count (PRRED)
23	Prefetch hit pages count (PRHIT)
24	Prefetch hit ratio (PRHIT RATIO)		3	Percentage
25	Prefetch execution resources shortage count (PR INSUFFICIENCY)		10
26	Global buffer hit ratio (BUFHIT RATIO)		3	Percentage
27	Current reference buffers count (CUR REF BUFNUM)		10
28	Current update buffers count (CUR UPDATE BUFNUM)
29	Deferred write trigger update buffers count (TRG UPDATE BUFNUM)
30	Synchronization points count (SYNC COUNT)
31	Number of prefetch READ requests (PR READ REQ CNT)
32	Number of READ requests for LOB global buffer (LOB READ REQ CNT)
33	Number of WRITE requests for LOB global buffer (LOB WRITE REQ CNT)
34	Batch input pages count for LOB global buffer (LOB BLK READ PGNUM)
35	Batch output pages count for LOB global buffer (LOB BLK WRITE PGNUM)
36	System-specific information (CACHE BUFFER INSUFFICIENCY)
37	System-specific information (CACHE BUFFER FLUSH MAX)
38	System-specific information (CACHE BUFFER FLUSH AVERAGE)
39	System-specific information (LOCK WAIT CNT)			Exponent representation
40	Percentage of lock contention-release wait (LOCK WAIT RATIO)		5	% (up to 1 decimal place)
41	System-specific information (SLEEP EXEC AVERAGE)		10	Exponent representation
42	Percentage rate of spin loop (SPIN EXEC RATIO)		5	% (up to 1 decimal place)
43	Average spin loop count (SPIN EXEC AVERAGE)		10	Exponent representation
44	Buffer pool lock exclusive time during synchronization point processing		10
45	No. 44 in microseconds		6	Value in seconds is not included
46	Number of buffers processed within buffer pool lock exclusive time during synchronization point processing		10
47	Take-over count of database write processing by reference request hit during synchronization point processing
48	Take-over count of database write processing by update request hit during synchronization point processing

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

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	Server name (SERVER)		8
3	HiRDB file name (FILE NAME)		167
4	RDAREA name (RDAREA NAME)		30
5	Statistics log acquisition time (LOG GET TIME)		14	Format: MM/DD/hh:mm when -e sec is omitted; MM/DD/hh:mm:ss when -e sec is specified
6	Synchronous READs count (SYNC READ)	Numeric	10
7	Synchronous WRITEs count (SYNC WRITE)
8	System-specific information (AIO READ)
9	Asynchronous WRITEs count (AIO WRITE)
10	System-specific information (LIST IO)
11	Opens count (OPEN)
12	Closes count (CLOSE)
13	I/O errors count (IO ERROR)

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

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	Server name (SERVER)		8
3	Log acquisition time (LOG GET TIME)		11	Format: MM/DD/hh:mm:ss
4	Cause (CAUSE)		1	Trigger: T Pre-sync: P Synchronization point: S Database synchronization point: D RDAREA synchronization point: R
5	Pre-sync completion status (STATUS)*			Pre-sync completed: P Complete and terminated: E
6	I/O parallel level (PARALLEL)	Numeric	10
7	Total number of pages output (OUT PAGE)			Total number of pages output by deferred write processing for each cause
8	WRITE count (DWEXEC)
9	Minimum unit value of WRITE (DWMIN)			In seconds (rounded off)
10	No. 9 in microseconds (DWMINM)		6	Value in seconds is not included.
11	Maximum unit value of WRITE (DWMAX)		10	In seconds (rounded off)
12	No. 11 in microseconds (DWMAXM)		6	Value in seconds is not included.
13	Average unit value of WRITE (DWAVG)		10	In seconds (rounded off)
14	No. 13 in microseconds (DWAVGM)		6	Value in seconds is not included.
15	Total WRITE time (DWSUM)		10	In seconds (rounded off)
16	No. 15 in microseconds (DWSUMM)		6	Value in seconds is not included.
17	Parallel WRITE time (DWPARA)		10	In seconds (rounded off)
18	No. 17 in microseconds (DWPARAM)		6	Value in seconds is not included.
19	Execution time (DWTOTAL)		10	In seconds (rounded off)
20	No. 17 in microseconds (DWTOTALM)		6	Value in seconds is not included.
21	System-specific information (DWLSNGET)		10	In seconds (rounded off)
22	System-specific information (DWLSNGETM)		6	Value in seconds is not included.
23	System-specific information (DWSYNCLIST)		10	In seconds (rounded off)
24	System-specific information (DWSYNCLISTM)		6	Value in seconds is not included.
25	System-specific information (DWSEMOP)		10	In seconds (rounded off)
26	System-specific information (DWSEMOPM)		6	Value in seconds is not included.

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)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	Service name (SERVICE NAME)		31
4	Front-end server name (FES NAME)		8
5	Connection number (CONNECT NO)	Numeric	10	Serial number assigned to each connection in one front-end server
6	SQL counter (SQL COUNTER)
7	Front-end server process ID (FES PROCESS ID)
8	Operation code (OPERATION CODE)	Character	4	For the operation codes, see Table 14-10.
9	Section number (SECTION NO)	Numeric	5
10	SQL type code (SQL TYPE CODE)	Character	4	For SQL type codes, see Table 14-11.
11	Server name (SERVER NAME)		8
12	Syntax analysis start time (PARSE START(S))		14	Format: MM/DD/hh:mm:ss
13	No. 12 in microseconds (PARSE START (MICRO))	Numeric	6	Value in seconds is not included.
14	Syntax analysis termination time (PARSE END(S))	Character	14	Format: MM/DD/hh:mm:ss
15	No. 14 in microseconds (PARSE END (MICRO))	Numeric	6	Value in seconds is not included.
16	Syntax analysis execution time (PARSE EXEC TIME(SEC))		10	In seconds (value is rounded off)
17	No. 16 in microseconds (PARSE EXEC TIME(MICRO))			Value in seconds is included.
18	Semantic analysis start time (SEMAN START(S))	Character	14	Format: MM/DD/hh:mm:ss
19	No. 18 in microseconds (SEMAN START(MICRO))	Numeric	6	Value in seconds is not included.
20	Semantic analysis termination time (SEMAN END(S))	Character	14	Format: MM/DD/hh:mm:ss
21	No. 20 in microseconds (SEMAN END(MICRO))	Numeric	6	Value in seconds is not included.
22	Semantic analysis execution time (SEMAN EXEC TIME(SEC))		10	In seconds (Value is rounded off.)
23	No. 22 in microseconds (SEMAN EXEC TIME(MICRO))			Value in seconds is included.
24	Optimization start time (OPT START(S))	Character	14	Format: MM/DD/hh:mm:ss
25	No. 24 in microseconds (OPT START(MICRO))	Numeric	6	Value in seconds is not included.
26	Optimization termination time (OPT END(S))	Character	14	Format: MM/DD/hh:mm:ss
27	No. 26 in microseconds (OPT END(MICRO))	Numeric	6	Value in seconds is not included.
28	Optimization execution time (OPT EXEC TIME(SEC))		10	In seconds (value is rounded off)
29	No. 28 in microseconds (OPT EXEC TIME(MICRO))			Value in seconds is included.
30	SQL object generation start time (SQLOBJ GEN START(S))	Character	14	Format: MM/DD/hh:mm:ss
31	No. 30 in microseconds (SQLOBJ GEN START(MICRO))	Numeric	6	Value in seconds is not included.
32	SQL object generation termination time (SQLOBJ GEN END(S))	Character	14	Format: MM/DD/hh:mm:ss
33	No. 32 in microseconds (SQLOBJ GEN END(MICRO))	Numeric	6	Value in seconds is not included.
34	SQL object generation execution time (SQLOBJ GEN EXEC TIME(SEC))		10	In seconds (value is rounded off)
35	No. 34 in microseconds (SQLOBJ GEN EXEC TIME(MICRO))			Value in seconds is included.
36	SQL object registration start time (SQLOBJ ENT START(S))	Character	14	Format: MM/DD/hh:mm:ss
37	No. 36 in microseconds (SQLOBJ ENT START(MICRO))	Numeric	6	Value in seconds is not included.
38	SQL object registration termination time (SQLOBJ ENT END(S))	Character	14	Format: MM/DD/hh:mm:ss
39	No. 38 in microseconds (SQLOBJ ENT END(MICRO))	Numeric	6	Value in seconds is not included.
40	SQL object registration execution time (SQLOBJ ENT EXEC TIME(SEC))		10	In seconds (value is rounded off)
41	No. 40 in microseconds (SQLOBJ ENT EXEC TIME(MICRO))			Value in seconds is included.

Table 14-16 Record format of a DAT-format file (SQL dynamic optimization information)

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	Service name (SERVICE NAME)		31
4	Front-end server name (FES NAME)		8
5	Connection number (CONNECT NO)	Numeric	10	Serial number assigned to each connection in one front-end server
6	SQL counter (SQL COUNTER)
7	Front-end server process ID (FES PROCESS ID)
8	Operation code (OPERATION CODE)	Character	4	For operation codes, see Table 14-10.
9	Section number (SECTION NO)	Numeric	5
10	SQL type code (SQL TYPE CODE)	Character	4	For SQL type codes, see Table 14-11.
11	Server name (SERVER NAME)		8
12	Dynamic optimization start time (DYNAMIC START)		14	Format: MM/DD/hh:mm:ss
13	No. 12 in microseconds (START(MICRO))	Numeric	6	Value in seconds is not included.
14	Dynamic optimization termination time (DYNAMIC END)	Character	14	Format: MM/DD/hh:mm:ss
15	No. 14 in microseconds (END(MICRO))	Numeric	6	Value in seconds is not included.
16	Dynamic optimization execution time (DYNAMIC EXEC TIME(SEC))		10	In seconds
17	No. 16 in microseconds (DYNAMIC EXEC TIME(MICRO))			Value in seconds is included.
18	System-specific information (SUB SECTION COUNT)		5
19	System-specific information (SUB SECTION NO)
20	SQL object type (SQLOBJ KIND)	Character	1	F: Front end H: Foreign table access J: Sort/join T: Base table scan
21	Requested servers count (REQ SERVER)	Numeric	10
22	Allocated servers count (ALC SERVER)
23	Allocated server name (ALC SERVER NAME)	Character	8
24	RDAREA ID (RDAREA ID)	Numeric	10

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

No.	Field name (title bar)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	Service name (SERVICE NAME)		31
4	Front-end server name (FES NAME)		8
5	Connection number (CONNECT NO)	Numeric	10	Serial number assigned to each connection in one front-end server.
6	SQL counter (SQL COUNTER)
7	Front-end server process ID (FES PROCESS ID)
8	Server name (SERVER NAME)	Character	8
9	Thread number (THREAD NO)	Numeric	5
10	Operation code (OPERATION CODE)	Character	4	For operation codes, see Table 14-10.
11	Section number (SECTION NO)	Numeric	5
12	System-specific information (SUB SECTION NO)
13	SQL code (SQLCODE)		10
14	SQL object execution start time (SQLOBJ START)	Character	14	Format: MM/DD/hh:mm:ss
15	No. 14 in microseconds (START(MICRO))	Numeric	6	Value in seconds is not included.
16	SQL object execution termination time (SQLOBJ END)	Character	14	Format: MM/DD/hh:mm:ss
17	No. 16 in microseconds (END(MICRO))	Numeric	6	Value in seconds is not included.
18	SQL object execution time (SQLOBJ EXEC TIME(SEC))		10	In seconds (value is rounded off)
19	No. 18 in microseconds (SQLOBJ EXEC TIME(MICRO))			Value in seconds is included.
20	Number of rows retrieved for SQL object (FETCH ROW)
21	Number of rows inserted for SQL object (INSERT ROW)
22	Number of rows updated for SQL object (UPDATE ROW)
23	Number of rows deleted for SQL object (DELETE ROW)
24	Number of work table rows created (CREATE LIST)
25	Number of work table rows deleted (DROP LIST)
26	Send operations count (SEND)
27	Length of send data (SEND DATA SIZE)
28	Receive operations count (RECEIVE)
29	Length of receive data (RECEIVE DATA SIZE)
30	Number of times work tables were created (CREATE TMP LIST)
31	Number of times work tables were deleted (DROP TMP LIST)
32	HiRDB file output operations count (IOS OUTPUT)
33	Buffer input operations count (BUFFER INPUT)
34	SELECT APSL number (SEL APSL NO)
35	SQL object type (SQLOBJ KIND)	Character	1	F: Front end J: Sort/join T: Base table scan
36	Number of times processing requests were issued to foreign server (FOREIGN REQUEST COUNT)	Numeric	10
37	Foreign server processing time (FOREIGN EXEC TIME)			In seconds
38	No. 37 in microseconds (FOREIGN EXEC TIME(MICRO))			In microseconds (includes the value in seconds)
39	Number of rows retrieved on the foreign server (FOREIGN FETCH ROW)
40	Number of rows inserted in the foreign server (FOREIGN INSERT ROW)
41	Number of rows updated on the foreign server (FOREIGN UPDATE ROW)
42	Number of rows deleted on the foreign server (FOREIGN DELETE ROW)

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)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	Front-end server name (FES NAME)		8
4	Connection number (CONNECT NO)	Numeric	10
5	Front-end server process ID (FES PROCESS ID)
6	Server name (SERVER)	Character	8
7	System-specific information (SERVICE KIND)		1
8	Operation code (OPERATION CODE)		4	For operation codes, see Table 14-10.
9	Section number (SECTION NO)	Numeric	5
10	System-specific information (SUB SECTION NO)
11	SQL type code (SQL TYPE CODE)	Character	4	For SQL type codes, see Table 14-11.
12	SQL code (SQLCODE)	Numeric	10
13	Service start time (SERVICE START)	Character	14	Format: MM/DD/hh:mm:ss
14	No. 13 in microseconds (SERVICE START(MICRO))	Numeric	6	Value in seconds is not included.
15	Service termination time (SERVICE END)	Character	14	Format: MM/DD/hh:mm:ss
16	No. 15 in microseconds (SERVICE END(MICRO))	Numeric	6	Value in seconds is not included.
17	Service execution time (SERVICE EXEC TIME(SEC))		10	In seconds (value is rounded off)
18	No. 17 in microseconds (SERVICE EXEC TIME(MICRO))			Value in seconds is included.
19	SQL object transfer start time (TRANSFER START)	Character	14	Format: MM/DD/hh:mm:ss
20	No. 19 in microseconds (TRANSFER START(MICRO))	Numeric	6	Value in seconds is not included.
21	SQL object transfer end time (TRANSFER END)	Character	14	Format: MM/DD/hh:mm:ss
22	No. 21 in microseconds (TRANSFER END(MICRO))	Numeric	6	Value in seconds is not included.
23	SQL object transfer time (TRANSFER TIME(SEC))		10	In seconds (value is rounded off)
24	No. 23 in microseconds (TRANSFER TIME(MICRO))			Value in seconds is included.
25	SQL object transfer size (TRANSFER SIZE)		10	In bytes

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)	Attribute	Maximum length	Remarks
  1	Host name (HOST)	Character	32
  2	UAP name (UAP NAME)
  3	Module name (MODULE NAME)
  4	Service name (SERVICE NAME)		31
  5	Front-end server name (FES NAME)		8
  6	Connection number (CONNECT NO)	Numeric	10	Serial number assigned to each connection in one front-end server
  7	SQL counter (SQL COUNTER)
  8	Front-end server process ID (FES PROCESS ID)
  9	Operation code (OPERATION CODE)	Character	4	For operation codes, see Table 14-10.
  10	Section number (SECTION NO)	Numeric	5
  11	SQL length (SQL LENGTH)		10
  12	SQL statement (SQL STRING)	Character	2M	An SQL statement is output a maximum of 30 KB from the beginning.

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)	Attribute	Maximum length	Remarks
1	Host name (HOST)	Character	32
2	UAP name (UAP NAME)
3	Connect/disconnect time (CONNECT/DISCONNECT TIME)		14	Format: MM/DD/hh:mm:ss
4	No. 3 in microseconds (CONNECT/DISCONNECT TIME(MICRO))	Numeric	6	Value in seconds is not included.
5	Front-end server process ID (FES PROCESS ID)		10
6	SQL code (SQLCODE)
7	Connect/disconnect status (CONNECT/DISCONNECT STATUS)	Character	1	C: CONNECT D: DISCONNECT
8	Client group ID (CLT GROUP)			1: WS client 2: PC client 3: Mainframe-based client 8: X/Open XA interface 0: Utility #: Other blank: None (space: 020)
9	Privilege information (PRIVILEGE)			C: CONNECT privilege D: DBA privilege blank: None (space: 020)
10	Connect/disconnect type (CONNECT/DISCONNECT KIND)			N: Normal (CONNECT/DISCONNECT) S: set session authorization I: Internal disconnect T: Transaction resolution (OLTP only)
11	Authorization identifier (USER NAME)		30
12	Password (PASSWORD)			Upon KFPA11560-E error (invalid password)
13	CLT IP address (CLT IP ADDRESS)		15	Format: XXX.XXX.XXX.XXX

Table 14-21 Foreign server operation statistical information

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

Table 14-22 Foreign server utilization statistical information

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

¹ For details about SQL TYPE CODE, see Table 14-11.