DB2 Fixes

DB2 does not autostart on boot

check if the db is started, su into the instance owner

su - db2admin
db2fm -s -S

db2 list active databases
For LDAP look for 389
netstat -pant

grep DB2AUTOSTART sqllib/profile.env
should say 'YES'

grep db2fm /etc/inittab
should say
fmc:2345:respawn:/opt/ibm/db2/V10.1/bin/db2fmcd #DB2 Fault Monitor Coordinator

To start the fauilt monitor daemon manually do
db2fm -U
Start the failt monitor service
db2fm -u

http://www-01.ibm.com/support/docview.wss?uid=swg21209001

DB2 is slow

Rebuild indexes with runstats
Reduce TCP keepalive. As root

echo 30 > /proc/sys/net/ipv4/tcp_keepalive_intvl
/etc/init.d/network restart



Backlinks: idmdepot.com:How To:How to install IBM Security Identity Manager 7 Virtual Appliance