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

DB2AGENT TRAP SIG#11 IN SQLOCRASHONCRITICALMEMORYVALIDATIONFAILU RE WITH
SQLR_GET_STATS_COMMAND IN THE CALLSTACK

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
During statistics collection, the db2agent might trap with 
sig#11 in sqloCrashOnCriticalMemoryValidationFailure with 
sqlr_get_stats_command in the callstack.  The statistics 
collection might be a collection that was initiated by the user 
via a RUNSTATS command, or might be a collection that was 
initiated by automatic statistics collection if this feature is 
enabled for the database.  For the problem to occur, the 
application heap usage must have been constrained. 
 
A sample callstack that might be observed is: 
 
ossDumpStackTrace 
OSSTrapFile6dumpExEmi 
OSSTrapFile4dumpEmi 
sqlo_trce 
sqloEDUCodeTrapHandler 
sqloCrashOnCriticalMemoryValidationFailure 
sqlofmblkEx 
sqlofmblkPv 
sqlr_get_stats_command 
sqlrrsta 
sqlrr_runstats_DA 
 
Prior to the trap, the db2diag log might have application heap 
messages, for example: 
 
2010-10-07-01.34.33.373569-240 I68291A582         LEVEL: Error 
PID     : 757924               TID  : 3600        PROC : db2sysc 
0 
INSTANCE: svtdbm5              NODE : 000         DB   : SVTLNX2 
APPHDL  : 0-65                 APPID: *N0.svtdbm5.101007052723 
AUTHID  : SVTDBM5 
EDUID   : 3600                 EDUNAME: db2agent (SVTLNX2) 0 
FUNCTION: DB2 UDB, relation data serv, sqlr_get_stats_command, 
probe:200 
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH 
          "No memory available in 'Application Heap'" 
          DIA8301C No memory available in the application heap.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* During statistics collection, the db2agent might trap with   * 
* sig#11 in sqloCrashOnCriticalMemoryValidationFailure with    * 
* sqlr_get_stats_command in the callstack.  The statistics     * 
* collection might be a collection that was initiated by the   * 
* user via a RUNSTATS command, or might be a collection that   * 
* was initiated by automatic statistics collection if this     * 
* feature is enabled for the database.  For the problem to     * 
* occur, the application heap usage must have been             * 
* constrained.                                                 * 
*                                                              * 
* A sample callstack that might be observed is:                * 
*                                                              * 
* ossDumpStackTrace                                            * 
* OSSTrapFile6dumpExEmi                                        * 
* OSSTrapFile4dumpEmi                                          * 
* sqlo_trce                                                    * 
* sqloEDUCodeTrapHandler                                       * 
* sqloCrashOnCriticalMemoryValidationFailure                   * 
* sqlofmblkEx                                                  * 
* sqlofmblkPv                                                  * 
* sqlr_get_stats_command                                       * 
* sqlrrsta                                                     * 
* sqlrr_runstats_DA                                            * 
*                                                              * 
* Prior to the trap, the db2diag log might have application    * 
* heap messages, for example:                                  * 
*                                                              * 
* 2010-10-07-01.34.33.373569-240 I68291A582        LEVEL:      * 
* Error                                                        * 
* PID    : 757924              TID  : 3600        PROC :       * 
* db2sysc 0                                                    * 
* INSTANCE: svtdbm5              NODE : 000        DB  :       * 
* SVTLNX2                                                      * 
* APPHDL  : 0-65                APPID:                         * 
* *N0.svtdbm5.101007052723                                     * 
* AUTHID  : SVTDBM5                                            * 
* EDUID  : 3600                EDUNAME: db2agent (SVTLNX2) 0   * 
* FUNCTION: DB2 UDB, relation data serv,                       * 
* sqlr_get_stats_command, probe:200                            * 
* RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH         * 
*           "No memory available in 'Application Heap'"        * 
*           DIA8301C No memory available in the application    * 
* heap.                                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.5 fix pack 7.                       * 
****************************************************************
Local-Fix:
Increasing application heap might reduce the likelihood of 
experiencing this problem.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This problem was first fixed in DB2 version 9.5 fix pack 7.
Workaround
see LOCAL FIX
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.10.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList