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?

book

Article ID: 40611

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

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 ;

 

 

 

 

Environment

Release:
Component: PDT