About Restart Logic in VSAM-DB2 Program

sudheer648

Hi,

When reading a VSAM file and updating database with information read from file in between if Job Abends how to Restart the Job

I Guess developer would place some logic in Program to handle such scienarios ...need inputs on this.

pbgunasekar · New User Joined: 28 May 2005 Posts: 28

hi sudheer,

i didnt work this please try this....

Create an dummy dataset and insert one dummy record in it ..in ur procedure division read this record and using start key place the point there and move the record to working storage and insert it into table...
Add one counter variable for every 1000 records give one commit before commit please write that last record in that dummy dataset....if u got any error read the last record in that dummy dataset and place that point in that dataset with start key...
please try it if any feedback pls inform me...
waiting guna

sudheer648

Hi guna,

Suppose if Job abended before atleast a commit point then how to handle the situation.

I think since commit is not reached the database would be rollback automatically.we need to start all from beginning.

Corrections are invited.

radhakrishnan82 · Posted: Wed Jun 01, 2005 11:32 am Post subject:

Timestamp logic will sove this issue.

ronie305 · New User Joined: 09 May 2005 Posts: 3

this is a typical commit-restart logic....

have a table maintained holding info as:

pgm name
module name
time stamp
counter

when job abends restart from here... store last position where u had commited for restart position.

in sql u can specify : record > last commit position.

pbgunasekar · New User Joined: 28 May 2005 Posts: 28

hello
i think this is the way .. my friend is working and told they r having one utility namely RESTART in that they register their program it atomatically restart the program where it got abends... i dont know exactly but he told me like this...pls enquire and give feedback
waiting
guna