Hi, we are playing around with HA and wondering a bit why there is no wizzard for configurating. We don't even know how to ask for the current configuration.
asked 30 Nov '11, 07:36
Which SQL Anywhere version (and build number) do you use?
There is a whole chapter in the docs on HA - e.g. this page on how to setup HA for v12.0.1.
Unless you start the database server explicitly with the -xp database option, you can't use HA at all. Besides that, the following database properties might tell you more.
select db_property('MirrorRole'), db_property('MirrorServerState'), db_property('MirrorState'), db_property('MirrorMode'), db_property('PartnerState');
For a non-mirrored database on a server not startet with -xp, they all return NULL.