Termination statistics

Heading	Contents
Function	Function for which the values are added up. A function in this case is a CALL DML operation code or an SQL statement (group). See “The STRING-FORMAT report” (field 10, STM).
# Auftr	Number of requests for this function
in %	Requests as a percentage of the total number of evaluated requests
Phys. I/O 1	Number of physical disk accesses
Log. I/O 1	Number of logical read and write accesses
L:P-AC	Number of logical read and write accesses for the physical read and write accesses of the access data
L:P-DA	Number of logical read and write accesses for the physical read and write accesses of the primary data
L:P-Cu	Number of logical read and write accesses for the physical read and write accesses of the temporary data
Ig:Auf	Number of read and write accesses per request
CPUUnits 1	Total CPU time
Mitl-CPU 1	Average CPU requirements per request
WaitTime 1	Average wait time in the DBH of a job (the wait time in the DBH is equal to the difference between the average net elapsed time and the average CPU time).
Mitl-Ela	Average gross elapsed time

Table 30: Termination statistics

¹In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here

Example

SESCOSP/SQL  VERS. <version>   TSN:9H16 ID.:SQLDB112 *** SUMMARY ***                           <date> <time>        PAGE     1
Funktion                       #Auftr in% Phys.I/O   Log. I/O L:P-AC L:P-DA L:P-Cu Lg:Auf   CPUUnits Mitl-CPU WaitTime Mitl-Ela    
OPEN CURSOR                        40   2        1        293      0     56      0      7     259599     6489       17       47
FETCH                              40   2        0         58      0      0      0      1     138819     3470       10       25
STORE CURSOR                        9   0        0          0      0      0      0      0      19891     2210        0       10
CLOSE CURSOR                       31   1        0          0      0      0      0      0      74353     2398        4       22
SELECT                            164  10       13        368    202     13      0      2     890109     5427       52       84
UPDATE                              8   0        4        188      0     12      0     23      67916     8489       44      124
COMMIT WORK                       169  10        0          0      0      0      0      0      69899      413        8       11
OTHER SQL-STATEMENT                11   0        8        864      0     26    128     78     421031    38275      253      438
SUCHFRAGE                         249  15        0       1375      0      0      0      5     465313     1868       93      103
BEGIN TRANSACTION                 435  27        0      12323      0      0      0     28    1262338     2901       41       59
COMMIT TRANSACTION                435  27        0          0      0      0      0      0     226812      521        6        9
Time period captured :  <date> <time>   until  <date> <time>