Sybase ASE XA Distributed transaction support

Source: Internet
Author: User
Tags sybase sybase database

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.