Automatic table maintenance

[Gert van der Kooij]

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

[Bjarke Wedemeijer]

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

[Ivan Popivanov]

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

[Gert van der Kooij]

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..

[Jean-Marc Blaise]

"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

[Gert van der Kooij]

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 :)

[Jean-Marc Blaise]

"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