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 calls in IMS/DB2 programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
rosmi joseph

New User


Joined: 17 Sep 2007
Posts: 68
Location: Kochi

PostPosted: Fri Jul 10, 2009 10:22 am    Post subject: COMMIT calls in IMS/DB2 programs
Reply with quote

Hi,

Can anyone please let me know if we can use COMMIT calls in IMS/DB2 programs.

I have an IMS/DB2 program that does not have any check point re-start logic. It reads an input file, checks few data in IMS database and updates the DB2 table. Wanted to introduce a COMMIT call after each 10,000 records updated in the table. Will this work out?

Or do I need to go for a checkpoint re-start logic itself?

Thanks.
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: Fri Jul 10, 2009 7:16 pm    Post subject:
Reply with quote

Hello,

Adding COMMITs implies that checkpoint/restart logic is also needed. . .

Suggest you re-examine the desire to add checkpoints - many systems rerun from the beginning of the job as this is often cleaner/faster than trying to restart "in the middle" (unless the restart operation is already in place and works smoothly).

The faster cpus and dasd make a full rerun a better choice than restart/recovery for most jobs.

When used, restart/recovery design should not be done at the job level, but rather at the system level so everything is consistent.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts pointers on using USS and C programs. Pedro All Other Mainframe Topics 0 Wed Oct 04, 2017 4:38 am
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm

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