Mega Search
23.2 Million

Sign Up

  Page [1]



Make a donation  
TCPIP problem  
News Group: comp.databases.ibm-db2 

A batch job run from an informatica server is failing with the
following error when trying to connect to the prod database, but it
connects the second time when a retry is issued without any problems.

[IBM][CLI Driver] SQL30082N  Attempt to establish connection failed
with security reason "24" ("USERNAME AND/OR PASSWORD INVALID").
SQLSTATE=08001

I am seeing the following error message in the diaglog when the above
error occurs.

2008-07-08-02.08.05.342102-240 I9156A381          LEVEL: Error
PID     : 139264               TID  : 1           PROC : db2tcpcm 0
INSTANCE:              NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:
105
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/
IP
          function "accept". Socket was "4". Errno was "72".

DB2 support is not able to help in anyway and they think its an AIX
issue, but AIX and network groups dont see any issue. I would
appreciate any help in this matter.
Vote for best question.
Score: 0  # Vote:  0
Date Posted: 14-Jul-2008, at 6:39 AM EST
From: rajdb2
 
Re: TCPIP problem  
News Group: comp.databases.ibm-db2 
Has anyone seen this problem before. I would appreciate any help in
this matter.

On Jul 14, 9:39 am, rajdb2  wrote:
> A batch job run from an informatica server is failing with the
> following error when trying to connect to the prod database, but it
> connects the second time when a retry is issued without any problems.
>
> [IBM][CLI Driver] SQL30082N  Attempt to establish connection failed
> with security reason "24" ("USERNAME AND/OR PASSWORD INVALID").
> SQLSTATE=08001
>
> I am seeing the following error message in the diaglog when the above
> error occurs.
>
> 2008-07-08-02.08.05.342102-240 I9156A381          LEVEL: Error
> PID     : 139264               TID  : 1           PROC : db2tcpcm 0
> INSTANCE:              NODE : 000
> FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:
> 105
> MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/
> IP
>           function "accept". Socket was "4". Errno was "72".
>
> DB2 support is not able to help in anyway and they think its an AIX
> issue, but AIX and network groups dont see any issue. I would
> appreciate any help in this matter.
Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 17-Jul-2008, at 7:03 AM EST
From: rajdb2