Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Commit thru Xpediter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kinatingopi

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Wed Apr 30, 2014 4:46 am    Post subject: DB2 Commit thru Xpediter
Reply with quote

Hi,

I am trying to execute a DB2 COBOl program thru xpediter and seeing that the commits are done even though I exit the xpediter in the middle of execution. Does xpediter commit a record as soon as the SQL is executed or should it wait until we come out of xpediter normally (without doing an EXIT in the middle of execution).

Thanks, Gopi
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Apr 30, 2014 12:15 pm    Post subject:
Reply with quote

Quote:
I am trying to execute a DB2 COBOl program thru xpediter and seeing that the commits are done even though I exit the xpediter in the middle of execution. Does xpediter commit a record as soon as the SQL is executed


You have self answered the question.
Quote:

should it wait until we come out of xpediter normally (without doing an EXIT in the middle of execution).

It really depends on COMMIT, if it is successful then changes would reflect in the DB.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Wed Apr 30, 2014 1:23 pm    Post subject: Reply to: DB2 Commit thru Xpediter
Reply with quote

Xpediter does not COMMIT. It traces your program. Your program does the COMMIT. If it doesn't do a COMMIT then you should read up about COMMIT as used/not issued in a program.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Wed Apr 30, 2014 5:52 pm    Post subject:
Reply with quote

The normal behaviour of any DB2 program, whether running under Expeditor or not, is to Commit changes when the program terminates normally.

If you do not want your changes committed you need to take some action during your debugging session, such as forcing an Abend.
Back to top
View user's profile Send private message
kinatingopi

New User


Joined: 30 Apr 2014
Posts: 6
Location: USA

PostPosted: Wed Apr 30, 2014 11:57 pm    Post subject: Reply to: DB2 Commit thru Xpediter
Reply with quote

Thanks everyone for the reply.. It was my bad. I shud have to done a QUIT from xpediter instead of 'EXIT' as the former is abnormal exit, but later is normal exit (which caused the commit to occur).
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Commit limit for Delete query through... mf_karthik DB2 10 Thu Dec 17, 2015 12:56 am
No new posts Weird test results when Xpediter is t... Crunch Compuware & Other Tools 6 Tue Oct 06, 2015 7:48 pm
No new posts Commit a DB2 Table on Unix Server and... Vinodh S DB2 3 Sun Apr 12, 2015 5:05 am
No new posts Need information on DB2 COMMIT sivasaras COBOL Programming 9 Wed Jun 11, 2014 7:34 pm
No new posts XPEDITER not taking PARM value sanjay sahu Compuware & Other Tools 2 Mon Apr 28, 2014 3:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us