Content Platform Engine, Version 5.1   Database:  SQL          

Configuring the JDBC distributed transaction components

You must enable XA transactions on every Microsoft SQL Server that will have a Content Engine database.

Procedure

To enable XA transactions for Content Platform Engine databases.

  1. Download the Microsoft SQL Server JDBC Driver that is referenced in the IBM FileNet P8 system requirements document for Content Platform Engine SQL Server databases.
    Tip: Installation procedures for JDBC settings can vary by release. See the Microsoft website for full details.
  2. Copy the sqljdbc_xa.dll from the JDBC installation directory to the binn folder of the instance, although a pre-2.0 version of the driver also functions correctly from the tools\binn folder. For the 32-bit version of Microsoft SQL Server , use the sqljdbc_xa.dll file in the x86 folder. For the 64-bit version of Microsoft SQL Server, use the sqljdbc_xa.dll file in the x64 folder.
  3. Log on as the sa administrator or as a user with equivalent permissions and execute the database script xa_install.sql on the master database on every SQL Server instance that will participate in distributed transactions.
    Important: Use SQL Server database credentials, not Windows credentials, to log on. Windows Integrated Logon to SQL Server is not supported with IBM® FileNet® P8.
    This script installs sqljdbc_xa.dll as an extended stored procedure and creates the SqlJDBCXAUser role in the Master database.
  4. Add each database account (cpe_db_user) that Content Platform Engine uses to access SQL Server to the SqlJDBCXAUser role. This action grants permissions to those accounts to participate in distributed transactions with the JDBC driver.
  5. Click Component Services > My Computer > Properties > MSDTC > Security Configuration and ensure that XA transactions are enabled.


Last updated: March 2016
p8ppi028.htm

© Copyright IBM Corporation 2013, 2016.