Hi,
I'm coding new COBOL DB2 program.
Could someone can let me know any tips which would improve the performance of the processing. I'm sure my program will process more than 10 millions of records everyday, and mostly its database insert/update code after validation process. I'm sorting the file based on the primary key in the file and its successors.
It would be great if there is any document to refer or and tips to code my program very effectively.
Thanks in advance for your valuable input.
Best Regards,
Harikrishnan
COBOL DB2 Program tuning
Moderators: Kalicharan, Moderator Group
some of my suggestions..
1. since you are processing more records.. make sure you do commits
for less intervals.. aprrox. 25 to 50 records.
2. Make sure you defined enough buffer pools... DBA has to take care of this
3. while updating records, make sure you use the all indexed fields in the db2 sql query.
once you complete your first 10 valid post in this site.. you are eligible to get db2 e-book available at
http://www.mainframegurukul.com/products.html
in this e-book.. there is a chapter on SQL Optimization techniques.... it may be useful...
1. since you are processing more records.. make sure you do commits
for less intervals.. aprrox. 25 to 50 records.
2. Make sure you defined enough buffer pools... DBA has to take care of this
3. while updating records, make sure you use the all indexed fields in the db2 sql query.
once you complete your first 10 valid post in this site.. you are eligible to get db2 e-book available at
http://www.mainframegurukul.com/products.html
in this e-book.. there is a chapter on SQL Optimization techniques.... it may be useful...
Natarajan
Chennai
Chennai
FREE TUTORIALS
Tutorials
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.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
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