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

self_tuning_mem on

P: n/a
With self_tuning_mem set to ON, is there a way to get the actual settings
for the parameters that are set to automatic ?

Regards
Odd B Andersen
ErgoGroup AS, Oslo, Norway
Oct 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Odd Bjørn Andersen wrote:
With self_tuning_mem set to ON, is there a way to get the actual settings
for the parameters that are set to automatic ?

Regards
Odd B Andersen
ErgoGroup AS, Oslo, Norway
Hi Odd,

Try:
db2 connect to <dbname>
db2 get db cfg show detail

That will give you the in-memory values being used for DB config
parameters that are set to AUTOMATIC (including ones tuned by STMM).

Cheers,
Liam.

Oct 10 '06 #2

P: n/a
Ian
Odd Bjørn Andersen wrote:
With self_tuning_mem set to ON, is there a way to get the actual settings
for the parameters that are set to automatic ?
Yes. Use "get database cfg for <dbshow detail". For the parameters
that have been set to AUTOMATIC, you'll see their current value in
parenthesis.

For bufferpools, you can take a bufferpool snapshot.
Oct 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.