Results 1 to 3 of 3

Thread: DB2 Rollback

  1. #1
    Join Date
    Apr 2010
    Posts
    2

    Unanswered: DB2 Rollback

    Is it possible to do a Rollback in a program CICS DB2 ??

    Regards

    Jorge

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    yes it is. do it all the time. you even wrote the correct syntax in other thread that you tried to hijack.
    Dave

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Maybe I gave the wrong answer in the other thread [quoted below]. Back in the days when I used DB2 and CICS together, this is how we had to do it:

    Normally, when using CICS and DB2, there is a two-phase commit and CICS is the coordinator. Therefor SQL Commits and Rollbacks are not allowed.

    Instead, execute a CICS SYNCPOINT ROLLBACK command and it will rollback any uncommitted SQL.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •