Log out from the DBA user account. BalusC k You don’t have JavaScript enabled. Do not set this property if driverType is set to 2. The name of the property is db2. Log in as the database administrator DBA user.

Uploader: Taugal
Date Added: 24 May 2011
File Size: 53.14 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 40982
Price: Free* [*Free Regsitration Required]

This file is not required; however, if it is not provided, universal driver default processing is performed.

java – What is Type 4 XA driver? – Stack Overflow

A component-managed alias consists of an ID and password that are specified in an application for data source authentication. To select an existing JDBC provider: To resolve this issue, grant jdnc following privileges on the DB2 owner: Please turn JavaScript back on and reload this page.

It’s a manual process that I want to automate. Most likely you also do not need to change the native library path or the data source implementation class name. Go to original post. I usually download my data into a csv files and then use Excel to create reports.


See here for more details. Log in with the database user account.

To configure a Version 4 data source complete the following steps: Do you know if the user in the connection defined on the Administrator page has necessary privilege to execute the package? An XA transaction, in the most general terms, is a “global transaction” that may span multiple resources. Navigate to the appropriate page in one of two ways: You just point x the data sourse and use a connection string and you get back the tables. I assume it would be like hooking up a ODBC data source.

Jddbc standard protocol for a global transaction between one transaction coordinator and several transaction managers.

From the third drop-down list, select the implementation type that is necessary for your application. Email Required, but never shown.

Configuring a DB2 XA connection |JBoss Developer

The driver-general properties are typically specific to a driver jbdc, for example, server, rather than all servers using the JDBC provider, therefore, it is best to set this JVM property at the server level. The user is me! Save your configuration by clicking OK. Use only driverType 4 connectivity for the XA data source.


Signing in to Informatica Network

I have read only access to the back end. Stack Overflow works best with JavaScript enabled. Then what is Type 4 XA driver?

Configuring two resource reference files on the same data source You can configure two resource reference files on the same data source. Good explanation on theserverside. Sign up or log in Sign up using Google.

Similar Threads

You don’t have JavaScript enabled. Sign up using Facebook. Extended data source properties Use this page to set the extended data source properties for a DB2 database.

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. Correct Answers – 4 points.