This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
MainView for DB2
How to calculate total count of SQL statements based on report BACCPKSR and BACCTLT ?
In BACCPKSR, EXEC COUNT * STMT COUNT will give the approximate total count of SQL statements because STMT COUNT is an average, and the EXEC COUNT is from the SUM of the QPACSWITCH fields, The STMT COUNT is from the SUM of the QPACSQLC fields / QPACSWITCH. The DML activity reported in BACCPKSR is from QPSELECT,QPINSRT etc..from IFCID 239.
Total SQL count is available in BACCTLT or BACCTDR reports as a total (not average) under fields SQL STATEMENTS and TOTAL SQL STMTS, these fields are a SUM of QPACSQLC fields.