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


Long Running Jobs

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Milan Mishra

New User

Joined: 09 Nov 2013
Posts: 1
Location: INDIA

PostPosted: Sat Nov 09, 2013 7:17 pm    Post subject: Long Running Jobs
Reply with quote

Hi.This Is My First post .If any Mistakes I apologies. Before i posted my query here I searched related to this query.I found few questions and Answer but not similar to the situation I am facing now.

One of My production job was running since last 9 yrs and the elapsed time(.17) was very less.Job was getting completed within a minute.

As a part of recent changes we introduced a Stored procedures for this module.This module reads input file which have everyday almost 2.5 lakhs of record now the job runs for almost 1hr.

Only actions were performed on this modules are

1) We checked out the module using Endevor and processor group got changed than production

2) Without any changes The same production Load(Compiled with diffrent processor group) also took > 1hr in test region

3) Now We introduced a stored procedure.this also takes > 1 Hr

for each record now there are more DB2 table operation

Now i am getting question why this job is taking so much time after Implementation.But unable to reply because the same production source when compiled with different Processor group (Without making any changes to the source) is also taking huge time in test. i am unable to reply bcoz I have no answer for my own for below queries

Before change =(5 Db2 Select +1 Db2 Update or Insert) * 2.5 lakh record s was taking less than a minute In Production

During testing =(5 Db2 Select +1 Db2 Update or Insert) * 2.5 lakh record s is taking more than one hour in Test

After change = (10 Db2 Select + 1 Db2 Update or Insert) *2.5 lakh record is taking more than one hour In prod

I don't have absolutely no control for that 5 Extra DB2 Select becuase that changes were done by some other team

1) How this job was able to complete within 1 minute prior to Implementation. Does change of processor group impacts Execution time i don't think so..

2) What are the areas i need to look into. I have absolutely no clue what to reply..need some Expert advise.
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: Sun Nov 10, 2013 6:07 am    Post subject:
Reply with quote

Hello and welcome to the forum,

What you have encountered is the risk of implementing multiple changes at the same time. . .

Somehow, it must be determined which change(s) have caused the problem.

Can you get an EXPLAIN from the old execution and the same from the new and see where there are differences?

Is it possible that the new code simply requires this much more resource because it has to do more work?
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts How to show message using batch jobs madprasy TSO/ISPF 7 Fri Sep 09, 2016 6:55 pm
No new posts Don't allow CICS to submit batch jobs prino JCL & VSAM 5 Mon Jul 25, 2016 3:26 pm
No new posts Predicting jobs which are about to re... kpanchabhai85 DFSORT/ICETOOL 4 Thu Jun 30, 2016 7:51 pm
No new posts How to find jobs that are in schedule... anilkumar922 All Other Mainframe Topics 5 Tue Jun 28, 2016 10:01 am

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