Parametry db serveru

Top Previous Next

Seznam témat:

ASA Database Administration Guide

The database server

Function

Start a personal database server or network database server.

Syntax

{ dbeng17 | dbsrv17 }

[ server-options ] [ database-file [ database-options ] ...]

Server options

Server option Description

@@data Read in options from a configuration file or environment variable. See

@data server option.

-? Display usage information. See -? server option.

-b Run in bulk operations mode. See -b server option.

-c size Set initial cache size. See -c server option.

-ca 0 Disable dynamic cache sizing [Windows NT/2000/XP, Windows 95/98/Me, UNIX]. See -ca server option.

-cc { + | - } Collect information about database pages to be used for cache warming. See -cc server option.

-ch size Set the cache size upper limit [Windows NT/2000/XP, Windows 95/98/Me]. See -ch server option.

-cl size Set the cache size lower limit [Windows NT/2000/XP]. See -cl server option.

-cr { + | - } Warm the cache with database pages. See -cr server option.

-cs Display cache usage in database server window. See -cs server option.

-ct { + | - } Turn character-set translation on and off [not NetWare or Windows CE]. See -ct server option.

-cv { + | - } Control the appearance of messages about cache warming in the database server window. See -cv server option.

-cw Enable use of Address Windowing Extensions on Windows 2000, Windows XP, and Windows Server 2003 for setting the size of the database server cache. See -cw server option.

-d Use POSIX I/O [NetWare]. See -d server option.

-ec encryptionoptions, Enable packet encryption [network server]. See -ec server option.

-ep Prompt for encryption key. See -ep server option.

-fc Specify the filename of a DLL containing the file system full callback function. See -fc server option.

-fips Requires that only FIPS-approved algorithms should be used for strong database and communication encryption. See -fips server 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 server option.

-gb l evel Set database process priority class to level [Windows NT/2000/XP]. See

-gb server option.

-gc num Set maximum checkpoint timeout period to num minutes. See -gc server option.

-gd level Set database starting permission. See -gd server option.

-ge size Set the stack size for threads that run external functions. See -ge server option.

-gf Disable firing of triggers. See -gf server option.

-gk level Set the permission required to stop the server. See -gk server option.

-gl level Set the permission required to load or unload data. See -gl server option.

-gm num Set the maximum number of connections. See -gm server option.

-gn num Set the maximum number of concurrent requests the database server can handle at one time. See -gn server option.

-gp size Set the maximum page size to size bytes. See -gp server option.

-gr minutes Set the maximum recovery time to num minutes. See -gr server option.

-gss size Set the thread stack size to size bytes [not applicable to Windows]. See - gss server option.

-gt num Set the number of operating processors used by the database server to num processors. See -gt server option.

-gu level Set the permission level for utility commands: utility_db, all, none, or DBA. See -gu server option.

-gx Set the number of operating system threads assigned to the database server process [Windows NT/2000/XP, Windows 95/98/Me]. See -gx server option.

-m Truncate the transaction log after each checkpoint for all databases. See

-m server option.

-n name Use name as the name of the database server. Note that the -n option is positional. See -n server option.

-o filename Output messages to the specified file. See -o server option.

-oe filename Specify file to log startup errors, fatal errors and assertions to. See -oe server option.

-os size Limit the size of the log file for messages. See -os server option.

-p packet-size Set the maximum network packet size [network server]. See -p server option.

-pc Compress all connections except same-machine connections. See -pc server option.

-pt size_in_bytes Set the minimum network packet size to compress. See -pt server option.

-qi Do not display database server tray icon or screen. See -qi server option.

-qp Suppress messages about performance in the database server window. See -qp server option.

-qs Suppress startup error dialogs. See -qs server option.

-qw Do not display the database server screen. See -qw server option.

-r Opens database in read-only mode. See -r server option.

-s Set the syslog facility ID [UNIX]. See -s server option.

-sb { 0 | 1 } Specify how the server reacts to broadcasts. See -sb server option.

-sc Disable the shared memory port, and enable Named Pipes. [Windows NT/2000/XP]. See -sc server option.

-ti minutes Client idle time before shutdown—default 240 minutes. See -ti server option.

-tl seconds Default liveness timeout for clients in seconds—default 120 seconds. See -tl server option.

-tmf Force transaction manager recovery for distributed transactions [Windows NT/2000/XP]. See -tmf server option.

-tmt milliseconds Set the reenlistment timeout for distributed transactions [Windows NT/2000/XP]. See -tmt server option.

-tq time Set quitting time [network server]. See -tq server option.

-u Use buffered disk I/O. See -u server option.

-ua Turn off use of asynchronous I/O [Linux]. See -ua server option.

-uc

-ud Run as a daemon [UNIX]. See -ud server option.

-ui

-ut minutes Touch temporary files every min minutes [UNIX]. See -ut server option.

-ux Display the Server Messages window and Server Startup Options dialog [Linux and Solaris only]. See -ux server option.

-v Display database server version and stop. See -v server option.

-x list Comma-separated list of communication links to try. See -x server option.

-xs Specify server side web services communications protocols. See -xs server option.

-y Run as a Windows 95/98/Me service [Windows 95/98/Me]. See -y server option.

-z Provide diagnostic information on communication links [network server]. See -z server option.

-zl Turn on capturing of the most recently-prepared SQL statement for each connection. See -zl server option.

-zn Specifies the number of request log file copies to retain. See -zn server option.

-zo filename Redirect request logging information to a separate file. See -zo server option.

-zr { all | SQL |none }

Turn on logging of SQL operations. The default is NONE. See -zr server option.

-zs size Limit the size of the log file used for request logging. See -zs server option.

Recovery Option

Recovery Option Description

-a filename Apply the named transaction log file. See -a recovery option.

-f Force the database to start without a transaction log. See -f recovery option.

Database Option

Database Option Description

-ek key Specify encryption key. See -ek database option.

-m Truncate (delete) the transaction log after each checkpoint for the specified database. See -m database option.

-n name Name the database. Note that the -n option is positional. See -n database option.

-r Open the specified database(s) in read-only mode. Database modifications not allowed. See -r database option.

Description

The dbeng9 command starts a personal database server. The dbsrv9 command starts a network database server.

Cache size

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 option or is a default value.

For information on the default cache size, see -c server option. On Windows NT/2000/XP, Windows 95/98/Me, and UNIX, the database server automatically takes more memory for use in the cache as needed, as determined by a heuristic algorithm.

For more information, see Using the cache to improve performance. You can use database options to configure the upper cache limit: see -ch server option. As well, you can force the cache to remain at its initial amount: see -ca server option.

Server differences

The personal database server has a maximum of ten concurrent connections, uses at most one CPU 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.

Platform availability 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 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.

Note

It is recommended that you run the network database server on Windows NT/2000/XP or Windows 2003, rather than Windows 95/98/Me, to ensure better performance and reliability.

NetWare notes

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.

Database file The database-file specifies the database filename. If database-file is specified without a file extension, Adaptive Server Anywhere looks first for databasefile 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

Suppressing Windows event log messages

If you run the database server as a Windows service, you can suppress Windows event log entries by setting a registry entry. The registry entry is

Software\Sybase\Adaptive Server Anywhere\9.0

To control event log entries, set the EventLogMask key, which is of type REG_DWORD. The value is a bit mask containing the internal bit values for the different types of event messages:

errors EVENTLOG_ERROR_TYPE 0x0001

warnings EVENTLOG_WARNING_TYPE 0x0002

information EVENTLOG_INFORMATION_TYPE 0x0004

For example, if the EventLogMask key is set to zero, no messages appear at all. A better setting would be 1, so that informational and warning messages do not appear, but errors do. The default setting (no entry present) is for all message types to appear.