Paramter Check in Db2 (db6)

[jmueller]

Hello Db2 SUpport Team,

When checking the Db2 parameters using Parameter Check in the DBACOCKPIT, the DB CFG parameter ACT_SORTMEM_LIMIT is displayed as incorrect even after the change.
Current Value and Delayed Value show NONE. Is something missing here?

Best regards, Joachim

[Frank-Martin · Accepted solution]

Hi Joachim,

we decided to change the Db2 V11.5 parameter note 2751102. The note now requires
ACT_SORTMEM_LIMIT=100
and we added a comment that the value 100 and NONE are synonyms for this parameter.
This is in line with the IBM documentation and should solve your problem.

Regards

                 Frank

[jmueller · Accepted solution]

Hi Frank, Thanks a lot for the fast and smart solution. So my Fixpack Check will be clean.

[jmueller · Accepted solution]

Sorry, of course I meant parameter check.

[Frank-Martin]

Hi Joachim,
yes, this is somewhat strange. For this parameter the value is displayed differently via "get db cfg" and by the corresponding table functions.
We will need to check and discuss this.
Regards
               Frank

> db2 get db cfg for FMH | grep ACT_SORTMEM_LIMIT
Activity Sort Memory Limit (ACT_SORTMEM_LIMIT) = NONE

> db2 " SELECT NAME, VARCHAR(VALUE, 20) AS VALUE, MEMBER, DBPARTITIONNUM FROM TABLE(SYSPROC.DB_GET_CFG(-2)) ORDER BY NAME, MEMBER " | grep -i act
act_sortmem_limit 100 0 0
mon_act_metrics BASE 0 0
section_actuals NONE 0 0
self_tuning_mem ON (Active) 0 0