|Date Added:||18 November 2016|
|File Size:||31.54 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|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.
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.
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.
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.