DB2 Loader issue with Informatica 9.6

Sachin Sahu

DB2 Loader issue with Informatica 9.6

We are getting below error when we try to run DB2 Loader connection in Informatica 9.6 version. The same Loader connection works fine in Informatica 9.1 version. Both versions of Informatica are installed on same server. Any idea what could be causing this ??

Error is below

2017-08-02-17.21.42.593127-240 I35143109A324      LEVEL: Error
PID     : 4561                 TID  : 1           PROC : DB2ExtLdrV001
INSTANCE: db2caev9             NODE : 000
EDUID   : 1
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:110
MESSAGE : DIA3202C The TCP/IP call "connect" returned an errno="238".

Jim Tonchick

DB2 Loader issue with Informatica 9.6
(in response to Sachin Sahu)

Check your Informatica IP addresses and port assignments. If they are running on the same server, that can't use the same port numbers. Then make sure that the DB2 Loader is pointing to the correct IP address and port.

-----Original Message-----
From: Sachin Sahu <[login to unmask email]>
To: DB2-L <[login to unmask email]>
Sent: Wed, Aug 2, 2017 04:47 PM
Subject: [DB2-L] - DB2 Loader issue with Informatica 9.6



<div id="AOLMsgPart_2_c0e141f5-e0d0-44b6-a6ce-524746534ffb">
<div class="aolReplacedBody"><p>We are getting below error when we try to run DB2 Loader connection in Informatica 9.6 version. The same Loader connection works fine in Informatica 9.1 version. Both versions of Informatica are installed on same server. Any idea what could be causing this ??</p>
<p>Error is below</p>
<p>2017-08-02-17.21.42.593127-240 I35143109A324 LEVEL: Error
PID : 4561 TID : 1 PROC : DB2ExtLdrV001
INSTANCE: db2caev9 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, common communication, sqlcctcpconnr, probe:110
MESSAGE : DIA3202C The TCP/IP call "connect" returned an errno="238".</p>
<hr size="1" style="color:#ccc"><div id="aolmail_socfooter" style="font-size:80%"><span style="font-weight:bold">Site Links: </span>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/st/?post=182424&anc=p182424#p182424">View post online</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/si/?topic=19">View mailing list online</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]">Start new thread via email</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]?Subject=Unsubscribe">Unsubscribe from this mailing list</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/us/to/">Manage your subscription</a>


This email has been sent to: <a href="mailto:[login to unmask email]">[login to unmask email]</a>
<p>
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

<a target="_blank" rel="noopener noreferrer" href="http://www.ESAIGroup.com/idug">http://www.ESAIGroup.com/idug</a>

</p>
<p>
Use of this email content is governed by the terms of service at:
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/cm/ld/fid=2">http://www.idug.org/p/cm/ld/fid=2</a></p>

</div><hr size="1" style="color:#ccc"></div>
</div>