Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

PErformance Tunining Cobol-Db2 Program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Madhu Sudhan Reddy.O

New User


Joined: 15 Aug 2006
Posts: 5

PostPosted: Tue Aug 15, 2006 5:42 pm    Post subject: PErformance Tunining Cobol-Db2 Program
Reply with quote

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.
Back to top
View user's profile Send private message

prasadvrk

Active User


Joined: 31 May 2006
Posts: 200
Location: Netherlands

PostPosted: Thu Aug 24, 2006 8:13 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Mon Aug 28, 2006 4:01 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Madhu Sudhan Reddy.O

New User


Joined: 15 Aug 2006
Posts: 5

PostPosted: Mon Aug 28, 2006 5:40 pm    Post subject: Thanks
Reply with quote

Hi

Prasad and Surya,

Thanks For you Replies.
Madhu Sudhan Reddy
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm
This topic is locked: you cannot edit posts or make replies. COBOL Software Development Lead at Fi... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:21 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us