Our product makes use of DB2 database for auditing, we want to configure failover for main audit DB in case of a disaster.
Can DB2 experts help me to choose a best way to achieve this? is it possible to set replication between main Audit db and a slave DB and switch to slave in case of a disaster ? if it is possible can you please provide me the links which explain this strategy?
Unless you need to access the slave database at the same time as the master, replication would not be the best approach for you. A standby database using HADR will be sufficient. Search the manual for HADR.