What commit mode is best suited for SQL DB used by dSeries?
Should it be Synchronous or Asynchronous?
OS: Any
Database: MS-SQL
The SQL database supports Synchronous and Asynchronous commit modes. The Asynchronous is mainly used in cluster and Always-On setup. The database will not wait for transaction confirmation. The synchronous mode is used more performance intensive though it emphasizes on high availability.
Broadcom has no specific recommendation on which mode to be used. Please consult your DBA and/or Microsoft to determine the requirements.
See Microsoft documentation for more details.