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 issue in a process. Cant identify where

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Thu Mar 15, 2007 3:13 pm    Post subject: Performance issue in a process. Cant identify where
Reply with quote

hi

i am looking at a ongoing process where files are received from different LPARS to my lpar. here a run task is executed which in turn triggers many JCLs which run cobol db2 programs to insert the data into tables of database.

i am unable to find out where and which part of this process leads to the major part of performance.?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 15, 2007 7:37 pm    Post subject:
Reply with quote

Hello,

Depending on your specifics and the volume of data received from the other lpars, the inserts (if done individually) may be where you spend much time. Inserting a single row is expensive - especially it there are multiple alternate keys.

I'd suggest looking into loading a batch of rows, rather than individual inserts.

If your input is hundreds of millions of rows, it will take time regardless of how they are put into DB2.
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 -> All Other Mainframe Topics 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 Process file after 7 days of hold charlessxavier All Other Mainframe Topics 4 Tue May 22, 2018 3:54 pm
No new posts CICS-MQ connection setup issue kaushikv CICS 3 Wed Mar 21, 2018 8:10 pm
No new posts Need Help!!CEE library issue while br... kaushikv CICS 9 Fri Mar 09, 2018 6:06 pm
No new posts Need to identify top 10 costly or tim... ashek15 DB2 4 Wed Feb 14, 2018 3:20 am

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