Turning off the O_SYNC flag

[Bug #241217] By default, Adaptive Server version 12.5 for Linux opens database devices with the O_SYNC flag to ensure recoverability in the event of power failure, operating system crash, or Adaptive Server crash. This O_SYNC flag impacts performance significantly.

Workaround: Turn off the O_SYNC flag by restarting the server using trace flag 1625:

dataserver -dd_master -T1625