DB2 Interaction

[dspxlearn]

Hi,


I am very new to AS400 systems on which our present database (DB2) is present.
Now, we need to interact with the DB2 database using Datastage EE.
Can we connect to the DB2 database on AS400 servers directly from Datastage DB2 stage??
If not how do we do that??

[Klaus Schaefer]

For communicating with the AS400 DB2 from DSEE you need to utilize the DB2API-stage, not the DB2EE-stage.

That means you'll talk via DB2connect, which must be installed and configured on your UNIX-server where DSEE is running.

Get the DB2 profile and put it into dsenv. Stop/restart the DS services and it shall work.

Klaus

[dspxlearn]

Hi,


Thanks for your responce.
Do we need to update the odbc.ini file also.
And can you clarify me on 'putting the DB2 profile into dsenv' part?

[Klaus Schaefer]

Well, that's all nicely described in the installation guide ....

For your DB2 connect software you have a client profile, usually called "db2profile". You need a statement in your dsenv like

. /home/db2/sqllib/db2profile

to let DS source the DB2 environment.

You don't need to do anything with the .odbc.ini file as long as you don't use ODBC to connect to a database or other data source.

Hope this helps a bit...

Klaus