Nothing to worry in this case... Any how you are saying that job abended at 250 th record. Check the 250 th record you required updates or inserted at 250 th row.
Basic thing you need to understand is once the job completed normally or abnormally commmit will be done.
Nothing to worry restart as from abended step. In this case you have to know if any scheduler constraints there.
Note: Db2 won't allow more than 10,000 record updates in one job without commit.
is there any specificlimit that we cant update more than 10000 records b4 commit if so suppose if i give more space to the records for update what happens becoz after giving commit only the records are stored in the table is it correct
