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??
DB2 Interaction
Moderators: chulett, rschirm, roy
DB2 Interaction
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
Re: DB2 Interaction
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
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
-
- Participant
- Posts: 94
- Joined: Wed May 08, 2002 8:44 am
- Location: Germany
- Contact:
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
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