|
Problem IT07808
|
Status: Closed |
Client may report connection loss if down level DB2Connect server is in the connection path. |
| product: |
DB2 CONNECT / DB2CONNCT / A50 - DB2 |
| Problem description: |
The issue is only applicable if DB2 connect server (aka gateway)
10.1.0, 9.7.5 or earlier is used in connection path.
DB2 connect server generates binary dump file with the following
db2diag.log stack(s) and disconnects the client connection.
FUNCTION: DB2 UDB, DRDA Application Requester,
sqljrPostErrorProcessing, probe:911
MESSAGE : ZRC=0x87360014=-2026504172=SQLJC_ERROR_SYSI "INTERNAL
ERROR"
DIA8515C A system error has occurred.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F3BAE573E80 pdLog + 0x398
[1] 0x00007F3BAF5A1703
_Z24sqljrPostErrorProcessingP13sqljrDrdaArCbP14db2UCinterfacei +
0x7F1
[2] 0x00007F3BAF58BAD3 _Z17sqljrDrdaArCommitP14db2UCinterface
+ 0x199
[3] 0x00007F3BAE78EB75
_Z16sqljs_ddm_rdbcmmP14db2UCinterfaceP13sqljDDMObject + 0x1A5
[4] 0x00007F3BB0DB27A6
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0xD6
[5] 0x00007F3BAE77A323
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x35B
[6] 0x00007F3BAE76F038
/u/udb/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xF4F038
[7] 0x00007F3BAE776403
/u/udb/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xF56403
[8] 0x00007F3BAE773D0A
/u/udb/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xF53D0A
[9] 0x00007F3BAE773A78
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x102
and/or
FUNCTION: DB2 UDB, DRDA Application Requester,
sqljrPostErrorProcessing, probe:911
MESSAGE : ZRC=0x87360014=-2026504172=SQLJC_ERROR_SYSI "INTERNAL
ERROR"
DIA8515C A system error has occurred.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F3BAE573E80 pdLog + 0x398
[1] 0x00007F3BAF5A1703
_Z24sqljrPostErrorProcessingP13sqljrDrdaArCbP14db2UCinterfacei +
0x7F1
[2] 0x00007F3BAF58B7FB
_Z19sqljrDrdaArRollbackP14db2UCinterface + 0x199
[3] 0x00007F3BAE776987
_Z31sqljsRollbackBeforeConnectResetP14db2UCconHandle + 0x8F
[4] 0x00007F3BAE776591
/u/udb/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xF56591
[5] 0x00007F3BAE773D68
/u/udb/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xF53D68
[6] 0x00007F3BAE773A78
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x102
[7] 0x00007F3BAE6A7B72 _ZN8sqeAgent6RunEDUEv + 0xA72
[8] 0x00007F3BAED83C9C _ZN9sqzEDUObj9EDUDriverEv + 0xA6
[9] 0x00007F3BAED83BF3 _Z10sqlzRunEDUPcj + 0x9 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users connecting to 9.7 FP5 or earlier. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.5 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
One can use one of the following local fix to avoid the issue:
a. upgrading gateway to v97fp6, v10.1 or above.
b. go directly to zDB2 server
C. explicitly disable CommitOnEOF using configuration file
db2dsdriver.cfg |
| Solution |
See Problem Description above |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.03.2015
19.01.2016
19.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
