When an application calls the DB2 monitor APIs, the information returned is normally the cumulative values since the DB2 server was started. However, often it is useful to:
To reset database performance values, use the db2perfc program. Type:
db2perfc
By default, this resets performance values for all active DB2 databases. However, you can also specify a list of databases to reset. You can also use the -d option to specify that performance values for DCS databases should be reset. For example:
db2perfc
db2perfc dbalias1 dbalias2 ... dbaliasn
whose aliases are dbalias1, dbalias2, ..., dbaliasn
db2perfc -d
db2perfc -d dbalias1 dbalias2 ... dbaliasn
The first example resets performance values for all active DB2 databases. The next example resets values for specific DB2 databases. The third example resets performance values for all active DB2 DCS databases. The last example resets values for specific DB2 DCS databases.
The program resets the values for ALL programs currently accessing database performance information for the relevant DB2 server instance (that is, the one held in db2instance in the session in which you run db2perfc.
Invoking db2perfc also resets the values seen by anyone remotely accessing DB2 performance information when the db2perfc command is executed.
| Note: | There is a DB2 API, sqlmrset, that allows an application to reset the values it sees locally, not globally, for particular databases. |