After 100 rows are updated i use th COMMIT option.
Why? It does not sound like this has been planned but rather just happened (read on).
what are the necessary steps i have to be taken care when i am restart the job the once again.
Without knowing this, it makes no sense to arbitrarily COMMIT. The restart process should be in place and understood before
code is written that might want to use it. This is actually how/when a checkpoint is taken. When COMMIT/Restart is used
, it is most often used at a logical unit of work (luw).
I want some implementation code for this one.
Not really a valid request. Someone may post something
but it will be a complete guess as no one knows how your environment is configured. You need to talk with the people who support your environment and learn how this is handled on your system. There are many ways to implement restart/recovery and they all are site-specific.