DB2 10.5 for Linux, UNIX, and Windows

db2perfc - Reset database performance values command

Resets the performance values for one or more databases. It is used with the performance monitor on Windows operating systems.

Authorization

Local Administrator

Required connection

None

Command syntax


                      .-------------.   
                      V             |   
>>-db2perfc--+-----+----+---------+-+--------------------------><
             '- -d-'    '-dbalias-'

Command parameters

-d: Specifies that performance values for DCS databases should be reset.
dbalias: Specifies the databases for which the performance values should be reset. If no databases are specified, the performance values for all active databases will be reset.

Examples

The following example resets performance values for all active DB2® databases:

db2perfc

The following example resets performance values for specific DB2 databases:

db2perfc dbalias1 dbalias2

The following example resets performance values for all active DB2 DCS databases:

db2perfc -d

The following example resets performance values for specific DB2 DCS databases:

db2perfc -d dbalias1 dbalias2

Usage notes

When an application calls the DB2 monitor APIs, the information returned is normally the cumulative values since the DB2 server was started. However, it is often useful to reset performance values, run a test, reset the values again, and then rerun the test.

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 command is executed.

The db2ResetMonitor API allows an application to reset the values it sees locally, not globally, for particular databases.