Mainview for DB2 v12.1: How to calculate total count of SQL statements based on report BACCPKSR and BACCTLT ?

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MainView for DB2



    QUESTION:

    How to calculate total count of SQL statements based on report BACCPKSR and BACCTLT ?


    ANSWER:

     

    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.

      

     

     


    Article Number:

    000180050


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles