Advanced database support for IBM Business Process Manager (BPM) and IBM Business Monitor on distributed platforms

Question & Answer

Question

Where can I find information about advanced database support for IBM Business Automation Workflow 18.0.0.1 and later?
Which advanced configurations of IBM Db2, Oracle, and Microsoft SQL Server databases are supported for the IBM Business Process Manager and IBM Business Monitor products?

Answer

See the document Advanced database support for IBM Business Automation Workflow on distributed platforms.
This document outlines which configurations of IBM Db2, Oracle, and Microsoft SQL Server databases are supported for IBM Business Process Manager and IBM Business Monitor. In this document, the following information is available:

Database independent limitations
IBM Db2 database support for IBM Business Process Manager and IBM Business Monitor
IBM Db2 limitations
Oracle database support for IBM Business Process Manager and IBM Business Monitor
Oracle limitations
Microsoft SQL Server database support for IBM Business Process Manager and IBM Business Monitor
Microsoft SQL Server limitations

IBM has a new way for you to search, view, and collaborate with product documentation. For the most up to date product documentation about advanced database support, see the new IBM Knowledge Center .

For a complete list of hardware and software requirements, see the following websites:

Database independent limitations

Versions of IBM Business Process Manager earlier than Version 8.0.1.1 do not fully support all database clustering features. During a database node failover, these versions of the IBM Business Process Manager products react in a similar way as to a temporary database outage. When the database is not available, the IBM Business Process Manager system stops processing. It might be necessary to restart all IBM Business Process Manager nodes, depending on the database downtime.
Beginning with IBM Business Process Manager Version 8.0.1.1, the IBM BPM server code is aware of the SQL Exceptions passed up through the JDBC drivers and allow configurable retry count and interval.
IBM BPM administrators should understand the behavior of the Messaging Engine when it loses contact with its database, which might occur, for example, if you are using a database clustering technique such as Oracle RAC or Db2 HADR and a database failover operation occurs. Refer to the WebSphere Application Server information for additional information:
- - Configuring messaging engine and server behavior when a data store connection is lost
  - Service integration custom properties
During a High Availability or Disaster Recovery event that involves the unexpected failure of a IBM BPM server or database server, IBM BPM system might mark a business process instance as failed. For example, in cases where it is not possible for the engine to prove the correct process instance state, the business process instance will marked as failed. A retry mechanism is in place to handle High Availability or Disaster Recovery events that typically manifest themselves in connection failures. If the retry times out before a connection to a running database node can be established, business processes can end up in that state. Therefore, after recovering from one of these events, it is important to check the system for any failed events that need to be restarted or replayed.

Legend for database tables
Supported	S
Supported with Limitations	SWL
Not Supported	NS

* indicates IBM Business Process Manager Server, IBM Business Process Manager Advanced, and IBM Business Process Manager Standard only

(#) indicates which note applies in the list following the table

[#] indicates minimum database level required

Note: Required IBM BPM or IBM Business Monitor product levels are noted in the table if they are higher than the base level identified.

IBM Db2 database support for IBM Business Process Manager and IBM Business Monitor

		IBM Business Process Manager*									IBM Business Monitor
Versions	Database software type or feature	8.6.0 CF2018.03 and later	8.6.0 CF2017.12 and earlier	8.5.7	8.5.6	8.5.5	8.5.0	8.0.1	8.0	7.5.x	8.5.7	8.5.6	8.5.5	8.0.1	8.0	7.5.x
11.1	Workgroup Server Edition	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
	Advanced Workgroup Server Edition	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
	Enterprise Server Edition	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
	Advanced Enterprise Server Edition	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
	HADR	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
	pureScale (1)	S	S	S, IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	S	NS	NS	NS	NS	NS
10.5	Advanced Server Edition	S	S	S	S	S	S	S, IBM BPM V8.0.1.2 or higher	NS	S, IBM BPM V7.5.1.2 or higher	S	S	S	S, IBM Business Monitor V8.0.1.2 or higher	NS	S, IBM Business Monitor V7.5.1.2 or higher - Requires JR50127
	Enterprise Server Edition	S	S	S	S	S	S	S, IBM BPM V8.0.1.2 or higher	NS	S, IBM BPM V7.5.1.2 or higher	S	S	S	S, IBM Business Monitor V8.0.1.2 or higher	NS	S, IBM Business Monitor V7.5.1.2 or higher - Requires JR50127
	HADR	S	S	S	S	S	S	S, IBM BPM V8.0.1.2 or higher	NS	S, IBM BPM V7.5.1.2 or higher	S	S	S	S, IBM Business Monitor V8.0.1.2 or higher	NS	S, IBM Business Monitor V7.5.1.2 or higher - Requires JR50127
	pureScale (1)	S	S	S	S	S	S, IBM BPM V8.5.0.1 or higher	S	NS	S, IBM BPM V7.5.1.2 or higher	S	S	S	S	NS	S, IBM Business Monitor V7.5.1.2 or higher - Requires JR50127
10.1	Enterprise Server Edition	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS
	HADR	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS
	pureScale (1)	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS	S, [10.1.0.1]	S, [10.1.0.1]	S, [10.1.0.1]	S	NS	NS
9.8	pureScale (1)	NS	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	- S, IBM BPM V7.5.1: [9.8.0.3] - IBM BPM V7.5: [9.8]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	S, [9.8.0.4]	NS
9.7	Enterprise Server Edition	NS	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]
9.7	HADR	NS	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	NS	S, [9.7.0.5]	S, [9.7.0.5]	S, [9.7.0.4]	S, [9.7.0.4]	S, [9.7.0.4]	NS
9.5	Enterprise Server Edition	NS	NS	NS	NS	NS	NS	S, [9.5.0.7]	S, [9.5.0.7]	S, [9.5.0.7]	NS	NS	NS	SWL, (2) [9.5.0.7]	S, [9.5.0.7]	S, [9.5.0.7]
9.5	HADR	NS	NS	NS	NS	NS	NS	S, [9.5.0.7]	S, [9.5.0.7]	NS	NS	NS	NS	SWL, (2) [9.5.0.7]	S, [9.5.0.7]	NS

IBM Db2 limitations

All IBM Db2 pureScale versions are subject to entitlement.

Oracle database support for IBM Business Process Manager and IBM Business Monitor

		IBM Business Process Manager*									IBM Business Monitor
Versions	Database software type or feature	8.6.0 CF2018.03 and later	8.6.0 CF2017.12 and earlier	8.5.7	8.5.6	8.5.5	8.5.0	8.0.1	8.0	7.5.x	8.5.7	8.5.6	8.5.5	8.0.1	8.0	7.5.x
19c	Standard Edition	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Enterprise Edition	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	RAC (2,3)	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Data Guard	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Multitenant support	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Secure file LOBs	S, (9)	S, (9)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
18c	Standard Edition	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
	Enterprise Edition	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
	RAC (2,3)	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
	Data Guard	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
	Multitenant support	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
	Secure file LOBs	S, (10)	S, (10)	NS	NS	NS	NS	NS	NS	NS	S, (7)	NS	NS	NS	NS	NS
12c R2	Standard Edition	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
	Enterprise Edition	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
	RAC (2,3)	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
	Data Guard	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
	Multitenant support	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
	Secure file LOBs	S, [12.2.0.1]	S, [12.2.0.1] IBM BPM V8.6 CF 2017.12	NS	NS	NS	NS	NS	NS	NS	S, [12.2.0.1] (8)	NS	NS	NS	NS	NS
12c R1	Standard Edition	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.0.2	S, [12.1.0.1.0] IBM BPM V8.0.1.3 or higher	NS	NS	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	NS	NS	NS
	Enterprise Edition	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.0.2	S, [12.1.0.1.0] IBM BPM V8.0.1.3 or higher	NS	NS	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	NS	NS	NS
	RAC (2,3)	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.0.2	S, [12.1.0.1.0] IBM BPM V8.0.1.3 or higher	NS	NS	SWL, (5) [12.1.0.1.0]	SWL, (5) [12.1.0.1.0]	SWL, (5) [12.1.0.1.0]	NS	NS	NS
	Data Guard	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.0.2	S, [12.1.0.1.0] IBM BPM V8.0.1.3 or higher	NS	NS	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	NS	NS	NS
	Multitenant support	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.7.0 CF2016.09 or higher	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Secure file LOBs	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0] IBM BPM V8.5.0.2	NS	NS	NS	S, [12.1.0.1.0]	S, [12.1.0.1.0]	S, [12.1.0.1.0]	NS	NS	NS
11g R2	Standard Edition (4)	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]
	Enterprise Edition	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]
	RAC (1,2,3)	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2] IBM BPM V8.0.1.1 or higher	SWL, [11.2.0.2]	NS	SWL, (5) [11.2.0.2]	SWL, (5) [11.2.0.2]	SWL, (5) [11.2.0.2]	SWL, [11.2.0.2]	SWL, [11.2.0.2]	SWL, [11.2.0.2]
	Data Guard	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS
	Secure file LOBs	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS	NS	NS	S, [11.2.0.2]	S, [11.2.0.2]	S, [11.2.0.2]	NS	NS	NS
11g R1	Standard Edition (4)	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.6]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.6]
	Enterprise Edition	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.6]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.6]
	RAC (1,2,3)	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7] IBM BPM V8.0.1.1 or higher	SWL, [11.1.0.7]	SWL	SWL, (5) [11.1.0.7]	SWL, (5) [11.1.0.7]	SWL, (5) [11.1.0.7]	SWL, [11.1.0.7]	SWL, [11.1.0.7]	SWL
	Data Guard	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	NS
	Secure file LOBs	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	NS	NS	NS	S, [11.1.0.7]	S, [11.1.0.7]	S, [11.1.0.7]	NS	NS	NS
10g R2	Standard Edition	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	S, [10.2.0.2]
10g R2	Enterprise Edition	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	S, [10.2.0.2]

Oracle limitations

Beginning with IBM Business Process Manager Version 8.0.1.1, Oracle RAC is supported in active/active and active/passive modes. Prior to version 8.0.1.1, Oracle RAC is supported only in active/passive mode.
Manual interventions are required in the database configuration to set up the IBM Business Process Manager products with Oracle RAC. These limitations are described in the following topics:
- Version 7.5: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 7.5.1: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.0.0: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.0.1: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.5.0: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.5.5: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.5.6: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.5.7: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
- Version 8.6.0: Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
IBM Business Process Manager does not use the Oracle RAC Fast Application Notification (FAN) feature.
IBM Business Monitor does not support Oracle RAC in active/active mode.
Oracle Database 11g Standard Edition One R1 and Oracle Database 11g Standard Edition One R2 are not supported.
Oracle Database 11g Enterprise Edition R2 and Oracle Database 11g Standard Edition R2 are deprecated in IBM BPM V8.6 CF 2017.12 and removed in IBM BPM V8.6 CF 2018.03.
IBM Cognos Business Intelligence 10.2.2 does not support Oracle 18c and cannot be installed. Cognos-related functionality, including the Report Viewer and Report Designer widgets, is not supported.
Oracle 12c R2 support requires IBM Cognos Business Intelligence 10.2.2 Fix Pack 8.
Oracle 19c second and third digit releases are supported.
Oracle 18c second and third digit releases are supported.

Note: The Oracle Exadata product can be used to provide the infrastructure for several Oracle database versions that are supported by IBM Business Process Manager (BPM). Although IBM BPM does not leverage any specific features of Oracle Exadata, you can run IBM BPM databases on Oracle Exadata if the corresponding Oracle database version is supported by IBM BPM.

Microsoft SQL Server database support for IBM Business Process Manager and IBM Business Monitor

		IBM Business Process Manager*								IBM Business Monitor
Versions	Database software type or feature	8.6.0	8.5.7	8.5.6	8.5.5	8.5.0	8.0.1	8.0	7.5.x	8.5.7	8.5.6	8.5.5	8.0.1	8.0	7.5.x
2017	Enterprise Edition (1,2,8)	S, IBM BPM V8.6 CF 2018.03 or higher	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Always on Availability (3)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2016	Enterprise Edition (1,2,8)	S	S	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Always on Availability (3)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2014	Enterprise Edition (1,2,8)	S	S	S	NS	NS	NS	NS	NS	S	S	NS	NS	NS	NS
	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Always on Availability (3)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2012	Enterprise Edition (1,2,8)	S	S	S	S	S	S, IBM BPM V8.0.1.3 or higher	NS	NS	NS	NS	S	S, IBM Business Monitor V8.0.1.3 or higher	NS	NS
	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
	Always on Availability (3)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2008 R2	Enterprise Edition (1,2,8)	S	S	S	S	S	S	S	S	NS	NS	S	S	S	S
2008 R2	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2008	Enterprise Edition (1,2,8)	SWl, (6)	SWL, (6)	SWL, (6)	SWL, (6)	SWL, (6)	S	S	S	NS	NS	SWL, (6)	S	S	NS
2008	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS
2005	Enterprise Edition (1,2,8)	NS	NS	NS	NS	NS	SWL, (7) [2005 SP3]	SWL, (7) [2005 SP3]	S, [2005 SP3]	NS	NS	NS	SWL, (7) [2005 SP3]	SWL, (7) [2005 SP3]	NS
2005	FCI (4)	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS	NS

Microsoft SQL Server limitations

XA transactions must be configured.
High Availability events require manual intervention -- As described on the Microsoft Support website ( Orphaned XA transactions when you connect to SQL Server by using JDBC Driver for SQL Server ) loss of communication between the IBM BPM server and its database (for example, caused by a software or network failure) may result in orphaned transactions that persist in the database and hold resources (such as database locks) active indefinitely. Resolving these orphaned transactions might require manual rollback or restarting the IBM BPM and Database servers. More details can be found on the IBM Support site: Orphaned XA transactions might exist when using Microsoft SQL Server with IBM Business Process Manager (BPM)
Important: Be aware that many customers find that this manual intervention can undermine the high availability behavior you are attempting.
AlwaysOn Availability Groups: AlwaysOn Availability Groups is not supported for applications that use distributed transactions. Therefore, do not use this feature with IBM BPM.
Failover Cluster Instances (FCI): IBM BPM has not been certified by using the FCI feature with the databases housing the IBM BPM product data. Therefore, the IBM BPM support teams might require that problems under investigation be reproduced without this feature present to continue problem determination activities. The intermittent nature of the issues that might occur during a High Availability event makes this reproduction extremely challenging. Therefore, it is not recommended to use the FCI feature with IBM BPM.
The WebSphere Application Server software upon which IBM BPM is built does not declare formal support for FCI. Support for this feature falls under the ‘Other Categories’ description available at the WebSphere support site: WebSphere Application Server Support Statement . IBM BPM support takes the same position as the WebSphere base.
WebSphere Application Server does not support storing transaction logs in Microsoft SQL Server. Because of this limitation, IBM BPM and IBM Business Monitor do not support database-managed replication options.
Microsoft SQL Server Enterprise Edition 2005 is deprecated for IBM BPM versions 8.0.x and IBM Business Monitor versions 8.0.x.
Microsoft SQL Server Enterprise Edition 2008 is deprecated for IBM BPM versions 8.5.x and IBM Business Monitor version 8.5.5. It is removed for IBM BPM V8.6 CF 2018.03.
Microsoft SQL Server Enterprise Edition 2008 R2 is deprecated for IBM BPM V8.5.7 and IBM Business Monitor V8.5.7. It is removed for IBM BPM V8.6 CF 2018.03.
IBM BPM V8.6.0 (2017.09) and later releases support only the sqljdbc42.jar driver. Before you can use the sqljdbc42.jar driver with IBM BPM V8.6.0 (2017.09) or IBM BPM V8.6.0 cumulative fix (CF) 2017.12, you must apply the IBM BPM interim fix JR59388.

Related Information

Advanced database support for IBM Business Automation Workflow 18.0.0.1 and lat…

[{"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.6.0.0","Edition":"IBM Business Process Manager Server","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5.7;8.5.6;8.5.5;8.5;8.0.1;8.0;7.5.1;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SS7NQD","label":"IBM Business Monitor"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Monitor Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5.7;8.5.6;8.5.5;8.0.1;8.0;7.5.1;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation \/ Configuration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.5.7;8.5.6;8.5.5;8.5;8.0.1;8.0;7.5.1;7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Product Synonym

BPM;Monitor

Was this topic helpful?

Document Information

Modified date:
23 June 2023

UID

swg21578920

Tips