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.
