UDB configuration

[vbeeram]

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

[ray.wurlod]

The only obvious this is that hmunx121 is not an IP address, and you don't have an explicit entry for [SRCDB] (or whatever else you want to call your DSN).

[roy]

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

-------------------------------

Besides what Ray said:

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,

[Mat01]

Hi Vbeeram,

You should have a file named .dshome at the root of your machine. This file contains one line only which is the path to your DSEngine directory.

ie:
as0006s@sodium01(/) $ cat .dshome
/usr/local/datastage/Ascential/DataStage/DSEngine

HTH

Mat