When to use Db2 statistics trace

Use Db2 statistics class 1 to do high-level monitoring of Db2 subsystem activity.

A data section mapped by DSNDQBGL records statistics for a member's use of group buffer pools. The counters are cumulative since the time the member connected to a particular group buffer pool.

Statistics reporting intervals are not synchronized across the members of the data sharing group. For counters that are pertinent to the entire data sharing group, like group buffer statistics, IBM® OMEGAMON® for Db2 Performance Expert on z/OS® group-scope statistics reports combine the data of the individual members and present it for the entire group. The member data is apportioned to the same user-specified interval. IBM OMEGAMON for Db2 Performance Expert on z/OS presents the synchronized statistics intervals for each member, adds the counters across all members and presents them as statistics on a per-group basis.

Consider also using IBM OMEGAMON for Db2 Performance Expert on z/OS to do group-scope exception reporting when a particular counter exceeds a user-specified value.