home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC62726 Status: Geschlossen

GATEWAY TRAPS IN SQLJSSYNCREQCOMMIT When CONNECTION CONCENTRATOR is ON

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
User's affected: All 
Problem summary: Gateway traps in sqljsSyncReqCommit when 
Connection Concentrator is ON
Local-Fix:
Disable connection concentrator.
verfügbare FixPacks:
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

Lösung
Problem was first fixed in Version 9.7 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.08.2009
21.12.2009
21.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList