Hi guys,

I'm a relative n00b when it comes to DB2, and still learning as I go, but there is a lot to learn where DB2 is concerned!

Anyway, I have a little issue that I can't seem to find the answer to in any books or via Google searches.

On one of the DB2 installations that I am monitoring, when I run a 'health snapshot' it's returning an alert state of 'Attention' constantly, with a timestamp of 2010 :
Code:
    Indicator Name                             = db.tb_reorg_req
       Value                                   = 1
       Evaluation timestamp                    = 11/21/2014 09:41:13.244760
       Alert state                             = Attention

          Collection:

             Name                              = "REJECTS"."USER_DESC"
             Detail                            = REORG TABLE INDEX; SQL-<F8><FF><FF>
             State                             = Automation failed
             Evaluation timestamp              = 08/14/2010 04:00:00.000000
I've ran a reorg on the indexes and the full table and yet each time I run a health snapshot, it keeps returning the same result. Is there anyway that these can be purged, or reset ? This is on V9.1.

Any help would be greatly appreciated :-)

Cheers