IBM Mainframe Forum Index
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in

Long Running Jobs

IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus

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

PostPosted: Sun Nov 10, 2013 6:07 am
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 All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1


Search our Forum:

Similar Topics
Topic Forum Replies
No new posts List of Active Jobs in CTRL-M JCL & VSAM 1
No new posts APCT Abend while running an online CI... CICS 1
No new posts JCL ERROR - Opernad too Long JCL & VSAM 4
No new posts Running rexx on zOS with JCL CLIST & REXX 3
No new posts Running a REXX exec program using ZOSMF CLIST & REXX 3

Back to Top