Unanswered: DB2 Automatic maintaince questions. How do I know it is working?
I have Db2 V9 Automatic maintaince is on. I have both an online and offline maintaince window defined. I can not tell if any databases are getting reorged. How do I find out what was reorged? Is there a MSG in db2diag.log?
Also, do I need to stop all my applications connected to the database before my offline maintaince window?
I think you should see some messages in the db2diag.log. You can also check the history file (db2 list history reorg....). I would not rely on automatic maintenance and schedule my own scripts to do it.