Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012

    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?

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts