Results 1 to 4 of 4

Thread: db2 commit fail

  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: db2 commit fail

    I am working on db2 v7 on MVS OS390.
    Does the COMMIT for DB2 automatically ROLLBACK incase the COMMIT is not successful?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would check the SQL return code of the commit, and issue a rollback if not zero.

  3. #3
    Join Date
    Oct 2003
    Posts
    3
    Originally posted by Marcus_A
    I would check the SQL return code of the commit, and issue a rollback if not zero.

    Yes i intend to do the same! but my question is still unanswered!

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't think there is an answer that would cover every situation that DB2 might encounter. Sometimes yes, and maybe sometimes no.

    Also depends on who the coordinator is (TSO, CICS, IMS, etc).

Posting Permissions

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