UDB configuration
Posted: Tue Jul 12, 2005 2:20 pm
Hi,
I installed Datastage7.1r1(Server Edition) on Solaris,successfully installed.
But i have UDB DB2 source on AIX machine.
I am not able to connect UDB(on AIX) from Datastage(Solaris).
I am using following .odbc.ini and uvodbc.config files.
bolded fields iam filling as per my available details.
Anything wrong in using these files?
odbc.ini.
-------------------
[DB2 Wire Protocol]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb219.so
Description=DataDirect 4.20 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
#Collection=OS/390 and AS/400 (Remove for DB2 UDB)#//commented
Database=SRCDB (Remove for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=hmunx121
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=xyz
Password=pqrs
Package=DB2 package name
PackageOwner=
TcpPort=20021
WithHold=1
uvodbc.config
------------------------
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE=UNIVERSE
network=TCP/IP
service=uvserver
host=127.0.0.1
<SRCDB>
DBMSTYPE=ODBC
-------------------------------
Thanks in advance,
VBeeram
I installed Datastage7.1r1(Server Edition) on Solaris,successfully installed.
But i have UDB DB2 source on AIX machine.
I am not able to connect UDB(on AIX) from Datastage(Solaris).
I am using following .odbc.ini and uvodbc.config files.
bolded fields iam filling as per my available details.
Anything wrong in using these files?
odbc.ini.
-------------------
[DB2 Wire Protocol]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMdb219.so
Description=DataDirect 4.20 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
#Collection=OS/390 and AS/400 (Remove for DB2 UDB)#//commented
Database=SRCDB (Remove for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=hmunx121
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=xyz
Password=pqrs
Package=DB2 package name
PackageOwner=
TcpPort=20021
WithHold=1
uvodbc.config
------------------------
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE=UNIVERSE
network=TCP/IP
service=uvserver
host=127.0.0.1
<SRCDB>
DBMSTYPE=ODBC
-------------------------------
Thanks in advance,
VBeeram