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 with QUICKSTART

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

New User


Joined: 20 Apr 2005
Posts: 8

PostPosted: Wed Jan 31, 2007 8:22 pm    Post subject: DB2 Commit with QUICKSTART
Reply with quote

I have a COBOL program that inserts rows to a table. My program does not have a COMMIT statement in it. The program is restartable using QUICKSTART. I noticed that when the program abends, it does not rollback all the way to the beginning of the program. I can see the records in the table that it was inserting in to. Does it have to do anything with QUICKSTART?

One more question. Do I need to take a checkpoint after each INSERT to the table?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 31, 2007 11:49 pm    Post subject:
Reply with quote

Hello,

I'm not familiar with Quickstart but it may have an option that causes a checkpoint after each iteration. Check your settings and defaults for parameters not set.

The only time you want to checkpoint after each insert is when you want NO data to be backed out. This is usually not desired. Checkpoints are best used at the end of a logical-unit-of-work(LUW) or when the program ends. Part of the decision of when to checkpoint is how you want any restart capability to work.
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 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 DB2 Commit thru Xpediter kinatingopi DB2 4 Wed Apr 30, 2014 4:46 am
No new posts Regarding commit in cics calling db2 ... ram_vizag CICS 7 Wed Feb 05, 2014 10:56 am


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