For any Connector Metadata import user needs to restart
the Node agent after setting all the required parameters of a connector. For
DB2 Connector we can do MDI (Metadata Import) using below steps
Steps
to setup DB2 environment prior to import (Please use root user for below steps)
1) Install
DB2 Client/Server on Information Server machine
2) Set
the DB2 related environments like DB2INSTANCE, LD_LIBRARY-PATH/LIBPATH, PATH
using one of the below steps
Source
db2profile, it can be done by below command
source /home/db2inst1/sqllib/db2profile (Where /home/db2inst1 is DB2 Home)
OR
Add
the below parameters in dsenv
PATH=/home/db2inst1/sqllib/bin:$PATH
export PATH
LD_LIBRARY_PATH=/home/db2inst1/sqllib/lib:$LD_LIBRARY_PATH export
LD_LIBRARY_PATH
DB2INSTANCE=db2inst1
export DB2INSTANCE
Now source dsenv and restart the
DSEngine.
*db2inst1- Instance
name of DB2 Client/Server
*LIBPATH needs to use
for AIX instead of LD_LIBRARY_PATH
3) Source
dsenv, it can be done by below command
source
/opt/IBM/InformationServer/Server/DSEngine/dsenv
4) Goto
/opt/IBM/InformationServer/ASBNode/bin/ and run restart the Node agent as ./NodeAgents.sh restart
5) Goto
DataStage Client or IMAM GUI Window and run the DB2 Connector Metadata import
steps.
https://localhost:9443/ibm/imam/console/loginForm.jsp (where as localhost is your machine hostname
or IP)
2) Goto
Administration tab and create Metadata Interchange Server.
3) Goto Import Tab
and Click on New Import Area
3) Select IBM
InfoSphere DB2 Connector From the
Bridge/Connector Selection after selecting Metadata Interchange Server and give
the Import area name and Click on Next button
4) Select the
DataConnection
5) Select Asset to
Import and click on Next button
6) Provide the Host
System name and click on next button
7) In next page
Select Express Import and click on
Import button
8) You can see the
imported assets Shared Import Tabs of IMAM Window
Summary: We
can import Metadata using DB2 Connector from IMAM GUI (or DataStage Client)
after restarting Node agent (after setting all the DB2 client related
environments) from root user.
Disclaimer:
“The
postings on this site are my own and don’t necessarily represent IBM’s
positions, strategies or opinions.”