Therefore, the alias that you set on the data source must be identical to the alias in the application code. Sign up or log in Sign up using Google. That is, a transaction running across say 2 databases. Then try to create the connection and import the DB2 data source and try running the data viewer on this data object. The user is me! Go to original post. Do not set this property if driverType is set to 2.

Uploader: Disar
Date Added: 2 July 2008
File Size: 57.46 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 93689
Price: Free* [*Free Regsitration Required]

To create a JDBC provider: Do you know if the user in the connection defined on the Administrator page has necessary privilege to execute the package? This file is not required; however, if it is not provided, universal driver default processing is performed. To resolve this issue, grant the following privileges on the DB2 owner: To define the db2.

Log out from the DBA user account. Then what is Type 4 XA driver? Thank you, Suraj Informatica Support.

JDBC and Non-XA Data Source

I’m a new user to the PowerCenter express. This tool uses JavaScript and much of it will not work correctly without it enabled. A standard protocol for a global transaction between one transaction coordinator and several transaction managers.


Administrative console scope settings. Save your configuration by clicking OK. If you have multiple local DB2 subsystems, you can specify a DB2 subsystem identifier not location name on the ssid custom property on your data source. Click X to save the new JVM property. Refer to this readme file for details on how to set up and perform the required binding.

Configuring a DB2 XA connection |JBoss Developer

If your application does not require that connections support two-phase commit transactions, and you plan to use type 4 connectivity, choose Connection Pool Data Source. Choose XA Data Source vb2 your application requires connections that support two-phase commit transactions.

Log in with the database user account. When this custom property is specified, the data source connects to this identifier as the local subsystem name.

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Stack Overflow works best with JavaScript enabled. Do not set this property if driverType is set to 2. But well, at our customer we mostly need it: Select a JDBC driver from the drop-down list.


From the third drop-down list, select the implementation type that is necessary for your application. Configuring two resource reference files on the same data source You can configure two resource reference files on the same data source. Sign up using Email and Password. Extended data source properties Use this page to set the extended data source kdbc for a DB2 database. Please turn JavaScript back on and reload this page.

Go to original post. You cannot post a blank message. You can type different values for these fields; they exist for administrative purposes only. For more information about using this load module, see the readme file packaged with the universal driver.

I wonder if it’s because I have only Read access to the tables?