DB2/AS400 ODBC Connection Problem

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
svishaal
Participant
Posts: 3
Joined: Tue Jul 12, 2005 3:06 am

DB2/AS400 ODBC Connection Problem

Post by svishaal »

Hello Everyone,

I am getting below error when I tried to access DB2/AS400 tables, I setup connection details in .ODBC.INI file and uvodbc.config files, however still no luck.

I tried changing the port no also as datastage takes 446 as default port for AS400, when I use 446 as port no I got the below error.

LoadIMSMIPORT1PFromAS400..MIPORT1P: DSD.BCIConnect connecting to ARION-IMSHK, call to SQLConnect failed.
SQLSTATE=S0011, DBMS.CODE=-601
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][DB2]NAME OF OBJECT TO BE CREATED IDENTICAL TO EXISTING NAME NULLID.DDOS500A OF THE OBJECT TYPE PACKAGE

Then when I access AS400 using iseries it shows 23 as port no and I am able to connect to that libarary in iseries so I tried changing port no to 23 in datastage but still no luck, I got the below error message when I use 23 as port no.

LoadIMSMIPORT1PFromAS400..MIPORT1P: DSD.BCIConnect connecting to J3SYSTEM, call to SQLConnect failed.
SQLSTATE=08S01, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Unexpected Network Error. ErrNum = 11

Can anyone help me about this ?

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”