SQL Counts are all zero on the Package / DBRM(R/HTPKGSQL) History SQL Detail screen

Document ID : KB000047536
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms: 

SQL Counts are all zero on the Package / DBRM(R/HTPKGSQL) History SQL Detail screen. Why?       

BTACTSML generates a report on the SMF data set, and although it shows SQL counts and Bufferpool(BP) activity  at the plan level, it shows all zeros at the package level. Why?                                                                                                                                                                    

Resolution:    

Accounting trace class 10 needs to be started in order for SMF data to reflect SQL stats for package accounting information.   

The Insight parameter ACCTTRACE  must be set to 10 in order for the Insight  DC to collect and display package accounting SQL statistics and to populate the fields of BTACTSML