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 ;