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.
|Date Added:||2 July 2008|
|File Size:||57.46 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|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
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.
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?