Page 1 of 1

COBOL DB2 Program tuning

Posted: Mon Dec 13, 2010 9:33 pm
by hparthas
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

Posted: Fri Dec 24, 2010 5:59 pm
by Natarajan
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...