seexadef: administer XA resource definitions

Syntax

seexadef action options  

This utility is used to create, delete and list XA resource definitions.

Action Parameter

-create
Create an XA resource definition.
-delete
Delete an XA resource definition.
-list
List XA resource definitions.

Options Parameter

  • All actions:
    -usedb
    Use the cross-region database on the default SQL Server instance to host the XA resource definitions (default).
    -usedb:<database-server-instance>
    Use the cross-region database on the named SQL server instance to host the XA resource definitions.
  • For creating database definitions (-create -type:db):
    -connstring:"<connection-string>"
    Database connection string
    Note: The connection string needs to be enclosed in double-quotes only if it contains spaces.
    -enlist
    Enlist the database connection in the global transaction (default).
    -name:<name>
    Name of the database XA resource definition to be created.
    -noenlist
    Do not enlist the database connection in the global transaction.
    -packagepath:<package-path-name>
    Name of the package path to be used for the connection.
    -packageset:<package-set-name>
    Name of the package set to be used for the connection.
    -plan:<application-plan-name>
    Name of the application plan to use for the connection.
    -provider:<provider-name>
    Name of the .NET database provider to be used for the connection (default System.Data.SqlClient).
    -region:<region-name>
    Name of the region to associate with the XA resource definition. If not specified, the XA resource definition will be associated with all regions.
    -type:db
    Database XA resource definition.
  • For creating MQ definitions (-create -type:mq):
    -channel:<channel-name>
    MQ channel name.
    -connname:<connection-name>
    MQ connection or machine name.
    -name:<name>
    Name of the MQ XA resource definition to be created.
    -qmname:<queue-manager-name>
    MQ queue manager name.
    -region:<region-name>
    Name of the region to associate with the XA resource definition. If not specified, the XA resource definition will be associated with all regions.
    -type:mq
    MQ XA resource definition.
  • For deleting XA resource definitions:
    -name:<name>
    Name of the MQ XA resource definition to be deleted.
    -region:<region-name>
    Name of the region associated with the XA resource definition. If not specified, the XA resource definition is assumed to be associated with all regions.
    -type:db|mq
    Database or MQ XA resource definition.
  • For listing XA resource definitions:
    -type:db|mq
    Database or MQ XA resource definitions. If omitted, both types of XA resource definitions will be listed.

Examples

seexadef -create -type:db -name:xyz -connstring:abcdefg
Creates a database XA resource definition named xyz with a connection string of abcdefg in the cross-region database of the default SQL Server instance.
seexadef -create -type:mq -name:abc -connname:mymc -qmname:QMA -channel:CQMA
Creates an MQ XA resource definition named abc with a connection name of mymc, queue manager name of QMA and channel name of CQMA in the cross-region database of the default SQL Server instance.
seexadef -delete -type:db -name:xyz
Deletes the database XA resource definition named xyz from the cross-region database of the default SQL Server instance.
seexadef -delete -type:mq -name:abc -region:ESDEMO
Deletes the MQ XA resource definition named abc associated with the ESDEMO region from the cross-region database of the default SQL Server instance.
seexadef -list
Lists both the database and MQ XA resource definitions that have been defined in the cross-region database of the default SQL Server instance.
seexadef -list -type:db
Lists the database XA resource definitions that have been defined in the cross-region database of the default SQL Server instance.
seexadef -list -type:mq
Lists the MQ XA resource definitions that have been defined in the cross-region database of the default SQL Server instance.