job is running too long



IBM's flagship relational database management system

Re: job is running too long

Postby BrantleyL1 » Wed Oct 26, 2011 2:01 am

Two thoughts...

1) That appears to be a SERIOUS (it said so) DASD error. I suspect that the DASD may have been failing and it kept trying to write it. I would have your operations folks look at that. May need to back up/reload to a different pack.

2) My first thought was "when was the last time a RUNSTATS was run on that table?" But the first thought is likely the cause of the problem.
BrantleyL1
 
Posts: 1
Joined: Wed Oct 26, 2011 1:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: Re: job is running too long

 

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post