How can i start with 51st record for next time

pathuri.anji · New User Joined: 05 Dec 2007 Posts: 1 Location: bangalore

Hi,

I have a question related to db2 tables

Q) I have a table with 100 records.while reading the records i got

abend at 50th record then how can i start with 51st record for next time?

Regards

dbzTHEdinosauer · Posted: Thu Jan 31, 2008 2:13 pm

keep track of how many rows (record is term that relates to files/ row is the term for DB2) you process during the run and insure this counter/place-marker is available each time your program runs.

dbzTHEdinosauer · Posted: Thu Jan 31, 2008 5:54 pm

This is restart philosophy.

you have not mentioned the activity/process you are executing.

It can become complicated based on:

if you update the rows and have no commit, then you need to start at the beginning after an ABEND. (do not confuse ABEND with a non-zero SQLCODE, they are not the same.)
if you have a commit interval, your counter would be based on the point of last commit
if you have an output file, you may or may not need to use OPEN output extend when you recognize a restart process
normally, each shop has some type of 'RESTART' table which contains indicators as to counts, whether this is restart or fresh start

Basically, you need an external (from the program - like restart table) source to tell your program if it is a fresh start or a restart. you need to have logic to start your db2 process at the proper place as well as positioning any output vsam/qsam files.

lot depends on if this is batch or online. what I have described is a batch restart process.