Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Health Snapshot for database manager
74 views
Skip to first unread message
tsaol...@gmail.com
May 22, 2016, 11:18:45 PM5/22/16
to
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
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
May 31, 2016, 6:14:20 PM5/31/16
to
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
We'll see whether it is discontinued in DB2 11.1 when that gets released shortly.
Jeremy
jba...@calculo-sa.es
Jun 7, 2016, 4:44:52 AM6/7/16
to
0 new messages