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?
Can we use DB2 commit in CICS?
-
- Registered Member
- Posts: 62
- Joined: Sat Jun 29, 2013 1:45 pm
-
- Global Moderator
- Posts: 827
- Joined: Wed Sep 11, 2013 3:57 pm
Re: Can we use DB2 commit in CICS?
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
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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
-
- Registered Member
- Posts: 62
- Joined: Sat Jun 29, 2013 1:45 pm
Re: Can we use DB2 commit in CICS?
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?
Re: Can we use DB2 commit in CICS?
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.
Regards
Nic
Nic
-
- Global Moderator
- Posts: 827
- Joined: Wed Sep 11, 2013 3:57 pm
Re: Can we use DB2 commit in CICS?
thats what code reviews should preventThanks for the answer enrico but if someone wrongly codes it,
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute