Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2005
    Posts
    102

    Unanswered: SQL30020N error in the application logs

    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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Looking at the long message text for SQL30020, I found:
    Reason code 124C indicates that the DRDA data stream for the
    request contains a syntax error.
    So whoever is handling the DRDA protocol at the client side seems to have a different understanding that the DB2 server.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2005
    Posts
    102
    Thanks,

    So is there a way this can be fixed?

    Anks

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jul 2005
    Posts
    102
    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

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jul 2005
    Posts
    102
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •