I have a Db2 9.5 workgroup FixPack 2 on Windows 2003. I have a task created in the Task Center, that runs every 5 mins after end of last execution. The task is configured to send email notification on failure.
I had a failure around 2 weeks back, and stopped the task, and stopped the instance, corrected the error, and got the task running again.
However, I still continue to receive the error emails saying Task not successful with Return Code -843. I have tried shutting all processes, shutting the instance, forcing all applications in Control Center. Nothing works. I just keep getting notifications, a flood of them every day.
You need to determine what is reporting the "failure". What criteria is it using to determine that there is a failure and to send the notification?
We had an incident where an automated process kept reporting a failure after an initial failure, but every run after that was successful. What was happening was that the process was writing success/failure messages to a file and then later in the process, the file was being read to determine if a failure occurred and send a notification if there was. Well, if the file was never cleared after the initial failure, and the process that checked the file kept seeing the failure message in it and thus reported the failure.