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              0     0     0     0     0     0
     **                         0     0     0     0     0
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              0     0     0     0     0     0
     **                         0     0     0     0     0
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              0     0     0     0     0     0
     **                         0     0     0     0     0
*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              0     0     0     0     0     0
     **                         0     0     0     0     0
-----------------------------------------------------------------------------
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
    The SQL column displays information about SQL statements.
    There is no need to check the FSQL column; it always displays 0 or ****.
  13. Information used by the system (not by users)
  14. SQL executions count
    This is the number of times SQL statements issued within the UAP or service were executed.
  15. SQL execution time (microseconds)
    This is the total processing time for SQL statements issued within the UAP or service.
  16. Number of rows retrieved
    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
    These are total values.
  23. Average values (total value[Figure] execution count for each item)
  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