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 - <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"

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;