db2_monitoring [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== DB2 Monitoring ======
As Oracle and other databases, DB2 is using buffers in memory called a buffer pool with specific size: 4-8-16-32 KBs size.
Since the containers (datafiles) are divided into logical 



**ITM DB2 Agent stop & start:**
<sxh bash>
su - <db2user> -c "/opt/IBM/ITM/bin/itmcmd agent -o <db2user> stop ud"
su - <db2user> -c "/opt/IBM/TDW/bin/itmcmd agent -o <db2user> start ud"
</sxh>

**Generate K07_filesystem.param entries :**
<sxh bash>
df -g | grep -i rpi | awk '{print ";db2;tag-db2;%"$NF";90;95;97"}'
</sxh>

**Custom log monitoring :**
  * K07_LogMonitor.conf :
<sxh bash>
DEBUG=0
MAX_DEBUG_SIZE=1000000
EVENTLOG=1
MAX_EVENT_SIZE=100000
SECONDARY_POS_FILES_DIR=/opt/IBM/ITM/logs/K07_LogMonitor_posfiles
</sxh>

  * K07_LogMonitor.param
<sxh bash>
password;/db2wk/db2inst1/sqllib/db2dump/db2diag.log;;INCREMENTAL;;NO;NO;NO;NO;
</sxh>

  * K07_LogMonitor_detail.param
<sxh bash>
db2;password;Password validation for user;WARNING;NO
</sxh>

**Reset the dummy log :**
<sxh bash>
dummylog;/opt/IBM/ITM/smitools/logs/K07_dummy.log;dummyinstance;FULL;;NO;YES;NO;NO;
</sxh>