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

 

job is running continously and it is never ending

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: job is running continously and it is never ending
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

Site Director


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

PostPosted: Thu Mar 13, 2008 7:21 pm    Post subject:
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    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 Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm
No new posts Jobs from iseries not running in sequ... lyd All Other Mainframe Topics 4 Mon Jan 18, 2016 1:17 am


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