Sunday, 29 June 2014

How to import Metadata using DB2 Connector from IMAM (InfoSphere Metadata Asset Manager) Window (or Information Server DataStage Client) on Unix OS



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.



Steps to Import MDI using IMAM GUI
1) Connect to IMAM GUI by using below link
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.”

1 comment:

  1. Thanks I can now see my list of interchange servers. How do you export to get the XML/XMI files you import

    ReplyDelete