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.
Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.
1 post • Page 1 of 1
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts.
- Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3.
- DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming.
- SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples
- CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program
- FILEAID Reference
Explains how to browse , edit and delete datasets
- Change Man Reference
Quick Start tutorial on Changeman
- Abend Reference
Important Abend codes explained
- FaceBook Page
MainframeGurukul FaceBook Page
- LinkedIn Page
MainframeGurkul Linkedin Page