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
 

 

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 UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts Restart=Step not working ALAK SAHA JCL & VSAM 6 Fri Jun 30, 2017 6:28 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am


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