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
No new posts SIGNAL ON HALT issue packerm CLIST & REXX 1 Fri Oct 20, 2017 6:56 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts CONTIG for performance? JPVRoff JCL & VSAM 8 Fri Jun 09, 2017 8:39 am

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