Connecting to AS400 system

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
SrSoma
Participant
Posts: 3
Joined: Fri Jun 25, 2010 4:19 am

Connecting to AS400 system

Post by SrSoma »

Hi,
here we are facing issue in establishing the connection to AS400 system.
The steps we followed are :
1) Changed odbc.ini file and uvconfig.org file. below are the contents.

<<.odbc.ini file>>
[WELCOMETST]
Driver=/usr/iis/ascential/datastage/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
CharsetFor65535=0273
Collection=shareteam
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IANAAppCodePage=106
IpAddress=40.100.400.500
IsolationLevel=CURSOR_STABILITY
Location=TTXXCCA123
LogonID=WELCOMEDS
Password=*******
Option=512
Package=NULLID
PackageOwner=
ServerCharset=37
TcpPort=446
WithHold=1

<<uvodbc.config file>>
<WELCOMETST>
DBMSTYPE = ODBC

After using this it's gave us error

However we are still facing the error as below:

SQLSTATE=08S01,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Connection refused. Verify Host Name and Port Number.

We were suggested to execute <<bind>> command.

Here could someone help us in detailing the steps required for establishing the connectivity, and what is that we are missing.

Appreciate your prompt response.

Thanks.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

One example of how to bind is here.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply