Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

CLEANUP_ABLIST_ON_ABORT

CLEANUP_ABLIST_ON_ABORT <YES | NO>

When key mark cleanup optimizations are enabled (NXTMARKS, UPDMARKS) and if a great many aborted transactions, checkpoint size becomes large due to many abort node list entries. Possible symptoms could include:

  • automatic recovery could fail with RCHK_ERR due to a checkpoint that exceeded 16 MB
  • slow performance

When a transaction aborts, transaction marks are now automatically cleaned in updated nodes. This behavior is on by default (YES) and can be disabled for prior compatibility.

CLEANUP_ABLIST_ON_ABORT NO

This option can be set in your server configuration file or dynamically modified at runtime.

TOCIndex