473,549 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Information Integrator with Oracle

I just installed Information Integrator on my machine Windows XP db2
8.2.1. I want to connect to Oracle 9i. The closest thing I saw when
trying to create the wrapper was Oracle8. It says the Library name is
db2net8.dll but the error that comes up when I try to create it is "The
specified library "db2net8U.d ll" could not be loaded.
SQLSTATE=42724"
I found the db2net8U.dll in the f:\ibm\sqllib\b in directory so there is
no reason that it shouldn't find it. My question is why does the
wizard say the library is db2net8.dll and the error message looking for
db2net8U.dll.

Any help would be great.

Steven

Nov 12 '05 #1
2 2530
Ian
st**********@gm ail.com wrote:
I just installed Information Integrator on my machine Windows XP db2
8.2.1. I want to connect to Oracle 9i. The closest thing I saw when
trying to create the wrapper was Oracle8. It says the Library name is
db2net8.dll but the error that comes up when I try to create it is "The
specified library "db2net8U.d ll" could not be loaded.
SQLSTATE=42724"
I found the db2net8U.dll in the f:\ibm\sqllib\b in directory so there is
no reason that it shouldn't find it. My question is why does the
wizard say the library is db2net8.dll and the error message looking for
db2net8U.dll.


1) You probably need the relational wrappers installed (this is a
separate install from the base II product install)

2) Do you have the Oracle client software installed on your machine?

Nov 12 '05 #2
st**********@gm ail.com wrote:
I just installed Information Integrator on my machine Windows XP db2
8.2.1. I want to connect to Oracle 9i. The closest thing I saw when
trying to create the wrapper was Oracle8. It says the Library name is
db2net8.dll but the error that comes up when I try to create it is "The
specified library "db2net8U.d ll" could not be loaded.
SQLSTATE=42724"
I found the db2net8U.dll in the f:\ibm\sqllib\b in directory so there is
no reason that it shouldn't find it. My question is why does the
wizard say the library is db2net8.dll and the error message looking for
db2net8U.dll.

Comments from "backstage" :
The db2net8.dll is the TOP library and is used as a hook to load the
db2net8F.dll and db2net8U.dll libraries which
contain all the code necessary for the Net8 wrapper. When user issues
create wrapper we will load the db2net8.dll
and the db2net8U.dll sequentially. The problem you are seeing is
usually caused by a bad or unstable environment.
Please make sure the DB2 fixpack level you are using matches the II
fixpack level and make sure you reboot after
installing these and the Oracle client just incase some environment
variables and or registry variables aren't loaded
correctly. If the problem persist please clear out the db2dj.ini file
and update dbm cfg setting diaglevel to '1' and restart
your instance, after you recreate the problem you should see more
diagnostic info regarding the error in the db2dj.ini.
Hope any of that makes sense :-)
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
1730
by: tomL | last post by:
hello all! has anyone tried connecting Info integrator to Informix 9.x? if so, here are my questions....how much of the server's resources does it use? does it matter if using Info integrator pointing to a replicated instance versus the production instance? We use HDR on Informix and want the Info integrator to point to the HDR instance, not...
0
353
by: Ajay | last post by:
Hi , I have to check for Federated objects with Oracle & SQL server with UDB 8.2 but the release notes say that it require Information Integrator . Is it available anywere for testing purpose , am aware that one has to buy that . Thanks Ajay
1
1192
by: Earl Orenthe | last post by:
Hello all, does anybody know whether IBM Websphere Information Integrator supports distributed transactions, that is - can you update multiple heterogenous databases in one update, or at least in one transaction...? Thanks in advance, Earl
5
1222
by: peteh | last post by:
Hello All; We are soon implementing Websphere II to "federate" multiple Oracle DBs to our data warehouse hub (DB2 PE v8.1.5 on AIX). I wonder if IBMers or experienced II/Oracle users could comment on a couple of design alternatives we'd like to explore: * Should we implement II with Oracle wrapper right on the data warehouse box or build out...
3
1404
by: aww91 | last post by:
Need product information on IBM's Integration Integrator (I.I) for conversion of SyBase calls to UDB calls. Production allows for conversion of modules one-by-one and then when all modules are converted the database (SyBase) can be converted and I.I removed. Last I heard the product was in beta. Any information would be appreciated...
3
1308
by: RdR | last post by:
Hello all, Any information on how to join the "Serrano" Beta for the Next Websphere Information Integrator? Also info on how to join also the "Hawk" Beta? Supposed to be betas for enhancing DB2 Federation and Data Movement support. Thanks, RdR
5
5377
by: Michael Rudolph | last post by:
Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not use the existing tnsnames.ora. The Oracle client is installed and the connection to the Oracle database using tnsping and sqlplus is possible...
14
4419
by: peteh | last post by:
Hi All; We have many production jobs that "load from cursor" to a UDB/AIX 8.2 (with dpf) data warehouse from source tables residing Oracle 9i. Since Oracle dates are (roughly) equivalent to DB2 timestamps, we frequently use the date() function to "convert" from the Oracle date datatype to the DB2 date datatype. We have used this technique...
0
2060
by: Lester Knutsen | last post by:
A two-day IBM Informix and DB2 User Group Technical Conference - Friday and Saturday, December 8-9, 2006 Location - Fairview Park Marriott, Falls Church, VA (near Washington D.C.) ************************************************************************************************** Web site at:...
0
7472
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7986
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7504
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6074
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5114
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3518
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3499
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1965
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1083
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.