DSXchange

Hi All,
I am facing a problem with my DSDB2 Stage. The whole environment was set up recently. I am getting the following error when i select view data from the stage " ds_loadlibrary: error in dlopen ". We have installed DB2 Client on the ETL Server (AIX) and specified the LIBPATH and floowing environment variables in dsenv.
DB2DIR
DB2INSTANCE
INSTHOME

Will anyone be able to give some input to the above problem.

Thanks,
Tom.

Is this this the first time you are trying to user DB2 stage?
Has it been setup properly?

-Kumar

Ya, this is the first time i'm trying to use DSDB2 Stage in the server.

I don't have access to DB2, so not that familiar with its setup. Have you followed all of the necessary configuration steps outlined in the Plug-in Installation and Configuration Guide for the stage? Have you stopped and restarted DataStage after you made the dsenv changes?

I would think there is more to the error than that - doesn't it tell you which object it couldn't load?

There's also a Help topic on DB2 configuration requirements. It's for DB2 Enterprise stage (parallel jobs) but it's still a useful checklist.

where did you specify the LIBPATH. in dsenv or environmental variable level. If you do not specify the in DSENV you will not be able to view data by view data tab but will be able to run the job.

You may also need to add the db2 configuration parameters into the .profile file of the etl user ( i.e. the user you sign on to DataStage with)

Make sure your libpath is set correctly.

Also you can verify the connectivity by trying to run db2 connect to "Database" from the unix command line.