Previous Topic Next topic Print topic


To Associate a Database XA Resource with a PCT

When a transaction uses a SQL database, the connection string defined in the database XA resource definition associated with the region will, by default, be used to connect to that database. A database XA resource definition can be associated with a region at either the SIT or region startup file level. When specified in both the SIT and region start-up file, the region startup file takes precedence. However, if a database XA resource definition is defined for a PCT, that definition will be used in preference to the one associated with the region when the transaction is invoked. To associate a database XA resource definition with a PCT:
  1. Open the resource definition file using the Enterprise Server for .NET Administration UI's CICS Resources File Editor.
  2. Select the PCT you want to configure in the Results pane. See 1 in the diagram below. A properties window is now displayed to the right-hand side of the Results pane.
  3. Locate the SQL category in the properties window and enter the database XA resource definition name that you want associated with the PCT as the value of the XA resource name property. See 2 in the diagram below.
    Note: If you specify the database application plan, package path or package set property in the PCT's SQL category, this will override the database application plan, package path or package set property that has been configured for the database XA resource definition specified in the XA resource name property
  4. Choose File > Save , or click the Save icon in the toolbar to save the file. See 3 in the diagram below.

You must cold-start the region for the changes to take effect.

Previous Topic Next topic Print topic