DB2 - Problem description
Problem IC65415 | Status: Closed |
VARIOUS ERROR MESSAGES IN DB2DIAG.LOG WHEN DTC GETS A TIMEOUT WHILE STREAMING IS IN PROGRESS | |
product: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problem description: | |
The following error messages might occur in db2diag.log together with some *.dump.bin files: 2009-08-06-00.49.32.788000+120 I6475H437 LEVEL: Severe PID : 4756 TID : 1752 PROC : dllhost.exe INSTANCE: DB2 NODE : 000 APPID : GA020622.N811.090805224823 EDUID : 1752 FUNCTION: DB2 UDB, DRDA Application Requester, sqljrPostErrorProcessing, probe:911 MESSAGE : ZRC=0x87360014=-2026504172=SQLJC_ERROR_SYSI "INTERNAL ERROR" DIA8515C A system error has occurred. 2009-08-06-00.49.32.850000+120 I6914H183 LEVEL: Severe PID:4756 TID:1752 NODE:000 Title: **** DRDA ARCB **** Dump File:C:\PROGRA~1\IBM\IBMDAT~1\db2\4756.1752.000.dump.bin ... 2009-08-06-00.49.40.194000+120 I11111H828 LEVEL: Error PID : 3796 TID : 4004 PROC : dllhost.exe INSTANCE: DB2 NODE : 000 APPID : GA020622.O911.090805224833 EDUID : 4004 FUNCTION: DB2 UDB, DRDA Application Requester, sqljrReportServerErrReply, probe:20 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"("0203")" 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: 2009-08-06-00.49.40.209000+120 I11941H182 LEVEL: Error PID:3796 TID:4004 NODE:000 Title: **** DRDA ARCB **** Dump File:C:\PROGRA~1\IBM\IBMDAT~1\db2\3796.4004.000.dump.bin ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Windows .NET, MSDTC * **************************************************************** * PROBLEM DESCRIPTION: * * Various error messages might occur in db2diag.log when DTC * * gets a timeout while streaming is in progress: * * * * 2009-08-06-00.49.32.788000+120 I6475H437 LEVEL: * * Severe * * PID : 4756 TID : 1752 PROC : * * dllhost.exe * * INSTANCE: DB2 NODE : 000 * * APPID : GA020622.N811.090805224823 * * EDUID : 1752 * * FUNCTION: DB2 UDB, DRDA Application Requester, * * sqljrPostErrorProcessing, probe:911 * * MESSAGE : ZRC=0x87360014=-2026504172=SQLJC_ERROR_SYSI * * "INTERNAL ERROR" * * DIA8515C A system error has occurred. * * * * 2009-08-06-00.49.32.850000+120 I6914H183 LEVEL: * * Severe * * PID:4756 TID:1752 NODE:000 Title: **** DRDA ARCB **** * * Dump * * File:C:\PROGRA~1\IBM\IBMDAT~1\db2\4756.1752.000.dump.bin * * ... * * * * 2009-08-06-00.49.40.194000+120 I11111H828 LEVEL: * * Error * * PID : 3796 TID : 4004 PROC : * * dllhost.exe * * INSTANCE: DB2 NODE : 000 * * APPID : GA020622.O911.090805224833 * * EDUID : 4004 * * FUNCTION: DB2 UDB, DRDA Application Requester, * * sqljrReportServerErrReply, probe:20 * * 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"("0203")" * * 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: * * * * 2009-08-06-00.49.40.209000+120 I11941H182 LEVEL: * * Error * * PID:3796 TID:4004 NODE:000 Title: **** DRDA ARCB **** * * Dump * * File:C:\PROGRA~1\IBM\IBMDAT~1\db2\3796.4004.000.dump.bin * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Data Server Provider for .Net 9.7 Fix Pack 2. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.7 Fix Pack 2. This fix should be applied on the client. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC66572 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.01.2010 19.07.2010 19.07.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |