If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Weird "problem" - Task Center thinks a backup is still running from WEEKS ago!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-01-06, 21:38
meehange meehange is offline
Registered User
 
Join Date: Jul 2004
Posts: 256
Weird "problem" - Task Center thinks a backup is still running from WEEKS ago!

8.2 on Windows

A couple of weeks ago there was an unexplained instance failure (seemingly during this backup, possibly even caused by it?). The instance was restarted succesfully and every backup since has executed fine, but I just noticed in Task Center that the task from that night is still 'executing'....
Any ideas? It's not causing any problems, but I'm a little afraid to meddle in case it causes real problems.
Reply With Quote
  #2 (permalink)  
Old 05-02-06, 08:53
jthakrar jthakrar is offline
Registered User
 
Join Date: Mar 2004
Posts: 46
This is very likely due to the "tools" catalog not in-sync or not having the capability to query and restore the state. Would suggest oppening/logging a PMR with IBM on this.
Reply With Quote
  #3 (permalink)  
Old 05-03-06, 17:31
angel_s angel_s is offline
Registered User
 
Join Date: Mar 2006
Posts: 3
Quote:
Originally Posted by meehange
8.2 on Windows

A couple of weeks ago there was an unexplained instance failure (seemingly during this backup, possibly even caused by it?). The instance was restarted succesfully and every backup since has executed fine, but I just noticed in Task Center that the task from that night is still 'executing'....
Any ideas? It's not causing any problems, but I'm a little afraid to meddle in case it causes real problems.
We had this problem before, you can leave it there, if it is a scheduled job, it shouldn't affect your next run. But you can fix it by a little bit meddling.

1.Find the record for this job by job ID in your tools database in the table TOOLS.MDTASKTYPE00, changed the value of column STATE00 to 1. This will change the status showing in the task center back from running to successful.

2.Drop and recreat this job in the task center. You will have to drop and recreate it, since the step one doesn't fix it, it just allows you to modify it.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On