Sybase ase xa distributed transaction support, sybaseasexa
By default, Sybase ASE installation does not support XA.You must obtain the DTM License from Sybase. The SYSAM service is not started by default. SYSAM is a service that manages various protocols in Sybase ASE.
Roles of SyBase usersWhat about:
Dtm_tm_role: Two-Phase DTM option submission function management permission
Ha_role HA Option
Management permissions of js_admin_role Job Scheduler tasks
Js_client_role Job Scheduler task execution permission
Js_user_role permission for creating and running jobs in Job Scheduler
Messaging_role can run the msgsend and msgrecv functions.
Mon_role can access the ase monitor table, which starts with mon.
Navigator_role is used for navigation server or sybase MPP Components
Oper_role system operator, which executes database dump/load
Replication_role replication server Management permission
Sa_role ase System Administrator
Sso_role ase System Security Officer
Sybase_ts_role sybase technical support role
To allow the SyBase database system to obtain XA transaction support, you must set the dtm_tm_role role for the Login account. This is not difficult. In Sybase Central, select the roles menu under ASE Server and set the Logins attribute for the dtm_tm_role role:
The settings are as follows:
