Page 1 of 1
Error while loading data to DB2 table
Posted: Thu Jun 10, 2010 7:09 am
by agpt
Hi All,
I am trying to load some data to DB2 table and getting the following error:
main_program: Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o.
0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o.
0509-150 Dependent module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o could not be loaded.. [api/opreg.C:287]
Can anybody tell me what may be happening?
Re: Error while loading data to DB2 table
Posted: Thu Jun 10, 2010 7:16 am
by ArndW
agpt wrote:Hi All,
I am trying to load some data to DB2 table and getting the following error:
main_program: Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o.
0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o.
0509-150 Dependent module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o could not be loaded.. [api/opreg.C:287]
Can anybody tell me what may be happening?
Posted: Thu Jun 10, 2010 7:20 am
by chulett
Do an exact search for Error loading "orchdb2op" and see if any of the other people having the same issue help you out.
Posted: Thu Jun 10, 2010 7:28 am
by antonyraj.deva
Hi Arulan,
The "orchdb2op.o" file is not present in the version 8. Instead "orchdb2op
8.o" will be present.
The confusing bit is why datastage is searching for a non existent file
--Tony
Posted: Thu Jun 10, 2010 8:32 am
by chulett
Search. I'm assuming it looks for a more 'generic' name that is linked to the proper versioned file and I've seen that link creation fail (for whatever reason) during setup. Manually creating it gets you going again.
My
guess for the solution here based on personal experience with other databases.
Re: Error while loading data to DB2 table
Posted: Mon Jun 14, 2010 4:54 am
by ghila
Hi,
I already got this problem last week. Seems the problem is not on "orchdb2op" library but on the "libdb2.a" first. "libdb2.a" is a DB2 libray.
So if you add the path to .../lib64 in LIBPATH in dsenv file, that should work.
We added /opt/IBM/db2/V9.5/lib64 and that worked for us. You can do a "find" for "libdb2.a" on your machine in order to see what path you should use.
Regards.
Daniel
Posted: Wed Jun 23, 2010 2:29 am
by antonyraj.deva
Hi Daniel,
I'm facing the same issue too. The version of DB2 we use is 8 with Fix Pack 11 (That makes it V8.2).
The libdb2.a is available either for V9/lib32 or V9/lib64. Now which entry should I make in the dsenv file.
And is DB2 V8.2 compatible with DS 8.1?
Thanks in advance....
Posted: Wed Jun 23, 2010 2:40 am
by ray.wurlod
lib64 if you have a 64-bit version of DataStage (e.g. on AIX 6.1) or lib32 if you have a 32-bit version of DataStage.
DataStage is just another client application as far as DB2 is concerned. We are using DataStage 8.1 to connect to DB2 versions 7.1.1, 9.5 and 9.7. Based on that combination, I would have to deduce that 8.2 is also possible.
Posted: Wed Jun 23, 2010 4:37 am
by antonyraj.deva
Hi Ray,
We 64 bit AIX and hence I modified the LIBPATH to lib64. Still I'm unable to load.
I'll paste the complete log details in a new post.
Thanks for the help.