Using HDR database has anyone tried to use a cname in sqlhosts to have transparent failover via DNS to secondary. Any known problems

Hi there,

There are two ways to do automatic failover:

1. DNS, but you will have to configure DNS correctly. And don't forget 'onmode -d' to set the secondary server to primary.

2. Set your secondary servername in the DBPATH environment variable on the client site. It will check it. 'onmode -d' is also necessary in this case.