Chapter 2 The Database Server
31
[ dbsrv7 | dbeng7 ] -gx
integer
...
Windows 95/98, Windows NT
By default, this is set to one more than the number of CPUs on the machine.
You may want to increase the option setting to reserve threads for external
tasks, separate from standard database tasks. For example, you may want to
add an extra thread for each concurrent connection using remote data access,
or for connections using Java in the database to listen on an external port. In
other circumstances, this option should be left at the default value.
On UNIX, each task is executed in its own thread, so that the number of
tasks (
-gn) also determines the number of threads.
–m command-line option
Delete the transaction log when a checkpoint is done.
[ dbsrv7 | dbeng7 ] -m ...
All operating systems and servers.
This option deletes the transaction log when a checkpoint is done, either at
shutdown or as a result of a checkpoint scheduled by the server.
Caution
When this option is selected, there is no protection against media failure
on the device that contains the database files.
This provides a way to automatically limit the growth of the transaction log.
Checkpoint frequency is still controlled by the CHECKPOINT_TIME and
RECOVERY_TIME options (which you can also set on the command line).
This option is useful where high volume transactions that require fast
response times are being processed, and the contents of the transaction log
are not being relied upon for recovery or replication.
To avoid database file fragmentation, it is recommended that where this
option is used, the transaction log be placed on a separate device or partition
from the database itself.
Replicated databases
Do not use the -m option with databases that are being replicated.
Replication inherently relies on transaction log information.
Syntax
Applies to
Description
Function
Syntax
Applies to
Description
To Next Page
Loading...