Unable to Initialize Db2 plugin

[ketfos]

Hi,

I am using DB2 plugin DB2_UDB_API_5 in datastage 7.5
When I try to import table definition using Plugin Meta Data Definitions and select IBM Db2 data Access Plugin from the screen and click ok,
it gives error message "
Unable to Intialize plugin"

Can you suggest what step I am missing?

Ketfos

[kris007]

Did you try installing the DB2plugin ( DB2stage) seperately? Or did you include it while installing DataStage?

[ketfos]

Hi,
Db2 plugin was installed after a year of datastage initial installation.

Ketfos

[kris007]

Was that recently? Did you restart the server after you installed the plugin? I had the same problem in the past and restarting the server after installing made it work fine. Do you think it is the same problem in your case?

[ketfos]

Hi,
Last month we brought the server down.
Installed DB2 and Oracle9i plugins. and brought server up
We were able to use Oracle9i plugin without any issue.

This morning I tried Db2 plugin and came across this problem of intializing

Ketfos

[DSguru2B]

are you referencing the db2 profile in your dsenv file?

[ketfos]

Hi,
Do I manually need to make some changes in the file after I install plugins?

Ketfos

[DSguru2B]

Yes. I think thats what it is. You are not sourceing the db2 profile in your dsenv file. And yes you have to manually put that in there.
Also, try building an odbc connection to your db2 and then try to import the db2 table meta data from odbc import and see if you can do that. Then try using the DB2 API stage to connect to your database. Does that work?

[ketfos]

Hi,

1. What entry/text/command I need to put in dsenv file for intializing Db2 plugin?


Ketfos

[DSguru2B]

I dont know where does your db2profile sit.
For me its

Code: Select all

. /export/home/dsadm/sqllib/db2profile

[lstsaur]

Ketfos,
In order to use DB2 plug-in and DB2 UDB API Stage, you should install the DB2 Connect first, then set the following environment variables in your dsenv file:
INSTHOME=/home/db2inst1;export INSTHOME
DB2INSTANCE=db2inst1;export DB2INSTANCE
DB2DIR=/opt/IBM/db2/V8.1;export DB2DIR
DB2CLIINIPATH=/home/dsadm/Ascential/DataStage/DSEngine;export DB2CLIINIPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib; export LD_LIBRARY_PATH

And don't forget to bounce the DataStage server whenever you have updated the dsenv file.

[ravish_ram]

We have installed Datastage (7.5.1) and DB2 instance on the same Unix box. When importing metadata from DB2 plug in I get the same message " Unable to initialize plug-in", though I tried all the steps mentioned by Istsaur.
However in another installation, where we had just the Datastage server and a DB2 client (in UNIX), I was able to get the plug in to work.

Should the settings be different if I have the Datastage and DB2 instance on the same server?