By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Automatic table maintenance

P: n/a
Hi,

It's no problem to define the automatic maintenance using the wizard
but I want to use commands to automate automation. I captured the SQL
statements when activating the maintenance but that didn't help.

I couldn't find anything about it in the docs so if anybody could
help with this it would be great.

Kind regards, Gert
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Hi Gert,

I'm looking for the same stuff, anyone knows how to enable automatic
maintenance *without* using the wizard but using the commands ?

//bjarke
Nov 12 '05 #2

P: n/a
Hi,

It's in the docs, try searching for "autonomic_switches". The
parameters are at the very end of "db2 get db cfg".

Automatic maintenance (AUTO_MAINT) = OFF
9 Automatic database backup (AUTO_DB_BACKUP) = OFF
9 Automatic table maintenance (AUTO_TBL_MAINT) = OFF
9 Automatic runstats (AUTO_RUNSTATS) = OFF
9 Automatic statistics profiling (AUTO_STATS_PROF) = OFF
9 Automatic profile updates (AUTO_PROF_UPD) = OFF
9 Automatic reorganization (AUTO_REORG) = OFF

Notice that they form a hierarchy, in order for a parameter to work,
all parents in the hierarchy must be enabled too. For example to enable
Automatic runstats, try:

db2 update db cfg using AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_RUNSTATS
ON

Ivan

Nov 12 '05 #3

P: n/a
In article <11*********************@o13g2000cwo.googlegroups. com>,
Ivan Popivanov (po*****@gmx.net) says...
Hi,

It's in the docs, try searching for "autonomic_switches". The
parameters are at the very end of "db2 get db cfg".


This is just a small part of it. Using the wizard it's also possible
to configure on- and off-times. It's also possible to specify a
filter on the tables when defining runstats and/or reorg. I didn't
find anything about this in the docs. I guess it's stored in the
systools.policy table which is updated/read by stored procedures but
it looks like it isn't documented..
Nov 12 '05 #4

P: n/a
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de
news:MP************************@news.xs4all.nl...
In article <11*********************@o13g2000cwo.googlegroups. com>,
Ivan Popivanov (po*****@gmx.net) says...
Hi,

It's in the docs, try searching for "autonomic_switches". The
parameters are at the very end of "db2 get db cfg".


This is just a small part of it. Using the wizard it's also possible
to configure on- and off-times. It's also possible to specify a
filter on the tables when defining runstats and/or reorg. I didn't
find anything about this in the docs. I guess it's stored in the
systools.policy table which is updated/read by stored procedures but
it looks like it isn't documented..


Would it be possible to have a "Show Command" button in the summary panel,
as the one that exists for the configure logging wizard ?

Thanks,

Jean-Marc
Nov 12 '05 #5

P: n/a
In article <42***********************@news.wanadoo.fr>, Jean-Marc
Blaise (no****@nobody.com) says...
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de
news:MP************************@news.xs4all.nl...
In article <11*********************@o13g2000cwo.googlegroups. com>,
Ivan Popivanov (po*****@gmx.net) says...
Hi,

It's in the docs, try searching for "autonomic_switches". The
parameters are at the very end of "db2 get db cfg".


This is just a small part of it. Using the wizard it's also possible
to configure on- and off-times. It's also possible to specify a
filter on the tables when defining runstats and/or reorg. I didn't
find anything about this in the docs. I guess it's stored in the
systools.policy table which is updated/read by stored procedures but
it looks like it isn't documented..


Would it be possible to have a "Show Command" button in the summary panel,
as the one that exists for the configure logging wizard ?

Thanks,

Jean-Marc


Yes, that would be great but my guess is that it's to complicated
which could make impossible to run the commands from the commandline.
But I hope I'm wrong :)
Nov 12 '05 #6

P: n/a
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de
news:MP************************@news.xs4all.nl...
In article <42***********************@news.wanadoo.fr>, Jean-Marc
Blaise (no****@nobody.com) says...
"Gert van der Kooij" <ge**@invalid.nl> a écrit dans le message de
news:MP************************@news.xs4all.nl...
In article <11*********************@o13g2000cwo.googlegroups. com>,
Ivan Popivanov (po*****@gmx.net) says...
Hi,

It's in the docs, try searching for "autonomic_switches". The
parameters are at the very end of "db2 get db cfg".


This is just a small part of it. Using the wizard it's also possible
to configure on- and off-times. It's also possible to specify a
filter on the tables when defining runstats and/or reorg. I didn't
find anything about this in the docs. I guess it's stored in the
systools.policy table which is updated/read by stored procedures but
it looks like it isn't documented..


Would it be possible to have a "Show Command" button in the summary panel,
as the one that exists for the configure logging wizard ?

Thanks,

Jean-Marc


Yes, that would be great but my guess is that it's to complicated
which could make impossible to run the commands from the commandline.
But I hope I'm wrong :)

Hi Gert,

Well, the update db cfg should not be too complicated :) Maybe the problem
to update the policy could be done with a stored procedure. Basically, if
these HMON_ATM_INFO, HMON_COLLECTION and POLICY tables could be explained,
that would be a great step.

I'm wondering for example to do AUTO_REORG, and keep stats with my scripts
.... how can I track tables that have been reorganized ? in the LIST HISTORY
REORG ? in HMON_ATM_INFO ?

Regards,

Jean-Marc

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.