Hi,
We have following scenario in our DWH project.
Source - JDEdwards. Underlying database is DB2 in AS/400 environment
Target - Oracle 9i on UNix
ETL - Datastage 7 (Server Job) on Unix
I got to know that DB2 in AS/400 does not have DB2 client. So i cannot use DB2 stage to extract the data from DB2 database. I have decided to use ODBC / DRDBMS stage. I need to create DSN entry to use these stages. Following are two files that i have included the parameters in two files.
- .odbc.ini file under <Datastage Home Dir>/dsengine
- ucodbc.config file under <Datastage Home Dir>/dsengine
Follwoing are parameters included in .odbc.ini file.
[DB2_ODBC_DSN] This is ODBC DSN name Driver=/opt/DsSoftware/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400
Database= <<I Have not added because it is DB2 Db on AS/400>>
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xxx.xxx
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400
LogonID=Useridxxx
Password=Pwdxxx
Package=DB2 package name
PackageOwner=
TcpPort=xxxx
WithHold=1
Following are the entries added in uvodbc.config file
<DB2_ODBC_DSN>
DBMSTYPE = ODBC
I have tried importing the table definition of one table of DB2 database. I can see the message like ''Retrieving... '' and it was hanging.
Do anyone has done the DSN setup for DB2 on AS/400 database. Could you please help me to resolve the issue.
Thank you
Saravanan R
Problem in connecting datastage to DB2 in AS400 environment
Moderators: chulett, rschirm, roy
Re: Problem in connecting datastage to DB2 in AS400 environm
I have not given the database name in database parameter in .odbc.ini file. Because i read in the document that DB name is not required for OS/390 and AS/400 environment.
Saravanan wrote:Hi,
We have following scenario in our DWH project.
Source - JDEdwards. Underlying database is DB2 in AS/400 environment
Target - Oracle 9i on UNix
ETL - Datastage 7 (Server Job) on Unix
I got to know that DB2 in AS/400 does not have DB2 client. So i cannot use DB2 stage to extract the data from DB2 database. I have decided to use ODBC / DRDBMS stage. I need to create DSN entry to use these stages. Following are two files that i have included the parameters in two files.
- .odbc.ini file under <Datastage Home Dir>/dsengine
- ucodbc.config file under <Datastage Home Dir>/dsengine
Follwoing are parameters included in .odbc.ini file.
[DB2_ODBC_DSN] This is ODBC DSN name Driver=/opt/DsSoftware/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400
Database= <<I Have not added because it is DB2 Db on AS/400>>
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=xxx.xxx.xxx.xxx
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400
LogonID=Useridxxx
Password=Pwdxxx
Package=DB2 package name
PackageOwner=
TcpPort=xxxx
WithHold=1
Following are the entries added in uvodbc.config file
<DB2_ODBC_DSN>
DBMSTYPE = ODBC
I have tried importing the table definition of one table of DB2 database. I can see the message like ''Retrieving... '' and it was hanging.
Do anyone has done the DSN setup for DB2 on AS/400 database. Could you please help me to resolve the issue.
Thank you
Saravanan R