Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
commit/rollback in cics

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Thu Apr 06, 2006 9:52 pm    Post subject: commit/rollback in cics
Reply with quote

Hi,

Please help me to understand the following scenario:

There is C program containing DB2 (sql) and CICS commands.
I do some operation and then comes out of program with the following statement in case of some error
exit(3)

Will CICS call a commit or rollback.

Let me know if u want more description

Regards
Rashmi
Back to top
View user's profile Send private message

Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Sat Apr 08, 2006 11:11 am    Post subject: Hi
Reply with quote

Hi,
Unless the program Completes succcessfully...The changes made will not be commited..

If you want to commit the changes..You should isse a syncpoint externally.


Exec Cics
syncpoint
End-Exec.

As the programs is abending the Program commits the changes till the last sync point...


Cheers,
JAG
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Mon Apr 10, 2006 1:06 pm    Post subject:
Reply with quote

Hi,

You are right that unless i call syncpoint cics will not commit but currently something like this happening in my program (suspected)

somewhere in my program due to some failure my program comes out by simply executing the statement exit(3); there is no abend occured.

Now what i can see from my data this transaction is commiting data even after the last syncpoint.

So could you please explain if my suspecion is right.

Regards
Rashmi
Back to top
View user's profile Send private message
balusengodan

New User


Joined: 01 Mar 2005
Posts: 15
Location: chennai

PostPosted: Tue Apr 11, 2006 4:48 pm    Post subject:
Reply with quote

hi
u are right unless otherwise u 'r going to issue syncpoint command it is not possible to commit the changes
balu.a
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts Call COBOL or PLI with a click from w... vaibhav gs All Other Mainframe Topics 1 Mon Apr 16, 2018 7:29 pm
No new posts How do I define a DB2 plan for a web ... John Poulakos CICS 4 Sat Apr 14, 2018 1:58 am
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts Limit in Length for a CICS START seahawk789 CICS 6 Mon Apr 02, 2018 8:34 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us