DB2 Notes

Everything You Wanted to Know About DB2 Universal Database Processes


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

@TechnicalNotes @IBM