IBM Support

IC64525: SQLCODE -30020 OR DRDA DATA STREAM SYNTAX ERROR REPORTED BY DB2 CONNECT SERVER after a TCP/IP error is reported.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • After reporting  TCP/IP communication failure on gateway for one
    connection, other application or connection can report sqlcode
    -30020 or DRDA SYNTAX ERROR.
    
    2009-11-06-22.03.32.435641-300 I10253A472         LEVEL: Error
    PID     : 1937502              TID  : 23646       PROC : db2sysc
    INSTANCE: svtdbm2              NODE : 000         DB   : CSTDB2
    
    APPHDL  : 0-465                APPID:
    9.26.76.196.2280.091107025116
    AUTHID  :
    EDUID   : 23646                EDUNAME: db2agent (EHQ3)
    FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,
    probe:110
    MESSAGE : DIA3202C The TCP/IP call "connect" returned an
    errno="78".
    
    2009-11-06-23.14.51.839574-300 I10726A472         LEVEL: Error
    PID     : 1937502              TID  : 4885        PROC : db2sysc
    INSTANCE: svtdbm2              NODE : 000         DB   : CSTDB2
    
    APPHDL  : 0-464                APPID:
    9.26.76.196.2279.091107025113
    AUTHID  :
    EDUID   : 4885                 EDUNAME: db2agent (EHQ3)
    FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,
    probe:110
    MESSAGE : DIA3202C The TCP/IP call "connect" returned an
    errno="78".
    
    2009-11-06-23.14.52.139406-300 E11199A519         LEVEL: Error
    PID     : 1937502              TID  : 4885        PROC : db2sysc
    INSTANCE: svtdbm2              NODE : 000         DB   : CSTDB2
    
    APPHDL  : 0-464                APPID:
    9.26.76.196.2279.091107025113
    AUTHID  :
    EDUID   : 4885                 EDUNAME: db2agent (EHQ3)
    FUNCTION: DB2 UDB, DRDA Application Requester,
    sqljrHandleErrorRm, probe:911
    MESSAGE : ADM2503C  A datastream parsing error has been
    detected.  A dump has
              been generated.
    
    2009-11-06-23.14.52.174285-300 E11719A524         LEVEL: Error
    PID     : 1937502              TID  : 5142        PROC : db2sysc
    INSTANCE: svtdbm2              NODE : 000         DB   : CSTDB2
    
    APPHDL  : 0-448                APPID:
    9.26.76.196.2263.091107024806
    AUTHID  :
    EDUID   : 5142                 EDUNAME: db2agentg (CSTDB2  )
    FUNCTION: DB2 UDB, DRDA Application Requester,
    sqljrHandleErrorRm, probe:911
    MESSAGE : ADM2503C  A datastream parsing error has been
    detected.  A dump has
              been generated.
    
    2009-11-06-23.14.52.374871-300 I12244A917         LEVEL: Error
    PID     : 1937502              TID  : 4885        PROC : db2sysc
    INSTANCE: svtdbm2              NODE : 000         DB   : CSTDB2
    
    APPHDL  : 0-464                APPID:
    9.26.76.196.2279.091107025113
    AUTHID  :
    EDUID   : 4885                 EDUNAME: db2agent (EHQ3)
    FUNCTION: DB2 UDB, DRDA Application Requester,
    sqljrHandleErrorRm, probe:911
    MESSAGE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX ERROR"
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -30020   sqlerrml:
    17
     sqlerrmc: 0x124C"("011D")"
     sqlerrp : sqljrerm
     sqlerrd : (1) 0x8037008D      (2) 0x0000008D      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Connect                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After reporting  TCP/IP communication failure on gateway for *
    * one                                                          *
    * connection, other application or connection can report       *
    * sqlcode                                                      *
    * -30020 or DRDA SYNTAX ERROR.                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-11-06-22.03.32.435641-300 I10253A472         LEVEL:     *
    * Error                                                        *
    * PID     : 1937502              TID  : 23646       PROC :     *
    * db2sysc                                                      *
    * INSTANCE: svtdbm2              NODE : 000         DB   :     *
    * CSTDB2                                                       *
    *                                                              *
    *                                                              *
    * APPHDL  : 0-465                APPID:                        *
    *                                                              *
    * 9.26.76.196.2280.091107025116                                *
    *                                                              *
    * AUTHID  :                                                    *
    *                                                              *
    * EDUID   : 23646                EDUNAME: db2agent (EHQ3)      *
    *                                                              *
    * FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,      *
    *                                                              *
    * probe:110                                                    *
    *                                                              *
    * MESSAGE : DIA3202C The TCP/IP call "connect" returned an     *
    *                                                              *
    * errno="78".                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-11-06-23.14.51.839574-300 I10726A472         LEVEL:     *
    * Error                                                        *
    * PID     : 1937502              TID  : 4885        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: svtdbm2              NODE : 000         DB   :     *
    * CSTDB2                                                       *
    *                                                              *
    *                                                              *
    * APPHDL  : 0-464                APPID:                        *
    *                                                              *
    * 9.26.76.196.2279.091107025113                                *
    *                                                              *
    * AUTHID  :                                                    *
    *                                                              *
    * EDUID   : 4885                 EDUNAME: db2agent (EHQ3)      *
    *                                                              *
    * FUNCTION: DB2 UDB, common communication, sqlcctcpconnr,      *
    *                                                              *
    * probe:110                                                    *
    *                                                              *
    * MESSAGE : DIA3202C The TCP/IP call "connect" returned an     *
    *                                                              *
    * errno="78".                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-11-06-23.14.52.139406-300 E11199A519         LEVEL:     *
    * Error                                                        *
    * PID     : 1937502              TID  : 4885        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: svtdbm2              NODE : 000         DB   :     *
    * CSTDB2                                                       *
    *                                                              *
    *                                                              *
    * APPHDL  : 0-464                APPID:                        *
    *                                                              *
    * 9.26.76.196.2279.091107025113                                *
    *                                                              *
    * AUTHID  :                                                    *
    *                                                              *
    * EDUID   : 4885                 EDUNAME: db2agent (EHQ3)      *
    *                                                              *
    * FUNCTION: DB2 UDB, DRDA Application Requester,               *
    *                                                              *
    * sqljrHandleErrorRm, probe:911                                *
    *                                                              *
    * MESSAGE : ADM2503C  A datastream parsing error has been      *
    *                                                              *
    * detected.  A dump has                                        *
    *                                                              *
    *           been generated.                                    *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-11-06-23.14.52.174285-300 E11719A524         LEVEL:     *
    * Error                                                        *
    * PID     : 1937502              TID  : 5142        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: svtdbm2              NODE : 000         DB   :     *
    * CSTDB2                                                       *
    *                                                              *
    *                                                              *
    * APPHDL  : 0-448                APPID:                        *
    *                                                              *
    * 9.26.76.196.2263.091107024806                                *
    *                                                              *
    * AUTHID  :                                                    *
    *                                                              *
    * EDUID   : 5142                 EDUNAME: db2agentg (CSTDB2  ) *
    *                                                              *
    * FUNCTION: DB2 UDB, DRDA Application Requester,               *
    *                                                              *
    * sqljrHandleErrorRm, probe:911                                *
    *                                                              *
    * MESSAGE : ADM2503C  A datastream parsing error has been      *
    *                                                              *
    * detected.  A dump has                                        *
    *                                                              *
    *           been generated.                                    *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2009-11-06-23.14.52.374871-300 I12244A917         LEVEL:     *
    * Error                                                        *
    * PID     : 1937502              TID  : 4885        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: svtdbm2              NODE : 000         DB   :     *
    * CSTDB2                                                       *
    *                                                              *
    *                                                              *
    * APPHDL  : 0-464                APPID:                        *
    *                                                              *
    * 9.26.76.196.2279.091107025113                                *
    *                                                              *
    * AUTHID  :                                                    *
    *                                                              *
    * EDUID   : 4885                 EDUNAME: db2agent (EHQ3)      *
    *                                                              *
    * FUNCTION: DB2 UDB, DRDA Application Requester,               *
    *                                                              *
    * sqljrHandleErrorRm, probe:911                                *
    *                                                              *
    * MESSAGE : ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX    *
    * ERROR"                                                       *
    * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes                *
    *                                                              *
    *  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -30020          *
    * sqlerrml:                                                    *
    * 17                                                           *
    *                                                              *
    *  sqlerrmc: 0x124C"("011D")"                                  *
    *                                                              *
    *  sqlerrp : sqljrerm                                          *
    *                                                              *
    *  sqlerrd : (1) 0x8037008D      (2) 0x0000008D      (3)       *
    *                                                              *
    * 0x00000000                                                   *
    *                                                              *
    *            (4) 0x00000000      (5) 0x00000000      (6)       *
    *                                                              *
    * 0x00000000                                                   *
    *                                                              *
    *  sqlwarn : (1)      (2)      (3)      (4)        (5)         *
    * (6)                                                          *
    *                                                              *
    *                                                              *
    *            (7)      (8)      (9)      (10)        (11)       *
    *                                                              *
    *  sqlstate:                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the fixpack with APAR                             *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC64525

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-12

  • Closed date

    2010-02-24

  • Last modified date

    2010-02-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 February 2010