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
UDB configuration
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: UDB configuration
Besides what Ray said:vbeeram wrote: 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
-------------------------------
The DSN name you need to specify in your uvodbc.config file is the same name mentioned in the brackets in your .odbc.ini, in the case mentioned it should be: DB2 Wire Protocol
I would rename it to something more meaningfull like MySrcDsn.
Next you failed to drop the entries for AS400 and 390 DB2
and in the entries for UDB remove the (Remove for OS/390 and AS/400) part.
P.S.
Is there any reason why you don't use the UDB plugin stage?
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org