ASA Database Administration Guide
Running the Database Server
Adaptive Server Anywhere provides two versions of the database server:
The personal database server This executable does not support client/server communications across a network. Although the personal database server is provided for single-user, same-machine use—for example, as an embedded database engine—it is also useful for development work.
On Windows operating systems except Windows CE, the name of the personal server executable is dbeng9.exe. On UNIX operating systems its name is dbeng9.
The network database server Intended for multi-user use, this executable supports client/server communications across a network.
On Windows operating systems, including Windows CE, the name of the network server executable is dbsrv9.exe. On Novell NetWare the name is dbsrv9.nlm, and on UNIX operating systems it is dbsrv9.
The request-processing engine is identical in the two servers. Each supports exactly the same SQL, and exactly the same database features. The main differences include:
Network protocol support Only the network server supports communications across a network.
Number of connections The personal server has a limit of ten simultaneous connections. The limit for the network server depends on your license.
Number of CPUs The personal database server uses a maximum of two CPUs for request processing. The network database server has no set limit.
Default number of internal threads You can configure the number of requests the server can process at one time using the -gn
option. The network database server has a default of 20 threads and no set limit, while the personal database server has a default and limit of 10 threads.
For more information about database server options, see The database server.
Startup defaults To reflect their use as a personal server and a server for many users, the startup defaults are slightly different for each.
First steps
What else is there to it?