Introduction: 

This document states why a ROLLBACK performed by DB2 Connect is not displayed as an SQL Call.

Question: 

I rolled back an update using Data Studio's rollback option. Although Detector increased the ABORT count, it didn't display the ROLLBACK SQL call. Why?

Environment:  

z/OS 1.11 and above.

Answer: 

CA Detector currently only displays a ROLLBACK SQL call when the command is issued (or, written). Eg:

1)  EXEC SQL

         ROLLBACK

     END-SQL ;

2) Or, if the ROLLBACK command is entered into a DB2 Command processor (like ISQL or Data Studio). Eg:

    UPDATE  TEAM           

       SET PHONE = 'x9999'

    WHERE NAME = 'Greg'  ;

    ROLLBACK ;

Release:
Component: PDT