====== 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:**
su - -c "/opt/IBM/ITM/bin/itmcmd agent -o stop ud"
su - -c "/opt/IBM/TDW/bin/itmcmd agent -o start ud"
**Generate K07_filesystem.param entries :**
df -g | grep -i rpi | awk '{print ";db2;tag-db2;%"$NF";90;95;97"}'
**Custom log monitoring :**
* K07_LogMonitor.conf :
DEBUG=0
MAX_DEBUG_SIZE=1000000
EVENTLOG=1
MAX_EVENT_SIZE=100000
SECONDARY_POS_FILES_DIR=/opt/IBM/ITM/logs/K07_LogMonitor_posfiles
* K07_LogMonitor.param
password;/db2wk/db2inst1/sqllib/db2dump/db2diag.log;;INCREMENTAL;;NO;NO;NO;NO;
* K07_LogMonitor_detail.param
db2;password;Password validation for user;WARNING;NO
**Reset the dummy log :**
dummylog;/opt/IBM/ITM/smitools/logs/K07_dummy.log;dummyinstance;FULL;;NO;YES;NO;NO;