Rolled back an update using Data Studio's rollback option. Detector increased the ABORT count, it did not display the ROLLBACK SQL call.

Products

• Detector for DB2 for z/OS

Issue/Introduction

Rolled back an update using Data Studio's rollback option. Although Detector for Db2 for z/OS (PDT)
increased the ABORT count, it did not display the ROLLBACK SQL call. 

Resolution

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 ;