14.3.4 SQL statistical information

The following shows the statistical information about SQL:

pdstedit VV-RR          ***** SQL INFORMATION *****
INPUT          :/tmp/pdstj1 [1]
OUTPUT RANGE   :**/**/** **:**:** - **/**/** **:**:** [2]
-----------------------------------------------------------------------------
HOST = test [3]
-----------------------------------------------------------------------------
FES = fes01 [4]
-----------------------------------------------------------------------------
EDIT TIME 2001/09/30 00:00:00 - 2001/09/31 00:00:00 [5]
UAP NAME [6]
 SERVICE NAME [7]                 [8]   [9]   [10]  [11]
                                  PDATA PDAVG BES#  B#AVG
------------------------------     ----- ----- ----- -----
        [12] [13]     [14]  [15]  [16]  [17]  [18]  [19]  [20]  [21]
        KIND SERV     EXEC  TTIME FTCR  INSR  UPDR  DELR  CRTL  DRPL
        ---- -------- ----- ----- ----- ----- ----- ----- ----- -----

uap01
 service01
                                   745k   270     0     0
  *CNT* SQL           2.82k  272M     0   532     0     0     0     0 [22]
     **                     96.5k     0     0     0     0     0     0 [23]
  *CNT* FSQL              0     0     0     0     0     0 [22]
     **                         0     0     0     0     0 [23]
uap02
 service02
                                   467k    60     0     0
  *CNT* SQL           7.90k 79.0M 7.55k     0     0     0     0     0
     **                     10.0k     1     0     0     0     0     0
  *CNT* FSQL            750 5.60M 7.55k
     **                     12.0k     2
uap03
 service03
                                  11.2M   461     0     0
  *CNT* SQL           25.5k  310M 5.39k     0     0     0     0     0
     **                     12.2k     0     0     0     0     0     0
  *CNT* FSQL          2.32k 27.9M 5.39k
     **                     12.0k     2
uap04
 service04
                                  7.50M   534     0     0
  *CNT* SQL           14.7k  192M 5.99k   716   728   716     0     0
     **                     13.1k     0     0     0     0     0     0
  *CNT* FSQL            445 5.82M 1.99k
     **                     13.0k     4
*TOTAL*[24]                        19.9M   410     0     0
  *CNT* SQL           51.0k  854M 18.9k 1.25k   728   716     0     0
     **                     16.8k     0     0     0     0     0     0
  *CNT* FSQL          3.52k 39.3M 14.9k
     **                     11.2k     4
-----------------------------------------------------------------------------
FILE KIND   LOG KIND   FIRST                 LAST                         NUM
STJ         sql        2001/09/30 10:36:37   2001/09/30 12:34:03        50971
-----------------------------------------------------------------------------

Explanation
  1. Name of input statistics unload file or name of the directory containing the input statistics unload file (maximum of 58 bytes)
  2. Output range (output start date/time to output end date/time)
  3. Name of host requesting output of SQL statistical information
  4. Name of front-end server that executed SQL
  5. Edit period (collection start time to collection end time)
  6. UAP name
    This is the name of the UAP for which statistical information was edited.
  7. Service name
    This is the name of the service for which statistical information was edited. This name depends on the type of UAP that accessed HiRDB.*
  8. Total size of SQL objects created (bytes)
    This is the total size of SQL objects created by the SQL statements that were issued within the UAP or service.
  9. Average size of SQL objects created (bytes)
    This is the average size of SQL objects created for the SQL statements that were issued within the UAP or service.
    This value is obtained by the formula size of SQL objects created [Figure] SQL executions count.
  10. Number of back-end servers used
    This is the number of back-end servers used for the SQL statements that were issued within the UAP or service.
  11. Average number of back-end servers used
    This is the average number of back-end servers used for the SQL statements that were issued within the UAP or service.
  12. Type of output information
    In the case of SQL, this is information about SQL. In the case of FSQL, this information is about the foreign server.
  13. Information used by the system (not by users)
  14. SQL executions count
    If the type of output information is SQL, this is the number of times SQL statements issued within the UAP or service were executed. If the type of output information is FSQL, this is the number of times processing requests were issued to the foreign servers.
  15. SQL execution time (microseconds)
    If the type of output information is SQL, this is the total processing time for SQL statements issued within the UAP or service. If the type of output information is FSQL, this is the total processing time for the foreign servers. Note that this is the database access adaptor's processing time, not the foreign server's processing time.
  16. Number of rows retrieved
    If the type of output information is SQL, this is the number of rows retrieved by the FETCH and SELECT statements issued within the UAP or service.
  17. Number of rows inserted
    This is the number of rows inserted by the INSERT statement issued within the UAP or service.
  18. Number of rows updated
    This is the number of rows updated by the UPDATE statement issued within the UAP or service.
  19. Number of rows deleted
    This is the number of rows deleted by the DELETE statement issued within the UAP or service.
  20. Number of times work tables were created
    This is the number of times work tables were created internally by the SQL statements issued within the UAP or service.
  21. Number of times work tables were deleted
    This is the number of times work tables created internally by the SQL statements issued within the UAP or service were deleted. If an error has occurred, the correct number of times work tables were deleted may not be displayed.
  22. Total of each item
    If the type of output information is FSQL and the HiRDB External Data Access facility is not used, 0 or **** is displayed.
  23. If the type of output information is SQL, this is the average value (total of each item/number of executions). If the type of output information is FSQL, this is the average value (total of each item/number of processing requests to the foreign server). If the HiRDB External Data Access facility is not used, 0 or **** is displayed.
  24. Grand totals for each item
* The following table shows the service name that is displayed for each type of UAP:
UAP typeDisplayed service name
Open/TP1 UAPService requested from Open/TP1 SUP (service using program) to SPP (service provider program)Name of the corresponding service
Service requested from TP1/Message Control to MHP (message handling program)
Other31 consecutive asterisks (*)
Other types of UAP