I am having the same problem, but have not inquired of IBM yet, because I am already working a backup db problem with TSM support.
On Mon, Mar 21, 2011 at 15:42, Pagnotta, Pam (CONTR) <pam.pagno...@hq.doe.gov> wrote: > Hello, > > Would someone please tell me if they are seeing ANR0293I and ANR0294I > messages in their version 6.2.2 activity log? These messages have to do with > the start and finish of automated reorganizations. I have told Level 2 > support about 10 times, now, that I have never seen these messages in our > logs, but I have not been able to get an answer as to why. We keep 120 days > of activity log, so I have to believe that if these messages were actually > being propagated, I would have seen them at least once in the past year. > > Do you know how to verify that automated reorganizations are running? I > cannot find any indication that they are running successfully, failing or not > running at all, and so far, the Level 2 Support people who have tried to help > me also do not know how to determine this. It seems the answer is that since > TSM is controlling the reorganizations, DB2 will not be reporting on them. > > We have a fairly large TSM database, 544GB with 466GB in use. I am fairly > certain that with so little freespace, automatic, online reorganization of > the larger tablespaces will not happen, but I have no way of verifying if TSM > is even trying. > > I appreciate any feedback. > > Pam > > Pam Pagnotta > EES, LLC, > Contractor to the > United States Department of Energy > 1000 Independence Avenue, SW > Washington, DC 20585 > Office: 301 903-5508 > Mobile: 301 326-7296 > Email: pam.pagno...@hq.doe.gov > -- Andy Carlson --------------------------------------------------------------------------- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
