Health Snapshot for database manager

[t***@gmail.com]

I have used the following procedure to get health snapshot for database

db2 update alert cfg for databases using db.sort_shrmem_util set Thresholdschecked yes
db2 update alert cfg for databases using db.spilled_sorts set Thresholdschecked yes
db2 update alert cfg for databases using db.deadlock_rate set Thresholdschecked yes
db2 update alert cfg for databases using db.apps_waiting_locks set Thresholdschecked yes
db2 update alert cfg for databases using db.catcache_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.pkgcache_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.shrworkspace_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.db_heap_util set Thresholdschecked yes
db2 update alert cfg for databases using db.sort_shrmem_util set Thresholdschecked yes
db2 update alert cfg for dbm using db2.sort_privmem_util set Thresholdschecked yes

db2 UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
db2 UPDATE DBM CFG USING DFT_MON_LOCK ON
db2 UPDATE DBM CFG USING DFT_MON_SORT ON
db2 UPDATE DBM CFG USING DFT_MON_STMT ON
db2 UPDATE DBM CFG USING DFT_MON_TABLE ON
db2 UPDATE DBM CFG USING DFT_MON_UOW ON

db2 UPDATE DBM CFG USING HEALTH_MON ON

db2 get health snapshot for db on sample

I am able to get each health snapshot output, but when I try to get the health snapshot for dbm, I am unable to get updated db2.sort_privmem_util info even though I used

db2 update alert cfg for dbm using db2.sort_privmem_util set Thresholdschecked yes

to enable it, please advise

[Jeremy Rickard]

Seems nobody here knows. The health monitor is deprecated from DB2 9.7 onwards so it may not be a good long term solution for you. I would say it's not widely used, which reduces the chances of somebody giving you a more helpful answer. You could always raise a support call with IBM if important to you.

We'll see whether it is discontinued in DB2 11.1 when that gets released shortly.

Jeremy

[j***@calculo-sa.es]

Post by t***@gmail.com
I have used the following procedure to get health snapshot for database
db2 update alert cfg for databases using db.sort_shrmem_util set Thresholdschecked yes
db2 update alert cfg for databases using db.spilled_sorts set Thresholdschecked yes
db2 update alert cfg for databases using db.deadlock_rate set Thresholdschecked yes
db2 update alert cfg for databases using db.apps_waiting_locks set Thresholdschecked yes
db2 update alert cfg for databases using db.catcache_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.pkgcache_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.shrworkspace_hitratio set Thresholdschecked yes
db2 update alert cfg for databases using db.db_heap_util set Thresholdschecked yes
db2 update alert cfg for databases using db.sort_shrmem_util set Thresholdschecked yes
db2 update alert cfg for dbm using db2.sort_privmem_util set Thresholdschecked yes
db2 UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
db2 UPDATE DBM CFG USING DFT_MON_LOCK ON
db2 UPDATE DBM CFG USING DFT_MON_SORT ON
db2 UPDATE DBM CFG USING DFT_MON_STMT ON
db2 UPDATE DBM CFG USING DFT_MON_TABLE ON
db2 UPDATE DBM CFG USING DFT_MON_UOW ON
db2 UPDATE DBM CFG USING HEALTH_MON ON
db2 get health snapshot for db on sample
I am able to get each health snapshot output, but when I try to get the health snapshot for dbm, I am unable to get updated db2.sort_privmem_util info even though I used
db2 update alert cfg for dbm using db2.sort_privmem_util set Thresholdschecked yes
to enable it, please advise

Perhaps DSM can do the job for you