Installing RM - Enabling XA transactions

The IBM® Records Manager engine requires your database management system to process XA transactions.

For DB2® databases, XA is enabled by default and does not require further action.

If you created a new Oracle database using the DBCA templates shipped with IBM Records Manager or DB2 Content Manager, XA has already been enabled on the new database and you do not have to enable it again. If you plan to co-locate your IBM Records Manager and DB2 Content Manager library server databases, XA must be enabled on the DB2 Content Manager library server database.

SQL Server databases require you to enable XA transactions.

To enable XA transactions for Oracle databases follow these steps.

Add the java_pool_size 12000000 and shared_pool_size 24000000 parameters to the Oracle instance configuration file.
Log on to Oracle as the SYSOPER or SYSDBA user and run the initjvm.sql and initxa.sql scripts in the Oracle_Home\javavm\install directory, where Oracle_Home is the location where you installed Oracle.
Grant SELECT, INSERT, UPDATE, DELETE privileges of DBA_PENDING_TRANSACTIONS to icmadmin and system.
Restart the Oracle database for the changes to take effect.

Here is an example of SQL scripts to run for Windows®. Replace C:\oracle\ora10g\javam\install with the directory where you installed Oracle:

>set ORACLE_SID=icmnlsdb
>sqlplus "/ as sysdba"
sql>create spfile from pfile
sql>shutdown immediate
sql>startup
sql>ALTER SYSTEM SET JAVA_POOL_SIZE=120M scope=spfile;
sql>ALTER SYSTEM SET SHARED_POOL_SIZE=240M scope=spfile;
sql>create pfile from spfile;
sql>shutdown immediate;
sql>startup;
sql>@C:\oracle\ora10g\javavm\install\initjvm.sql;
sql>@C:\oracle\ora10g\javavm\install\initxa.sql;
sql>grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to icmadmin;
sql>grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to system;
sql>shutdown immediate;
sql>startup;
sql>exit;

For SQL Server databases, XA transactions are not enabled by default when you install a new SQL Server. To enable XA transactions, install the IBM-branded DataDirect Technologies Connect JDBC driver, release 3.4. To obtain the driver, download ConnectJDBC34-JTA.zip from ftp://ftp.software.ibm.com/software/websphere/info/tools/DataDirect/datadirect.htm.

Before you begin, read these two documents:

Follow these steps to install the driver on the computer where the SQL Server database server is installed:

Stop Microsoft® SQL Server.
Uncompress the file SQLServerJTA.zip.
The compressed file contains the following four files:
- A 32-bit file for sqljdbc.dll and a corresponding instjdbc.sql script
- A 64-bit file for sqljdbc.dll and a corresponding instjdbc.sql script
Replace the existing sqljdbc.dll file in the SQL Server /binn/ directory with the appropriate file (32- or 64-bit) from SQLServerJTA.zip.
Restart Microsoft SQL Server.
Run the appropriate instjdbc.sql file from SQLServerJTA.zip.
Restart WebSphere® Application Server where IBM Records Manager is installed.