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 IC67425 Status: Geschlossen

DB2 ABENDS USING SCALAR AGGREGATION FUNCTION WITH CONNECTION
CONCENTRATOR ENABLED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
PROBLEM DESCRIPTION: 
==================== 
When using Scalar Aggregation functions with Connection 
Concentrator enabled, memory allocated for the scalar 
aggregation execution may become invalid when the connection is 
serviced by different agents, causing DB2 to trap/abend.  An 
additional requirement is that "with hold cursors" are being 
used, but this is common. 
 
Connection Concentrator is enabled when the database manager 
configuration parameter MAX_CONNECTIONS exceeds MAX_COORDAGENTS. 
This criteria applies when these parameters are set to 
AUTOMATIC, in which case the criteria applies to the underlying 
values. 
For example, this configuration shows Connection Concentrator 
enabled: 
 Max number of coordinating agents     (MAX_COORDAGENTS) = 
AUTOMATIC(200) 
 Max number of client connections      (MAX_CONNECTIONS) = 
AUTOMATIC(1000) 
 
Example diagnostic trap files will include the keyword/function 
sqlriScalagClose: 
 
Example 1: 
<StackTrace> 
... 
sqloEDUCodeTrapHandler + 0x0107 
address: 0x00002AAAAABD4C00 
sqldmcloP8sqeAgentPP8SQLD_CCBi + 0x002a 
sqlriScalagCloseDropTempP8sqlrr_cbP16sqlri_buffer_mgr + 0x007f 
sqlri_buffer_closeP8sqlrr_cbP15sqlri_scalagobj + 0x021d 
sqlriScalagCloseP8sqlrr_cbP15sqlri_scalagobj + 0x003c 
 
Example 2: 
<StackTrace> 
... 
sqloCrashOnCriticalMemoryValidationFailure + 0x1C 
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCc + 0x260 
sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x748 
sqloDiagnoseFreeBlockFailure__FP8SMemFBlk@glue69E + 0x74 
sqlofmblkEx + 0x48 
sqlri_buffer_close__FP8sqlrr_cbP15sqlri_scalagobj + 0xB0 
sqlriScalagClose__FP8sqlrr_cbP15sqlri_scalagobj + 0x2C 
sqlriScalagClose__FP8sqlrr_cbP15sqlri_scalagobj@glue10D1 + 0x70 
sqlricjpInfrequent__FP8sqlrr_cbPP12sqlri_opparml + 0x4 
sqlricjp__FP8sqlrr_cbP12sqlri_opparmilT4 - 0x170 
sqlricls_simple__FP8sqlrr_cbil + 0xCC
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Systems with Connection Concentrator enabled                 * 
* (MAX_CONNECTIONS > MAX_COORDAGENTS)                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Fix Pack 3a or disable Connection Concentrator    * 
****************************************************************
Local-Fix:
Disable Connection Concentrator: 
db2 update dbm cfg using MAX_CONNECTIONS -1 automatic 
db2stop;db2start 
 
This results in the following standard configuration: 
 Max number of coordinating agents     (MAX_COORDAGENTS) = 
AUTOMATIC(200) 
 Max number of client connections      (MAX_CONNECTIONS) = 
AUTOMATIC(MAX_COORDAGENTS)
verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 first fixed in DB2 Version 9.7 Fix Pack 3a build s101006
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.03.2010
02.11.2010
02.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList