Page 1 of 1

DB2 Failure - CURSOR

Posted: Mon Aug 24, 2009 3:31 pm
by biswaranjan

There is a DB2 program. Which performs commit after 1000 Records are processed.
Suppose the JCL is submitted for running this DB2 Program for consider 2500 records. In between processing it fails at 2200th record.
How will you Rollback the last 200 records or how will you restart the processing with changes in JCL so that it requires minimum reprocessing of the records that are not committed.