PROUTIL ZEROSTATS qualifier

Resets (zeros) runtime statistics for the specified database.

Syntax

proutil db-name -C zerostats

Parameters

db-name
Specifies the database where you want to reset the statistics.

PROUTIL ZEROSTATS resets all runtime statistics for the database, including I/O statistics and latch and lock information.

Example

The statistics provided by PROUTIL IOSTATS include buffered, unbuffered, and logical I/O database operations. The statistics are cumulative from database startup or from when PROUTIL ZEROSTATS is executed. For more information, see PROUTIL IOSTATS qualifier.

The following output is a sample display of PROUTIL IOSTATS:

Database name is iostat_ex (2524)
FILE                    BUFFERED         UNBUFFERED         LOGICAL (2556)
                   Writes  Reads   Writes  Reads    Reads  Writes  Extends (2557)
)
================================================================================

iostat_ex.b1            0      0      478     23       21     307        3
iostat_ex.d1            3    236       12      0      234      14        0
iostat_ex_7.d1          1      2        0      0        0       0        0
iostat_ex_7.d2          1      1        0      0        0       0        0
iostat_ex_8.d1          1      2        0      0        0       0        0
iostat_ex_8.d2          1      1        0      0        0       0        0
iostat_ex_9.d1         41      5        0      0        3      40        0
iostat_ex_9.d2         11      1       16      0        0      10        1
iostat_ex_10.d1        25     10        0      0        8      24        0
iostat_ex_10.d2         1      1        0      0        0       0        0
iostat_ex_11.d1         1      2        0      0        0       0        0
iostat_ex_11.d2         1      1        0      0        0       0        0
iostat_ex_12.d1         1      2        0      0        0       0        0
iostat_ex_12.d2         1      1        0      0        0       0        0
iostat_ex.a1            0      0      131      4        3     130        0
iostat_ex.a2            0      0      132      3        2     131        0
iostat_ex.a3            0      0        6      2        1       5        0

After running PROUTIL ZEROSTATS on the database, the output of PROUTIL IOSTATS appears as follows:

Database name is iostat_ex (2524)
FILE                    BUFFERED         UNBUFFERED         LOGICAL (2556)
                   Writes  Reads   Writes  Reads    Reads  Writes  Extends (2557)
)
================================================================================

iostat_ex.b1            0      0        0      0        0       0        0
iostat_ex.d1            0      0        0      0        0       0        0
iostat_ex_7.d1          0      0        0      0        0       0        0
iostat_ex_7.d2          0      0        0      0        0       0        0
iostat_ex_8.d1          0      0        0      0        0       0        0
iostat_ex_8.d2          0      0        0      0        0       0        0
iostat_ex_9.d1          0      0        0      0        0       0        0
iostat_ex_9.d2          0      0        0      0        0       0        0
iostat_ex_10.d1         0      0        0      0        0       0        0
iostat_ex_10.d2         0      0        0      0        0       0        0
iostat_ex_11.d1         0      0        0      0        0       0        0
iostat_ex_11.d2         0      0        0      0        0       0        0
iostat_ex_12.d1         0      0        0      0        0       0        0
iostat_ex_12.d2         0      0        0      0        0       0        0
iostat_ex.a1            0      0        0      0        0       0        0
iostat_ex.a2            0      0        0      0        0       0        0
iostat_ex.a3            0      0        0      0        0       0        0