DB2 Notes

Everything You Wanted to Know About DB2 Universal Database Processes

http://www-128.ibm.com/developerworks/db2/library/techarticle/0304chong/0304chong.html

Replication options, pros and cons

  • HADR - real time. no latency. one side is unavailable to bind to. manual failover
  • Q Replication - Automatic failover. Latency. Best Performance
  • SQL Replication - automatic. high latency

Online backups require a rollforward (LOG Retain) option enabled. Once it is enabled a one time offline backup is required.

Logs location

look in the instance owner home folder
/home/db2inst1/sqllib/db2dump/db2dump.log


@TechnicalNotes @IBM