Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us