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 PROUTILIOSTATS 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