IBM Support

Can I enable "READ_COMMITTED_SNAPSHOT ON" on the SQL Server databases after the databases have been created for Business Automation Worklow?

Question & Answer


Question

After upgrading to Business Automation Workflow 19.x, we noticed that the option "READ_COMMITTED_SNAPSHOT ON" setting was not set on the SQL Server databases for our Business Automation Workflow databases. We can see here that "READ_COMMITTED_SNAPSHOT ON" should be enabled on the BPMDB, PDWDB, CMNDB and CPEDB databases when the database is created according to the following link:
                         Creating SQL Server databases

Can I enable "READ_COMMITTED_SNAPSHOT ON" after the Business Automation Workflow databases have been created?

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000CcTkAAK","label":"Install and Deployment Environments-\u003EDB related-\u003Edatabase requirements"}],"ARM Case Number":"TS004192195","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0.0;20.0.0"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Product Synonym

BAW

Document Information

More support for:
IBM Business Automation Workflow

Component:
Install and Deployment Environments->DB related->database requirements

Software version:
19.0.0, 20.0.0

Document number:
6339719

Modified date:
30 September 2020

UID

ibm16339719

Manage My Notification Subscriptions