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 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
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Getting S0C4 while running COBOL Data... kalakuntlavenkat COBOL Programming 4 Thu Feb 26, 2015 8:48 pm


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