Mainframe, MVS and zOS Discussion

Hi,

Can we use DB2 commit in CICS? In coding practice it is said that it is not allowed but if use it then what happnes? Will it affect other programs too?

if it was allowed the DB2 and NON DB2 resources will get out of sync in case of abends, rollback, recovery, restart

in a transaction with no explicit commits
in case of an abend all the resources will be restored to the start of transaction state

after a db2 only commit ( if it was allowed )
the NON DB2 resources would be restored to the start of transaction state

while the DB2 resources would be restored to the AFTER THE COMMIT state

so out of sync

Thanks for the answer enrico but if someone wrongly codes it, what wrong can happen. I mean I understand from your answer that it might create a problem in restart but can it be like the CICS itself faces some problem?

What wrong can happen? Until the mis-match in data was found all processing would be invalid involving restores and reruns going back an unknown number of hours/days. CICS (if it allows it) doesn't give a toss - it is only a program. The people who use the information will be mightily annoyed and the person who made the mistake - and those who tested the code would be seriously red-faced if not looking for a new job.

Thanks for the answer enrico but if someone wrongly codes it,

thats what code reviews should prevent