Contents Index -gx server option -n server option

ASA Database Administration Guide
  The Database Server
    The database server
      Database server options

-m server option

Function 

Delete the transaction log when a checkpoint is done.

Syntax 

dbsrv9 | dbeng9 } -m ...

Applies to 

All operating systems and servers.

Description 

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).

The -m option is useful for limiting the size of the transaction log in situations where high volume transactions requiring fast response times are being processed, and the contents of the transaction log are not being relied upon for recovery or replication. The -m option provides an alternative to operating without a transaction log at all, in which case a checkpoint would be required following each COMMIT and performance would suffer as a result. When the -m option is selected, there is no protection against media failure on the device that contains the database files. Other alternatives for managing the transaction log (for example, using the BACKUP statement and events) should be considered before using the -m option.

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 and Synchronized databases 
Do not use the -m option with databases that are being replicated or synchronized. Replication and Synchronization, used by SQL Remote and MobiLink, inherently rely on transaction log information.

Contents Index -gx server option -n server option