|
Problem IC62726
|
Status: Closed |
GATEWAY TRAPS IN SQLJSSYNCREQCOMMIT When CONNECTION CONCENTRATOR is ON |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Gateway is trapping with the following stack when Connection
Concentrator is ON:
0000020001030F02 _Z18sqljsSyncReqCommitP14db2UCinterface +
0x00ca
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
000002000103651A
_Z17sqljs_ddm_syncctlP14db2UCinterfaceP13sqljDDMObject
+ 0x01c2
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
00000200010134A8
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterfa
ce + 0x03a8
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
0000020001012706 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface
+
0x0246
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
000002000100C1D2 address: 0x000002000100C1D2 ; dladdress:
0x000002000000C000 ; offset in lib: 0x00000000010001D2 ;
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
0000020001010678 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x02e4
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
0000020000DB1CD2 _ZN8sqeAgent6RunEDUEv + 0x014e
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
0000020002CE5DFC _ZN9sqzEDUObj9EDUDriverEv + 0x0198
(/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
0000020002CE5E16 _Z10sqlzRunEDUPcj + 0x0016
Reproduction steps:
enable concentrator, set num_poolagents 0 in dbm cfg file. Run
any db2 coordinated application through gateway.
In customer environment num_poolagents can be set to some value.
Example of settings where customer experienced the issue:
Agent pool size (NUM_POOLAGENTS) = 75
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = 300
Max number of client connections (MAX_CONNECTIONS) = 301 |
| Problem Summary: |
User's affected: All
Problem summary: Gateway traps in sqljsSyncReqCommit when
Connection Concentrator is ON |
| Local Fix: |
Disable connection concentrator. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.08.2009
21.12.2009
21.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
