IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

COMMIT calls in IMS/DB2 programs


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Fri Jul 10, 2009 7:16 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts Finding Assembler programs PL/I & Assembler 5
No new posts Recompiling programs after a copybook... COBOL Programming 1
Search our Forums:

Back to Top