SEO

#1 (**permalink**) 02-27-2008, 05:19 AM

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

#2 (**permalink**) 02-27-2008, 05:20 AM

The current level of DB2 V8 does not yet allow for online reorg to be
selected in auto maintenace.
You can still use auto maint. but the reorg will be done offline.

Only the table will be put off line, not the db nor the tblspc.

You can schedule a maintenance window for each of online time and off line
time. As in:
On Line time from 20:00 for 6 hours
Off line time from 02:00 for 4 hours
Or whatever fits.
The GUI interface from the control center allows you to specify that. It
will also alow you todefine the days of week or month or everu other or
what...

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"db2group88" <tulip05@gmail.com> a écrit dans le message de news:
1131480609.264784.189950@z14g2000cwz.googlegroups. com...
> 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
>

#3 (**permalink**) 02-27-2008, 05:20 AM

Hello Pierre,

this tips really help, one more question, if i want it happened once a
month, how can it specify on the days of the weeks and days of the
months?

if the database size is about 3 G, how much time it would take to
reorg?

thank you

#4 (**permalink**) 02-27-2008, 05:20 AM

To be more specific, if i want it happens on the last Saturday of each
month, how to do it? thank you

#5 (**permalink**) 02-27-2008, 05:20 AM

On the Ctl. Ctr. Choose Tools--> Wizards-->Configure Auto Maintenance
Choose the Db where you want to reorg
You can only choose tables, not the whole db.
Choose Change for automation settings and next
On timing choose the offline window and select change
Specify All days of the week
Choose Days of the month and choose Only on Last Day of Month and select OK
Choose Activities and select REORG, decide if you want to notify and select
automate
Then select configure settings to choose which tables.
You'll have to complete the select statement by supplying the where clause
to isolate which schema name and /or tabname you want to reorg.

Good luck.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"db2group88" <tulip05@gmail.com> a écrit dans le message de news:
1131493126.159301.56170@g49g2000cwa.googlegroups.c om...
> To be more specific, if i want it happens on the last Saturday of each
> month, how to do it? thank you
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

about configure automatic maintenance window