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
 
checkpoint restart logic in an IMS DL/I code

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

Active User


Joined: 14 Aug 2006
Posts: 198

PostPosted: Wed Jul 15, 2009 10:53 am    Post subject: checkpoint restart logic in an IMS DL/I code
Reply with quote

Hi,

What is the best procedure for implementing check point re-start logic in a DL/I code.

My code updates the DL/I DB. So if the program abends in middle of a transaction I want to roll back to the last completed transaction. One transaction involves reading a DB1, Updating DB2 and inserting into DB3.

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

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Jul 15, 2009 6:07 pm    Post subject:
Reply with quote

Is it a huge database? How long does the job run? You are running DLI or BMP?
Back to top
View user's profile Send private message
abin

Active User


Joined: 14 Aug 2006
Posts: 198

PostPosted: Thu Jul 16, 2009 6:08 am    Post subject:
Reply with quote

Yes it is a huge data base and it is a DLI program. The run time execution cannot be calculated now since the job is not yet in production. But on an average 2 - 3 Hrs.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Jul 16, 2009 6:53 am    Post subject:
Reply with quote

So it has been running for a while now and you are now just wanting to implement checkpoint-restart? Why? I also assume that you did a backup and restore procedure before considering checkpoint-restart? Have you had abends? Why?
Back to top
View user's profile Send private message
abin

Active User


Joined: 14 Aug 2006
Posts: 198

PostPosted: Thu Jul 16, 2009 11:55 pm    Post subject:
Reply with quote

actually this is a new process and is not running in production yet. So I was checking on the best procedure to follow.

The reason I am looking for re-start mechanism is because there may be abends and I do not want to re-start the entire job from start.
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 17, 2009 12:05 am    Post subject:
Reply with quote

Hello,

Quote:
because there may be abends
Sorry, but there should not be "regular" abends - the code needs to be abend-proof.

Quote:
I do not want to re-start the entire job from start.
Why not? If the job abends every year or 2, the complete rerun will be far more managable than some more complicated restart/recovery process.

If there is unwillingness/inability to make the code abend-proof, it is unlikely that a proper restart/recovery process would be implemented.
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 Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm

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