Packages cannot be created in an XA Connection. This table must be set up at each DB2 V7 location that is accessed. Therefore, the alias that you set on the data source must be identical to the alias in the application code. You don’t have JavaScript enabled. I don’t unstand the error message that I’m getting back. What is Type 4 XA driver? I’m a new user to the PowerCenter express.

Uploader: Arashit
Date Added: 18 November 2016
File Size: 31.54 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 87037
Price: Free* [*Free Regsitration Required]

Configuring two resource reference files on the same data source You can configure two resource reference files on the same data source.

Similar Threads

To select an existing JDBC provider: This content has been marked as idbc. Applications that use this data source configuration have the benefit of container-managed transaction recovery. Thank you, Suraj Informatica Support. This property is required only if driverType is set to 4. If you have multiple local DB2 subsystems, you can specify the db2.

What to do next. Then what is Type kdbc XA driver? The name of the property is db2. Administrative console scope settings.

  EMULEX L2B1817 DRIVER

Post as a guest Name. Most likely you also do not need to change the native library dbb2 or the data source implementation class name.

When the database user account connects to the database with the DB2 Wire Protocol driver, the correct package is created automatically. Hope this helps you.

Please enter your message and try again. Extended data source properties Use this page to set the extended data source properties jdvc a DB2 database.

Data source minimum required settings, by vendor. Use only driverType 4 connectivity for the XA data source. Therefore, the alias that you set on the data source must be identical to the alias in the application code. This table must be set up at each DB2 V7 location that jbdc accessed.

Correct Answers – 4 points. See here for more details. That is, a transaction running across say 2 databases. I don’t unstand the error message that I’m getting back.

Using the DB2 Universal JDBC Driver to access DB2 for z/OS

Log out from the DBA user account. To configure a Version 4 data source complete the following steps: For more information about using this load module, see the readme dbb2 packaged with the universal driver. Typically you jxbc not need to change the class path that already populates the field. You now see the page entitled Enter database-specific properties for the data source.

  JETWAY NC91-230-LF DRIVER

I also contacted a buddy of my who has been using Informatica for a long time now. I usually download my data into a csv files and then use Excel to create reports.

Hi Glenn, To resolve this issue, grant the following privileges on the DB2 owner: From this point onward, the steps for creating data sources WebSphere Application Server Version 4 differ from the steps for creating data sources of the latest standard version. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Do you know if the user in the connection defined on the Administrator page has necessary privilege to execute the package?