Unable to Initialize Db2 plugin
Moderators: chulett, rschirm, roy
Unable to Initialize Db2 plugin
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
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
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?
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?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
I dont know where does your db2profile sit.
For me its
For me its
Code: Select all
. /export/home/dsadm/sqllib/db2profile
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.
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.
-
- Participant
- Posts: 1
- Joined: Mon Apr 03, 2006 7:30 am
- Location: Mumbai
Facing a similar problem
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?
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?