Question posted by: rajdb2
(Guest)
on
July 14th, 2008 01:45 PM
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.
Not the answer you were looking for? Post your question . . .
183,961 Experts ready to help you find a solution.
Sign up for a free account, or
Login (if you're already a member).