how to ensuring MQT freshness

[uwcssa@gmail.com]

hi

I have to use
"set current refresh age any" and
"set current maintained table types for optimization all"
to let optimizer pick my user-maintained MQT.

I wish to set this permanently in db2, rather than setting it in each
session. Is there a way to do so?

thanks

[Ian]

Re: how to ensuring MQT freshness

uwcssa@gmail.co m wrote:

hi
>
I have to use
"set current refresh age any" and
"set current maintained table types for optimization all"
to let optimizer pick my user-maintained MQT.
>
I wish to set this permanently in db2, rather than setting it in each
session. Is there a way to do so?

See the DFT_REFRESH_AGE and DFT_MTTB_TYPES database configuration
parameters.