PErformance Tunining Cobol-Db2 Program

Madhu Sudhan Reddy.O · New User Joined: 15 Aug 2006 Posts: 5

1.I need To do Cobol-DB2 Program Performance Tunning , Could anyone tell us how to do and what are all the steps Need to be taken care for
making the program work in a more efficient way

2. The Cobol -DB2 program is in Unstructured highly complicated , I need
to make it in a more structured and easy way by making the program
work as per its functionality.

Your suggestions are always welcome, Can you also mail me to
reddmadhu@gmail.com.

prasadvrk · Posted: Thu Aug 24, 2006 8:13 pm

1) For starters, check if there are any 'select *' s in the program and see if all the fields are being used in the process, if they are not then select only those fields which are being used. Also if any of the fields not used are dropped later the program does not need changes, simple compile will do.

See if any of the queries can be clubbed together in to joins.This will improve the performance.

Remove any unnecessary calls to DB if present

2)If there are any if else loops , replace them with evaluate end-evaluates . To the extent possible avoid any backward GO TOs.
Understand the flow and to the extent possible adopt top down approach.
Break down the code into meaningful paragraphs where ever necessary.
Follow indentation strictly, it will not only improves the readability but helps you in understanding complex if else loops.

This is all I can think of for the present, If can get any useful info I will post down the line.

surya_pathaus · Active User Joined: 28 Aug 2006 Posts: 110

Hi,

We can improve performance of DB2 like

1) If selecting rows from table and processing then try to take unload into a dataset thru JCL and use dataset in the COBOL Program.

2) User cursors.

3) In the query, mention column names in sequence how they are declared in table.

4) Dont commit records frequently.

Madhu Sudhan Reddy.O · New User Joined: 15 Aug 2006 Posts: 5

Hi

Prasad and Surya,

Thanks For you Replies.
Madhu Sudhan Reddy