Output formats of statistical information

Following each set of statistical information, summary log record information is output for each edit item. However, a summary log is not output for the following statistical information: SQL static optimization, SQL dynamic optimization, SQL object execution, SQL statement history, and CONNECT/DISCONNECT.

 
           :
Statistical information
           :
FILE KIND LOG KIND FIRST               LAST
XXX       XXX      XXXX/XX/XX XX:XX:XX XXXX/XX/XX XX:XX:XX
 :         :                 :                   :
       NUM
XXXXXXXXXX
     :

Explanation

FILE KIND: Indicates the type of log file subject to analysis.; STJ is displayed for unload statistics log files and FJ is displayed for system log files (unload system log or system log file group).

LOG KIND: Indicates the type of log record subject to analysis:; sys: System activity statistical information; uap: UAP statistical information; sql: SQL statistical information; buf: Global buffer pool statistical information; fil: Statistical information on HiRDB files for database manipulation; dfw: Deferred write processing statistical information; idx: Index statistical information

FIRST: Indicates the earliest log acquisition time for log records subject to analysis.; If the log file subject to analysis contains no log records subject to analysis, ****/**/** **:**:** is displayed.

LAST: Indicates the most recent log acquisition time for log records subject to analysis.; If the log file subject to analysis contains no log records subject to analysis, ****/**/** **:**:** is displayed.

NUM: Indicates the number of log records subject to analysis.

(2) Summary information on input log files

Following all statistical information, summary information on all input log files is displayed for each type of log records.

If a system log file group is input (with the -d option specified), summary information on input log files is not displayed. If unload log files are input, summary information on input log files is displayed only when edit items are specified for index statistical information. If any other edit items are specified, 0 is displayed as the number of records.

 
                   :
Summary log record information for each edit item
                   :
NO FILE KIND:LOG FILE NAME
 LOG KIND  FIRST               LAST                       NUM
XX XXX      :XX...X
 XXX       XXXX/XX/XX XX:XX:XX XXXX/XX/XX XX:XX:XX XXXXXXXXXX
  :                  :                    :              :

Explanation

NO: Indicates the sequence number of the log file.

FILE KIND: Indicates the type of log file subject to analysis.; STJ: Unload statistics log files obtained by a HiRDB in 32-bit mode; STJ64: Unload statistics log files obtained by a HiRDB in 64-bit mode; FJ: Unload log file (Regular file); FJIOS: Unload log file (HiRDB file)

LOG FILE NAME: Indicates the name of the input unload statistics log file or unload log file (applicable to index statistical information).; The absolute pathname with a maximum length of 256 bytes is displayed as the name. If the name exceeds 256 bytes, the last 256 bytes are displayed.

LOG KIND: Indicates the type of log record subject to analysis:; sys: System activity statistical information; uap: UAP statistical information; sql: SQL statistical information; buf: Global buffer pool statistical information; fil: Statistical information on HiRDB files for database manipulation; dfw: Deferred write processing statistical information; idx: Index statistical information; sop: SQL static optimization information; dop: SQL dynamic optimization information; pcd: SQL object execution information; obj: SQL object transfer statistical information; sqh: SQL statement statistical information; cnc: CONNECT/DISCONNECT statistical information; dio: Statistical information about database I/O operations

FIRST: Indicates the earliest log acquisition time for the log file.; If the log file subject to analysis contains no log records subject to analysis, ****/**/** **:**:** is displayed.

LAST: Indicates the most recent log acquisition time for the log file.; If the log file subject to analysis contains no log records subject to analysis, ****/**/** **:**:** is displayed.

NUM: Indicates the number of records by log record type.

(3) Output information when there is no edit data

Displayed information	Description	Action
"*** NO DATA NOOPT ***"	Input statistics unload file subject to analysis contains no applicable edit item records.	Specified options may be invalid, or output items may be invalid when log records were acquired. Take one of the following actions: Check the -x, -s, -t, -u, and -f options and correct as necessary, then re-execute. Check the summary information on input statistics unload files to see if log records to be edited have been output and if the output time of the input statistics unload file is correct. Also, check that the correct input statistics unload files were input or that log records subject to analysis have been output.
"*** NO DATA HOST ***"	No log record was output from the host specified with the -x option.
"*** NO DATA SERVER ***"	No log record was output from the server specified with the -s option.
"*** NO DATA TIME ***"	No log record was output within the edit time specified with the -t option.
"*** NO DATA UAP ***"	No log record was output from the UAP specified with the -u option.
"*** NO DATA 1 REC ***"	Differential information cannot be edited because the input statistics unload file subject to analysis contained no log records for acquiring differential information. The system determines that there is no log record for acquiring differential information if there is more than one log record for summary log information or for summary information in the statistics input unload file, but they were output at a single synchronization point (the earliest log acquisition time (FIRST) and the most recent log acquisition time (LAST) for the summary information are in the same period). This applies only to global buffer pool statistical information and statistical information on HiRDB files for database manipulation.	Set the unload file so that there are at least two records.
"*** NO DATA ***"	There was no log record subject to analysis within the specified edit period.	If NO DATA is displayed often for the specified edit period, increase the length of the edit period.
"*** NO DATA ***"	There was no applicable log record for the specified edit item.	Check the summary information on input statistics unload files to see if there are editable log records.

Note: If there are no records subject to analysis for an edit item of SQL static optimization information, SQL dynamic optimization information, or SQL object execution information, an information message to that effect is displayed.

(4) Output formats of statistical information

If there are numeric values in the output information of the statistical information, they are displayed as follows:

Value range	Display
0-999	0-999
1,000-9,994	1.00k-9.99k^#
9,995-99,949	10.0k-99.9k^#
99,950-999,499	100k-999k^#
999,500-9,994,999	1.00M-9.99M^#
9,995,000-99,949,999	10.0M-99.9M^#
99,950,000-999,499,999	100M-999M^#
999,500,000-9,994,999,999	1.00G-9.99G^#
9,995,000,000-99,949,999,999	10.0G-99.9G^#
99,950,000,000-999,499,999,999	100G-999G^#
999,500,000,000-4,398,046,511,103	1.00T-4.40T^#

k: Kilo

M: Mega

G: Giga

T: Tera

#: The last digit displayed is rounded off on the basis of the next digit.

(5) Notes about the output statistical information

To output statistical information, use the following procedure:

Numbers are right-justified; character strings are left-justified.
The output range (output dates and times) is displayed when a range was specified for editing. If no time range was specified, * is displayed.
When an edit start time was specified, the beginning editing time is for the same time zone as the edit start time. If no edit start time was specified, output begins with the applicable file record in the earliest time zone.
When an edit end time was specified, the ending editing time is from the applicable file record in the earliest time zone to the time zone that is the same as the edit end time.
If overflow occurs during summing or a cumulative value is not to be output for an item, ***, ****, or a blank is displayed.
* indicates data whose average value resulted in an overflow. In such a case, the maximum and minimum values are accurate.
If there is no data in an edit time zone, ***** NO DATA aa...a ***** is displayed for that time zone.
If the unit is bytes, 1.00K = 2¹⁰ bytes, 1.00M = 2²⁰ bytes, and 1.00G = 2³⁰ bytes.

14.3.1 Output formats of statistical information

(1) Summary log record information for each edit item

(2) Summary information on input log files

(3) Output information when there is no edit data

(4) Output formats of statistical information

(5) Notes about the output statistical information