Fixes are available
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
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