This document states why a ROLLBACK performed by DB2 Connect is not displayed as an SQL Call.
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?
z/OS 1.11 and above.
CA Detector currently only displays a ROLLBACK SQL call when the command is issued (or, written). Eg:
1) EXEC SQL
2) Or, if the ROLLBACK command is entered into a DB2 Command processor (like ISQL or Data Studio). Eg:
SET PHONE = 'x9999'
WHERE NAME = 'Greg' ;