View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 05:19 AM
db2group88
 
Posts: n/a
Default about configure automatic maintenance window

Hello,

we are using db2 udb v8.2 on windows.
if we need to run a reorg and runstats monthly, i think the best way
to do them is via the tool "Configure Automatic Maintainance". I find
out that for reorg, it has to be done offline. So I should schedule the
offline timing for reorg and online timing for runstats. Will the tool
automatically makes the database offline? What is the best time for the
process happen? Should i put them to different date? How should i
schedule the days of the week and the days of the month? Any other
thing i need to be careful about? thank you

Reply With Quote