Hi All,

Env: AIX, DB2 v8.2 FP 7a

We are consistenly seeing this error in the application logs and don't know what is causing it.

2007-05-15 17:31:26,831 ->ERROR ->Database.PersistenceModule ->LS-SQL0032: [IBM][CLI Driver][DB2/AIX64] SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x124C". SQLSTATE=58009

on thread [Servlet.Engine.Transports : 2].

com.ibm.websphere.ce.cm.StaleConnectionException: [IBM][CLI Driver][DB2/AIX64] SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Reason Code "0x124C". SQLSTATE=58009


And during the same time (almost) this what is seen the db2diag.log

2007-05-15-16.56.41.654476-360 I3046509A677 LEVEL: Error
PID : 2011342 TID : 1 PROC : db2agent (XYZ) 0
INSTANCE: db2 NODE : 000 DB : XYZ
APPHDL : 0-236 APPID: GA011C0D.PD08.019805225637
FUNCTION: DB2 UDB, Common Trace API, sqljsParseInstVar, probe:410
MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected. The diagnostic
data returned is (SRVDGN): "FUNCTION ID = 0044 , PROBE POINT = 0410 ,
TRACE POINT = 0020 , SUBCODE1 = FFFFFFFF800A008D, SUBCODE2 =
0000000000000000, SUBCODE3 = 0000000000000000, ERROR MSG = Parser:
Invalid DDM length".

2007-05-15-16.56.41.663801-360 I3047187A166 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** DRDA ASCB ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.664959-360 I3047354A171 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.665162-360 I3047526A171 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.665523-360 I3047698A169 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** SEND BUFFERS ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.665706-360 I3047868A174 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** CONNECTION HANDLE ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.665876-360 I3048043A172 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

2007-05-15-16.56.41.666044-360 I3048216A171 LEVEL: Error
PID:2011342 TID:1 NODE:000 Title: **** AS UCINTERFACE ****
Dump File:/home/pssb/sqllib/db2dump/20113421.000

I am really not sure what is going on. Can anybody please help?

Thanks
Anks

Looking at the long message text for SQL30020, I found:
So whoever is handling the DRDA protocol at the client side seems to have a different understanding that the DB2 server.

Thanks,

So is there a way this can be fixed?

Anks

Since you haven't told us anything about your environment and whch component generates the DRDA packages, I don't see how we could give you any suggestion.

Hi,

I did mention about the env:

The OS is AIX Version 5.2
DB2 version 8.2 FixPak 7a

I am sorry I am not very faimilar with DRDA protocal. What do you mean by 'which component generated DRDA package' ?

Thanks,

Anks

Do you use the regular DB2 client or some other tool to talk to DB2? If it is the DB2 client, is it also at FP7a level?
Have you tried applying the latest FP? (FP14 is current.)

Yes, we use Db2 client and thats also running on Fixpak 7a. I think an upgrade is not an option right now. Is there anything else that can be done.

Thanks
ANks