Setting up XA resources

This section describes procedures for configuring and enabling XA resources on Adaptive Server and EJB Server.

To configure Adaptive Server and EJB Server for XA resources:

You can also perform steps 2 and 4 from the Adaptive Server plug-in.

Make a copy of the $SYBASE/$SYBASE_EJB/config/afconfig.dat file and move the copy to a secure location. If the XA configuration process fails, you will need to copy an uncorrupted version of this file back into the release area before reconfiguring XA resources.
Enable Distributed Transaction Management (DTM) on Adaptive Server:
```
sp_configure 'enable dtm', 1
```
Run the script sqlserver12.sql located in $SYBASE/$SYBASE_EJB/html/classes/sp.
Grant the dtm_tm_role system role to the user in Adaptive Server:
```
sp_role 'grant', dtm_tm_role, user_name
```
Create the OTS/XA transaction log device in $SYBASE/$SYBASE_EJB:
- From the UNIX command shell, execute:
```
echo x | dd seek=8k of=server_nameOTSLog.dev
```
- From the DOS prompt on Windows NT, execute:
```
Filevol server_nameOTSLog.dev 4000K
```
where server_name is the physical name of your EJB Server. If you do not create a log file, EJB Server will not start up.
Shutdown and restart Adaptive Server.

To enable EJB Server for OTS/XA transactions:

Enable the EJB Server for OTS/XA transactions from the Adaptive Server plug-in: