|
-sn can be used to define an alternate server name for a single database. This approach cannot be used for multiple databases running in the same dbsrv process. Therefore I would like to suggest an option to give the whole database server multiple names. Especially in migration scenarios it could be very convenient, if the database server could have more than one name. |
|
You can use the -n Option to name each Database you load into the server. database-file -n string ... http://dcx.sybase.com/index.html#1201/en/dbadmin/db-n-database-dbengine.html Is that what you are looking for ? 1
Thomas: no I do not believe this is what Martin is looking for. The -n switch that comes after a database file name gives a name to the database, not the server. I believe that Martin would like to have multiple names given to a server so that it would respond to any one of those names. I am just not sure what the usage case would be to have a server responding to multiple names. Note the -sn database switch was implemented so that both partner servers hosting the copies of a single database in an HA system could respond to the same server name when the server is acting as the primary. Since the -sn switch only applies to a particular database running on the server all connection requests using the -sn alternate server name must be to its respective database.
(04 Apr '12, 16:05)
Mark Culp
I was stuck with "multiple databases running in the same dbsrv process". This was for me the keyword for the -n switch. But we will see what Martin is really interested in.
(04 Apr '12, 16:34)
Thomas Dueme...
|
Interesting suggestion... but I'm not quite sure I understand the usage case. Perhaps you could elaborate on the usage cases where you would find this useful?
When going from pre-v12 to v12, you might be able to use
so the same databases on one engine could be reached via different "names" (ENG vs. HOST), and the ENG value could be different (as it would not be relevant for v12) - but I'm not sure if that would meet your requirements...
Mark you have fully understood my request. Such a feature would make life much easier for us in scenarios where we migrate clients from one server to another hardware box. It is comparable to a webserver responding to multiple domain names.
Could you still tell more about this: Do you want to be able to "automatically" switch clients from one server to another without having to change client connection strings? (That would be doable with simply changing ENG/SERVER names (or HOST names or IP addresses) but would not work when not all clients should be "switched" in the same time.)
It might be a help if you tell what exactly should work (and does not currently)...
The core part is, that I would like to have a server side influence without the need to change all client configurations. It is like having multiple IP-adresses for the same server, or in my desire having a db server with mutliple names. I don't say that there might by other solutions, I think it would just be more convenient.
AFAIK, a server surely can list on different IP addresses if it has several network adapters (i.e. -x "tcpip(MyIP=192.75.209.12,192.75.209.32)"), so it could serve clients using different server IP addresses.
However, it would still require to use the same ENG/SERVER name for all clients - unless they are v12 and do use the HOST connection parameter, as that will work without having to supply a SERVER/ENG connection parameter...
I agree that this is a workaround (in case it does work) and not the solution you are looking for.