db2 commit fail

ppdeepa · #1 (**permalink**) 10-29-03, 14:41

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

Marcus_A · #2 (**permalink**) 10-29-03, 14:43

I would check the SQL return code of the commit, and issue a rollback if not zero.

ppdeepa · #3 (**permalink**) 10-29-03, 15:09

Quote:

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!

Marcus_A · #4 (**permalink**) 10-29-03, 15:24

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).

Internet Services

Web Development

Digital Marketing

Consumer Tech