470,599 Members | 1,483 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,599 developers. It's quick & easy.

self_tuning_mem on

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
2 2400

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

Similar topics

6 posts views Thread by p175 | last post: by
6 posts views Thread by dunleav1 | last post: by
3 posts views Thread by Mark A | last post: by
6 posts views Thread by Lennart | last post: by
5 posts views Thread by Ian Boyd | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.