| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA Reference Manual |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2: The Database Server |
|
| The database server |
Start a personal database server or network database server.
{ dbeng6 | dbsrv6 }
[ server-switches ] [ database-file [ database-switches ] ]*dbeng6w [ server-switches ] [ database-file [ database-switches ] ]*
load dbsrv6 [ server-switches ] [ database-file [ database-switches ] ]*
Switch | Description |
@filename | Read in switches from a configuration file. See @filename command-line option |
@environment-variable | Read in switches from an environment variable. See @environment-variable command-line option . |
-? | Display usage information. See -? command-line option |
-b | Run in bulk operations mode. See -b command-line option . |
-c size | Set initial cache size. See -c command-line option . |
-ca 0 | Do not increase cache size based on server load [Windows NT, Windows 95/98]. See -ca command-line option . |
-ch size | Limit cache size [Windows NT, Windows 95/98]. See -ch command-line option . |
-ct | Enable character-set translation. See -ct command-line option . |
-d | Disable asynchronous I/O [Windows NT, NetWare]. See -d command-line option . |
-df | Force direct I/O [Windows 3.x]. See -df command-line option . |
-di | Use direct I/O if possible [Windows 3.x]. See -di command-line option . |
-e | Enable packet encryption [network server]. See -e command-line option . |
-ga | Automatically unload the database after the last connection closed. In addition, shut down after the last database is closed [Not NetWare]. See -ga command-line option . |
-gb level | Set database process priority class to level [Windows NT]. See -gb command-line option . |
-gc minutes | Set checkpoint timeout period to num minutes. See -gc command-line option . |
-gd level | Set database starting permission. See -gd command-line option . |
-ge size | Set the stack size for threads that run external functions [not UNIX or Windows 3.X]. See -ge command-line option . |
-gf | Disable firing of triggers. See -gf command-line option . |
-gk level | Set the permission that is required to stop the server. See -gk command-line option . |
-gm num | Limit the maximum number of connections. See -gm command-line option . |
-gn num | Set the number of threads. See -gn command-line option . |
-gp size | Set the maximum page size to size bytes.. See -gp command-line option . |
-gr minutes | Set the maximum recovery time to num minutes. See -gr command-line option . |
-gss size | Set the thread stack size to size bytes. See -gss command-line option . |
-gt num | Set the number of CPUs for request processing. See -gt command-line option . |
-gu level | Set the permission level for utility commands: utility_db, all, none, dba. See -gu command-line option . |
-gw | Set the interval (in milliseconds) for background processing. See -gw command-line option . |
-gx | Modify operating system threading [Windows 95 and Windows NT]. See -gx command-line option . |
-m | Truncate the transaction log after each checkpoint, for all databases. See -m command-line option . |
-n name | Use name as the name of the database server. See -n command-line option . |
-o filename | Output messages to the specified file. See -o command-line option . |
-p packet-size | Set the maximum network packet size [network server]. See -p command-line option . |
-q | Quiet mode--suppress output. See -q command-line option . |
-r | Opens database in read-only mode. See -r command-line option . |
-s | Set the syslog facility ID (none, user, daemon, local0,..., local7) [UNIX]. See -s command-line option . |
-sc | Disable the shared memory port, and enable Named Pipes. [NT personal database server ]. See -sc command-line option . |
-ti minutes | Client idle time before shutdown--default 240 minutes [network server]. See -ti command-line option . |
-tl seconds | Default liveness timeout for clients in seconds--default 120 seconds [network server]. See -tl command-line option . |
-tq time | Set quitting time [network server]. See -tq time command-line option . |
-u | Use buffered disk I/O [Windows 95 and Windows NT]. See -u command-line option . |
-ud | Run as a daemon [UNIX]. See -ud command-line option . |
-ut minutes | Touch temporary files every min minutes [UNIX]. See -ut command-line option . |
-v | Display database server version and stop.. See -v command-line option . |
-x list | Comma-separated list of communication links to try. See -x command-line option . |
-y | Run as a Windows 95/98 service [Windows 95/98]. See -y command-line option . |
-z | Provide diagnostic information on communication links [network server]. See -z command-line option . |
Switch | Description |
- filename | Apply the named transaction log file. See -a command-line option. |
-f | Force the database to start without a transaction log. See -f command-line option. |
Switch | Description |
-m | Truncate (delete) the transaction log after each checkpoint. See -m command-line option. |
-n name | Name the database. See -n command-line option. |
Network communications parameters
The
dbeng6command starts a personal database server. The
dbsrv6command starts a network database server.
The amount of cache memory available to the database server can be a key factor in affecting performance. The database server takes an initial amount of cache memory that is either specified by the -c command-line option or is a default value. For information on the default cache size, see -c command-line option .
On Windows NT and Windows 95/98, the database server automatically takes more memory for use in the cache under the following circumstances:
If the database server would otherwise encounter the error Fatal Error: dynamic memory exhausted.
If an operation would cause the Java VM to require memory that it cannot allocate because it would leave insufficient memory in the available cache.
If an internal algorithm determines that the amount of cache available for database pages has decreased, and would benefit from being increased.
The cache does not shrink until the database server is shut down. The upper limit for cache memory is, by default, approximately the lower of 256 Mb and 90% of the physical memory of the machine.
You can use database command-line options to configure the upper limit: see -ch command-line option . You can force the cache to remain at its initial amount: see -ca command-line option .
The personal database server has a maximum of ten concurrent connections, uses at most two CPUs for request processing, and does not support network client/server connections.
In addition, there are other minor differences, such as the default permission level that is required to start new databases, or the permissions required to execute the CHECKPOINT statement.
Both personal and network database servers are supplied for each supported operating system, with the following exceptions:
Novell NetWare
Only the network server is supplied.
Windows 3.x
Only the personal server is supplied.
Windows CE
Only the network server is supplied. The support for TCP/IP in the network server enables you to carry out tasks from your desktop machine, including database management with Sybase Central.
In NetWare, the database file and the transaction log file must be on a NetWare volume, and the paths must be fully specified. NetWare allows you to have volumes that span two or more hard disks.
Adaptive Server Anywhere uses the Direct File System to maintain database files. The Direct File System is built into NetWare 4.0 and 4.1, but not in NetWare 3.12. Novell has provided a loadable module that contains the DIRECTFS functions for version 3.12. directfs.nlm comes with Adaptive Server Anywhere, and is installed during the installation if it is not found on your NetWare server. The DIRECTFS module is automatically loaded if necessary when you load dbsrv6.
Novell has also provided an updated clib.nlm for NetWare 3.11. This update contains bug fixes that are necessary for Adaptive Server Anywhere to work properly. It is installed during the installation of Adaptive Server Anywhere if it is not already on your NetWare server.
Database file
The database-file specifies the database filename. If database-file is specified without a file extension, Adaptive Server Anywhere looks first for database-file with extension .wrt (a write file) followed by database-file with extension .db.
If you use a relative path, it is read relative to the current working directory. You can supply a full path. Also, you can supply a path that conforms to the Universal Naming Convention (UNC) format:
\\server\volume\path\file.ext
In addition, users of Novell NetWare version 4 and later can use NetWare Directory Services (NDS) volumes, which have the following format:
\\treename\volume.org_unit.org\path\file.ext
where volume.org_unit.org is the name of an NDS volume object.
Warning!
Caution
The database file must be on the same machine as the database server. Managing a database file that is located on a network drive can lead to file corruption.
|
| Database server switches |
| @filename command-line option |
| @environment-variable command-line option |
| -? command-line option |
| -b command-line option |
| -c command-line option |
| -ca command-line option |
| -ch command-line option |
| -ct command-line option |
| -d command-line option |
| -df command-line option |
| -di command-line option |
| -e command-line option |
| -ga command-line option |
| -gb command-line option |
| -gc command-line option |
| -gd command-line option |
| -ge command-line option |
| -gf command-line option |
| -gk command-line option |
| -gm command-line option |
| -gn command-line option |
| -gp command-line option |
| -gr command-line option |
| -gss command-line option |
| -gt command-line option |
| -gu command-line option |
| -gw command-line option |
| -gx command-line option |
| -m command-line option |
| -n command-line option |
| -o command-line option |
| -p command-line option |
| -q command-line option |
| -r command-line option |
| -s command-line option |
| -sc command-line option |
| -ti command-line option |
| -tl command-line option |
| -tq time command-line option |
| -u command-line option |
| -ud command-line option |
| -ut command-line option |
| -v command-line option |
| -x command-line option |
| -y command-line option |
| -z command-line option |
|
| Recovery switches |
| -a command-line option |
| -f command-line option |
|
| Database switches |
| -m command-line option |
| -n command-line option |
|
|