Sybase ase xa distributed transaction support, sybaseasexa

Source: Internet
Author: User
Tags sybase sybase database

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:





Related Article

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.