IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

job is running continously and it is never ending


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Thu Mar 13, 2008 10:47 am
Reply with quote

Hi,

There is a job running from last five years and it is to took 3 to 4 hrs.
But from last couple of days it is running beyond 24 hrs and it is never stopping. And from the code prespective no changes took place.

I am looking at database prespective that any thing went wrong and making the jobs running forever. like unable to close the database..etc

can you please through some light on it.

Many Thanks,
Jai
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Thu Mar 13, 2008 7:21 pm
Reply with quote

Hello,

My first guess (without any background info) is that either there has been a problem in the code that has finally been "met" or more likely, the data content has changed so that some unexpected condition has been reached.

If you have statistics on how many rows are in the tables used by this process and can see a big increase recently, this may be causing the longer run times.

In some test environment, can you load the data from last week and see if that runs quickly or if that also now runs longer?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Running REXX through JOB CLIST & REXX 13
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts Running a Job with the Default User ID JCL & VSAM 2
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top