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

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

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