====== 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;