Minimal DML Logging and Replication

To optimize the log records that are flushed to the transaction log on disk, Adaptive Server can perform minimal to no logging when executing some data manipulation language (DML) commands—insert, update, delete, and slow bcp—on all types of low-durability databases, such as in-memory databases and relaxed-durability databases set with durability of at_shutdown or no_recovery.

You can perform minimal logging for DMLs on a per-database, per-table, and session-specific basis. See “Minimally-logged DML” in the Adaptive Server Enterprise In-Memory Database Users Guide.

Note: Minimal DML logging session-level settings take precedence over database-level settings and table-level settings.

Replication Server Support

As replication uses full logging, replication and the minimal DML logging feature in Adaptive Server 15.5 are incompatible at the same level, such as the database level or table level. However, you can take advantage of the performance enhancements from minimal DML logging on some tables while allowing replication on others, as minimal DML logging and replication can coexist at different levels. See “Minimal DMLlogging and replication,” in Chapter 5, “Managing RepAgent and Supporting Adaptive Server,” in the Replication Server Administration Guide Volume 1 for scenarios that result in incompatibility between replication and minimal DML logging.