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

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

book

Article ID: 40611

calendar_today

Updated On:

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 ;