Number of COMMIT statements differs for Detector and Subsystem Analyzer.

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

Reviewing the number of COMMIT statements in Detector and Subsystem Analyzer for same Interval Summary, the number of COMMIT statements in Detector is slightly higher.   

Instructions:

Detector and Subsystem Analyzer aggregation of COMMIT statements differs in the kind of COMMIT statement they collect.

Subsystem Analyzer includes COMMIT statements by TSO, CAF, CICS and COMMIT statements from DB2 Utilities. Depending on the DB2 Utilities, some times Subsystem Analyzer may have higher number of COMMIT statements in the Interval Summary compared to Detector.

Detector COMMIT statements are collected for the SQL statements and for the programs and plans within which the SQL is executed. New changes were made to COMMIT logic in Detector to address the problem where some of the CICS COMMIT statements were ignored, after the fix, more COMMIT counts are now shown by Detector. This change may have given the impression that Detector now shows higher number of COMMIT statements than Subsystem Analyzer.

The COMMIT statements on Detector and Subsystem Analyzer varies depending on the SQL statements executed and the type of COMMIT statements done by DB2. The two products vary with the type of COMMIT statements they collect.