No, and no. I am curious: What do you need it for? I am more interested in the second part to enable or disable an alias for the server name. This would be of use for us at times a client is switching between machines with identical databases.
(12 May '11, 08:46)
Martin
|
When you start a database you can specify an alternate server name for the database. This is an additional server name that can be used only to connect to the database. The alternate server name is the closest thing to changing the server name that SQL Anywhere supports. High availability uses alternate server names so that a client can use the alternate server name for the database. This alternate server name will be used by which ever of the two partner servers is currently the primary. Perhaps you should consider using high availability which will do this automatically for you. Interestingly - I always have thought -sn is only useful/allowed when using HA. But it isn't, apparently, if I do understand this correctly:) Obviously when not using HA, you would have to make sure yourself that only one server at a time does use that according -sn alternate server name.
(12 May '11, 09:19)
Volker Barth
Thanks Ian, can I change this alternate name for a database during runtime?
(12 May '11, 10:23)
Martin
Replies hidden
1
Unfortunately No. An alternate server name can only be specified when starting a database. The is no way to change or add a alternate server name for a running database. Note that you can start and stop databases on a running server.
(12 May '11, 10:43)
Ian McHardy
|
How would you expect running clients to behave, based on the fact the server name is usually a very important part of the connection string (at least for pre-12 servers, v12's HOST may make this less necessary)?
For v12 this seems to be the solution I am looking for