server job failing due to ds_loadlibrary: error in dlopen

kalyanvinnakota · Post by **kalyanvinnakota** » Mon Nov 07, 2005 8:38 am

Hi all

I am facing a problem with on e of the server job.

I can see the following info in the log.
stastaXelusPLNREQMTExt..xfmMap1: C Stage PlugIn function "Get" required
[b]stastaXelusPLNREQMTExt..xfmMap1: |-2|
ds_loadlibrary: error in dlopen[/b]
This job is having DB2 plugin and also I am not able to connect to the local db2 where actually the table is located through this plugin
it shows the following message.
[b]ds_loadlibrary:error in load open[/b]

I am able to connect to Loal DB2 through command prompt. but I am not able to connect to the table through the DB2 plugin.

This is a production job Could any one please help me in this issue.

Thanks & regards
Kalyan

dzdiver · Post by **dzdiver** » Mon Nov 07, 2005 9:00 am

This is likely because your $DSHOME/dsenv file has not the correct variables such as shared library path set.
Try reading the client plug-in installation and configuration pdf documentation installed with your DS client.

Or search the forum. This has been covered before.
Good luck,
B.

roy · Post by **roy** » Mon Nov 07, 2005 9:03 am

Hi,
How do other jobs connect to DB2?
(since you say version 6 I presume there are such working jobs)

kalyanvinnakota · Post by **kalyanvinnakota** » Tue Nov 08, 2005 4:46 am

Hi,

I am having some more jobs which use the db2 plug in but i am not facing any problem with that while running it. its running fine.
But if I try to connect to the DB2 plugin of that job I am not able to look into the data and it giving me the same error.

ds_loadlibrary: error in dlopen

[quote="roy"]Hi,
How do other jobs connect to DB2?
(since you say version 6 I presume there are such working jobs)[/quote][b][/b]

dprasanth · Post by **dprasanth** » Tue Nov 08, 2005 5:30 am

kalyanvinnakota wrote:Hi all

I am facing a problem with on e of the server job.

I can see the following info in the log.
stastaXelusPLNREQMTExt..xfmMap1: C Stage PlugIn function "Get" required
stastaXelusPLNREQMTExt..xfmMap1: |-2|
ds_loadlibrary: error in dlopen
This job is having DB2 plugin and also I am not able to connect to the local db2 where actually the table is located through this plugin
it shows the following message.
ds_loadlibrary:error in load open

I am able to connect to Loal DB2 through command prompt. but I am not able to connect to the table through the DB2 plugin.

This is a production job Could any one please help me in this issue.

Thanks & regards
Kalyan

Kalyan,
I had the same problem with ORACLE and I added the ORACLE lib path in the dsenv file(LD_LIBRARY_PATH). Make sure you execute the dsenv file and then RESTART THE DS Services. I am not sure whether the same will work with DB2, but this is just my suggestion

DSXchange