I m currently running a job to update the salary of the employees for 2008 and i have a commit logic for comminting after 1000 rows.now if i have to restart my job which suppose abended after updating 2000 records out of a total of 20k records, i found 2 solutions to it..
a) get the timestamp field added to the salary update table and from the cursor exclude the rows for which salary have been updated for 2008 by checking timestamps.
b)second method was using db2 checkpoints but i dont how to use them in the progam.
Now which of the two solutions should i go for and new ideas are always invited.
Also if you have link about how to use db2 checkpoints please provide me so as i cudnt find the same in sql reference and appplication programming guide for db2
Thanx in advance
This link is different requirement than one asking for.
Hi Prashanth, The link you had given here is for STARTING OR RESTARTING DB2 System when system goes down.
But Suny asked for Check Point and Restart Logic. That, we usually adopt in program logic.
Many Application uses this logic with different scenerio.
In our application we are calling pgm to do so. In this, we are checking rec-count, based on this we will make the entry in DB2 table(we are using separate table as check_point_table). And hence pgm will refer the same in check_point_table when next time you run the pgm.
But Same can be achieved, If you are running a IMAGE utility for DB2 in your job(I am not sure about it, But it may be CA11 PROC, IF any one knows it please answer for the same).