3. Db2 Transaction Counter

For Db2 the connection parameters are the same as the schema options. The refresh rate determines the sampling interval.

Figure 6.4. Db2 TX Counter Options

Db2 TX Counter Options

The following SQL is used to sample the transaction rate.

select total_app_commits + total_app_rollbacks from sysibmadm.mon_db_summary