ASA Database Administration Guide
The Database Server
The database server
Database server options
Set the name of the database server.
{ dbsrv9 | dbeng9 } -n
database-file-name...
All operating systems and servers.
By default, the database server receives the name of the database file with the path and extension removed. For example, if the server is started on the file c:\Program Files\Sybase\SQL Anywhere 9\asademo.db and no -n
option is specified, the name of the server is asademo.
The server name is interpreted according to the character set of the machine, as no database collation exists at startup time. Multi-byte characters are not recommended in server names.
Names must be a valid identifier. Long engine names are truncated to different lengths depending on the protocol.
Protocol | Truncation Length |
---|---|
Unix shared memory | 31 bytes |
non-Unix shared memory | 40 bytes |
TCP/IP | 40 bytes |
SPX | 32 bytes |
Named Pipes | 8 bytes |
The server name specifies the name to be used in the EngineName (ENG) connection parameter of client application connection strings or profiles. With shared memory, there is a default database server that will be used if no server name is specified provided that at least one database server is running on the computer.
Running multiple servers with the same name is not recommended.
There are two -n optionsThe-n option is positional. If it appears before a database file name, it is a server option and names the server. If it appears after a database file name, it is a database option and names the database.For example, the following command names the server SERV and the database DATA: dbsrv9 -n SERV asademo.db -n DATA For more information, see -n database option. |
EngineName connection parameter [ENG]