The default Sybase ASE installation is not XA-capable , and you must obtain the DTM license from Sybase. Also, the default installation of the Sysam service is not initiated, and the Sysam service is a service that manages the various protocols within Sybase ASE.
What roles Sybase users haveit:
Dtm_tm_role Two-phase submission DTM Options feature administrative permissions
Ha_role Ha options Feature management permissions
Js_admin_role Job Scheduler administrative permissions for tasks
Js_client_role Job Scheduler Task execution permissions
Js_user_role permissions to create and run a job in job scheduler
Messaging_role can run Msgsend and MSGRECV functions
Mon_role can access the monitor table of the ASE, which begins with Mon
Navigator_role for navigation server or Sybase MPP components
Oper_role System Operator, execute database dump/load
Replication_role Replication Server administrative permissions
Sa_role ASE System Administrator
Sso_role ASE System security Officer
Sybase_ts_role Sybase Technical Support role
In order for the Sybase database system to obtain support for XA transactions, you must set the Dtm_tm_role role for the login account. It's not difficult. In Sybase Central, select the Roles menu under ASE Server and set the Logins property for the Dtm_tm_role role:
Settings are as follows:
Sybase ASE XA Distributed transaction support
