self_tuning_mem on

Odd Bjørn Andersen

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

Liam Finnie

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