DB2 Notes
From KnowWiki
| DB2 |
|---|
| DB2 Topics |
| How To · Technical Notes |
[edit] Everything You Wanted to Know About DB2 Universal Database Processes
http://www-128.ibm.com/developerworks/db2/library/techarticle/0304chong/0304chong.html
[edit] 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.
[edit] Logs location
look in the instance owner home folder
/home/db2inst1/sqllib/db2dump/db2dump.log
|
|||||
