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. Issue in suppressing leading zeros &a... Vijay_Sirisha COBOL Programming 21 Thu Jun 07, 2018 8:01 pm
No new posts VBS to VB in COBOL and JCL srajendran2 COBOL Programming 12 Fri Jun 01, 2018 3:04 am
This topic is locked: you cannot edit posts or make replies. Rexx code to find greater then symobl... Bharath Vikraman CLIST & REXX 8 Tue May 29, 2018 9:40 am
No new posts How to convert 2 bytes into single by... pkmurali DB2 6 Fri May 25, 2018 1:41 pm
No new posts SYSADATA - COBOL - Structure displace... ganasrinivasan COBOL Programming 3 Thu May 24, 2018 9:45 pm

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