How to Restart from particular record

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Hi All,

I had requirement like this after fetching and subsequent insertion of 100 records the program get abended but the fetching table contains 1000 records.

So how to restart from 101-th record please give me the solution with example codes.

Craq Giegerich · Posted: Tue Nov 20, 2007 2:14 am

Has your program done any commits.

If NO then you will have to fix the abend cause and rerun.

If YES then you will have to have someway in your program to determine that it is a restart and where it should restart from. Check with others on your project and find out what is accepted practice for this.

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Yes after insertion we have commits but it has not implemented yet. tel us how to implement commit along with restart logic.

dick scherrer · Posted: Tue Nov 20, 2007 8:54 am

Hello,

Until your group defines how restart will be supported across the environment or the application, i'd suggest you comment out the commit statements. When there is an abend, the work to that poit will be backed out (and yes, if it is a high volume, it will take a while).

Once you have designed your restart/recovery strategy, you can activate the commits as you incorporate the restart processing.

Someone here in the forum cannot effectively determine your strategy. Once you have a plan in place, we may be able to offer suggestions if there are questions.

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

In my application each and every program must need to incorporate the commit and restart logic because almost all the programs does updates and insertions.

So some one can help me out how to incorporate?

dick scherrer · Posted: Tue Nov 20, 2007 10:52 pm

Hello,

Please re-read my previous reply.

While restart logic may be needed in "each and every program", each should not be treated as a new challange.
Your organization/project team needs to decide how restarts will handled cross the project. When you are going to restart bacth processes, ther is more to it than just doing the proper database processing. Any sequential files being created, any reports being created, any accumulated totals in these processes need to be considered.

Once you/your organization make a plan and determine your needs, we may be able to offer suggestions. We cannot establish the rules for your system - that needs to be determined there.

Due to the time it takes to "start from scratch" to create a restart methodology and due to much faster machines/database engines, the decision has been made in many applications to forego checkpoint/restart processing. In the rare event of an abend, it is often faster to simply restart the abended from the beginning (after the backout completes).

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Thanks for your response I agree with your suggestion as per my client intimation I need to incorporate restart logic. the scenario like this...

I am fetching data from 'A' table according certain match condition the table 'B' will be inserting the records but after records fetching and inserting the program has been abend due to data problem.

Now tel me solution for this one program? please don't think about total system and applications because my client won't worry about databases,cost as well.

dick scherrer · Posted: Wed Nov 21, 2007 3:43 am

Hello Vadie,

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Hello Dick,

In my application no one has been defined how to defined the restart and where to include the restart so we have to defined the restart logic.

The program which I specified nothing is doing apart from reading and inserting.

stodolas · Posted: Wed Nov 21, 2007 7:27 am

Then why even separate the read and insert? If you are doing no processing on the data and writing to only one table, your program is waste of time to write. DB2 could handle this with no program logic wrapped around it. Then the only way it would abend is on a Timeout (which would auto rollback) or a failure of DB2 (which means you have more problems than you as a programmer want to deal with). Restarts handled, just start from the top again either way.

INSERT INTO TABLEB SELECT xxxxxx FROM TABLEA

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Thanks steve forget about all things what we discussed above because I got confusions due to where & when the restart logic needs to be implement.

So can you please give me example and explain how to implement restart logic in COBOL+ DB2 program?

Or else please show me one program the restart logic was implemented.

stodolas · Posted: Wed Nov 21, 2007 9:31 am

A request for restart logic in a DB2 Cobol program is so generic that the only answers that can given are to generic to be useful at the level you seem to desire. It is no better than saying, I am processing a non-keyed file. Give me an example of restart logic. Or, I am processing a tape file give me an example of how to restart on an abend?

What has the business defined as the restart procedures? Do they want you to be able to restart from the middle or start again from the top each time? You haven't even given us what your rules are. Once you can actually define your process so we can understand it, maybe we could help.

Are you tracking successful records? Are you commiting after each insert or after every 50? If you get 49 successful inserts and the DB2 insert statement fails for record 50 are the first 49 going to rollback or will you do a commit and remove them from your input set for a restart? Are you not tracking success and just hoping that it works right the first time through and if not... well crap we gotta go digging now? Are you writing data to a temporary pointer file so you know where to restart? If you are producing reports from this data will a restart provide complete report data if you don't reprocess the successful records or are 2 partial reports ok? IF the first one abends though you won't have a report, so what then?

Your question just has too many holes for us to provide anything useful to you. There are design considerations that it looks like you haven't even considered here and you are just looking for an example that may not even be applicable to your situation.

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Thanks steve really as a beginner i don't know these much of procedures involving in restart logic like design,business considerations. Just I want to see how the restart logic code has been implemented in DB2 Cobol program.

As per your determination we will take it as business has defined the restart has to be restart from middle of the business now tel me ways how we can start from middle?

dick scherrer · Posted: Thu Nov 22, 2007 9:13 am

Hello Vadie,