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

POSSIBLE MEMORY CORRUPTION - TRAP IN <SQLRAERTDESTROYTABLE>
<SQLRAERT.C:259>

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If we run out of memory while constructing a cursor variable, 
the following connection reset might fail with -1224 which 
brings down the instance. 
 
<Header> 
DB2 build information: DB2 v9.7.100.119 s090917 SQL09071 
timestamp: 2009-09-21-07.07.54.953000 
uname: S:Windows 
comment: NTX6497 
process id: 660 
thread id: 3144 
</Header> 
<POFDisassembly> 
<![CDATA[ 
Failing instruction at 000000018004801A offset: 
0000000000000A04in <sqloFreeMemChunks> <NotFound:-1> 
        ]]></POFDisassembly> 
       <StackTrace> 
      <![CDATA[ 
 
------RBP--------------RIP--------------ARGS-------------------- 
------------------------------------- 
00000000136985E0 000000018004801A 0000000001B40000 
0000000000000002 000007FFFC98EDA0 0000000001B48829 offset: 
0000000000000A04 in <sqloFreeMemChunks> <NotFound:-1> 
00000000136986E0 000000018004C581 0000000013698720 
000007FFFC98EDA0 0000000000000000 000007FFCEDF0C98 offset: 
00000000000005A3 in <sqlofmblkEx> <NotFound:-1> 
0000000013698710 0000000001B48829 0000000000000001 
000000000BD6419D 000007FF00000001 0000000001B44FB4 offset: 
0000000000000009 in <sqlofmblk> 
<E:\db2_v97fp1\ntx64\s090917\engn\include\sqlomem.h:502> 
0000000013698790 00000000030E96C8 0000000013698978 
0000000013698D14 0000000013698D18 000000000213567E offset: 
00000000000000F2 in <sqlraERTDestroyTable> <sqlraert.C:259> 
0000000013699660 0000000002F7DFFF 0000000000000040 
000000000000000B 0000000000000000 000007FF00000000 offset: 
0000000000001585 in <sqlrr_appl_term> <sqlrr.C:3754> 
00000000136998E0 0000000001F44674 0000000000000000 
0000000006540740 0000000006506D10 0000000007C3B3E0 offset: 
0000000000000492 in <sqeApplication::AppStopUsing> 
<sqle_application.C:5097> 
0000000013699C30 00000000020261A7 0000000000000000 
000007FFFDA35D00 0000000000000005 0000000000000000 offset: 
0000000000000083 in <sqlesrspWrp> <sqleu_server.C:2288> 
0000000013699CE0 0000000002025D91 0000000000000001 
000000000000025A 0000000000000000 0000000000000000 offset: 
0000000000000095 in <sqleUCagentConnectReset> 
<sqleu_server.C:2469> 
0000000013699EB0 000000000211DABD 0000000000000000 
00000002280D30D9 0000000000000000 0000000000000000 offset: 
0000000000000EA9 in <sqljsCleanup> <sqljsqam.C:4419> 
0000000013699F50 0000000002117D90 0000000000000000 
0000000000000000 0000000000000000 0000000000000000 offset: 
000000000000046E in <sqljsDrdaAsInnerDriver> <sqljsqam.C:1322> 
000000001369F870 00000000021177A3 000007FFFC248270 
000000018008D35B 000000000027C4B0 0000000007500348 offset: 
000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046> 
000000001369FBD0 0000000001F4F276 0002625A00000000 
000000018001A3D6 000000734BD67DBD 000000018002C17A offset: 
0000000000000748 in <sqeAgent::RunEDU> <sqle_agent.C:3946> 
000000001369FC60 00000000038ADF35 000000000F350D98 
000000001369FCB0 0000000000000000 00000001800E007A offset: 
000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35> 
000000001369FF70 00000001800E0391 000000000F350D98 
0000000000000000 0000000000000000 000000001369FFA8 offset: 
000000000000042B in <sqloInitEDUServices> <NotFound:-1> 
000000001369FFA0 0000000077D0B71A 0000000000000000 
0000000000000000 0000000000000000 0000000000000000 
]]></StackTrace>
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW All platforms                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* the following connection reset might fail with -1224 which   * 
*                                                              * 
* brings down the instance.                                    * 
*                                                              * 
* <Header>                                                     * 
* DB2 build information: DB2 v9.7.100.119 s090917 SQL09071     * 
*                                                              * 
* timestamp: 2009-09-21-07.07.54.953000                        * 
* uname: S:Windows                                             * 
* comment: NTX6497                                             * 
* process id: 660                                              * 
* thread id: 3144                                              * 
* </Header>                                                    * 
* <POFDisassembly>                                             * 
* <![CDATA[                                                    * 
* Failing instruction at 000000018004801A offset:              * 
* 0000000000000A04in <sqloFreeMemChunks> <NotFound:-1>         * 
*        ]]></POFDisassembly>                                  * 
*      <StackTrace>                                            * 
*    <![CDATA[                                                 * 
*                                                              * 
* ------RBP--------------RIP--------------ARGS------------------ 
* -------------------------------------                        * 
* 00000000136985E0 000000018004801A 0000000001B40000           * 
* 0000000000000002 000007FFFC98EDA0 0000000001B48829 offset:   * 
*                                                              * 
* 0000000000000A04 in <sqloFreeMemChunks> <NotFound:-1>        * 
*                                                              * 
* 00000000136986E0 000000018004C581 0000000013698720           * 
* 000007FFFC98EDA0 0000000000000000 000007FFCEDF0C98 offset:   * 
*                                                              * 
* 00000000000005A3 in <sqlofmblkEx> <NotFound:-1>              * 
* 0000000013698710 0000000001B48829 0000000000000001           * 
* 000000000BD6419D 000007FF00000001 0000000001B44FB4 offset:   * 
*                                                              * 
* 0000000000000009 in <sqlofmblk>                              * 
* <E:\db2_v97fp1\ntx64\s090917\engn\include\sqlomem.h:502>     * 
*                                                              * 
* 0000000013698790 00000000030E96C8 0000000013698978           * 
* 0000000013698D14 0000000013698D18 000000000213567E offset:   * 
*                                                              * 
* 00000000000000F2 in <sqlraERTDestroyTable> <sqlraert.C:259>  * 
*                                                              * 
* 0000000013699660 0000000002F7DFFF 0000000000000040           * 
* 000000000000000B 0000000000000000 000007FF00000000 offset:   * 
*                                                              * 
* 0000000000001585 in <sqlrr_appl_term> <sqlrr.C:3754>         * 
* 00000000136998E0 0000000001F44674 0000000000000000           * 
* 0000000006540740 0000000006506D10 0000000007C3B3E0 offset:   * 
*                                                              * 
* 0000000000000492 in <sqeApplication::AppStopUsing>           * 
* <sqle_application.C:5097>                                    * 
* 0000000013699C30 00000000020261A7 0000000000000000           * 
* 000007FFFDA35D00 0000000000000005 0000000000000000 offset:   * 
*                                                              * 
* 0000000000000083 in <sqlesrspWrp> <sqleu_server.C:2288>      * 
*                                                              * 
* 0000000013699CE0 0000000002025D91 0000000000000001           * 
* 000000000000025A 0000000000000000 0000000000000000 offset:   * 
*                                                              * 
* 0000000000000095 in <sqleUCagentConnectReset>                * 
* <sqleu_server.C:2469>                                        * 
* 0000000013699EB0 000000000211DABD 0000000000000000           * 
* 00000002280D30D9 0000000000000000 0000000000000000 offset:   * 
*                                                              * 
* 0000000000000EA9 in <sqljsCleanup> <sqljsqam.C:4419>         * 
* 0000000013699F50 0000000002117D90 0000000000000000           * 
* 0000000000000000 0000000000000000 0000000000000000 offset:   * 
*                                                              * 
* 000000000000046E in <sqljsDrdaAsInnerDriver>                 * 
* <sqljsqam.C:1322>                                            * 
* 000000001369F870 00000000021177A3 000007FFFC248270           * 
* 000000018008D35B 000000000027C4B0 0000000007500348 offset:   * 
*                                                              * 
* 000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046>    * 
*                                                              * 
* 000000001369FBD0 0000000001F4F276 0002625A00000000           * 
* 000000018001A3D6 000000734BD67DBD 000000018002C17A offset:   * 
*                                                              * 
* 0000000000000748 in <sqeAgent::RunEDU> <sqle_agent.C:3946>   * 
*                                                              * 
* 000000001369FC60 00000000038ADF35 000000000F350D98           * 
* 000000001369FCB0 0000000000000000 00000001800E007A offset:   * 
*                                                              * 
* 000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35>         * 
* 000000001369FF70 00000001800E0391 000000000F350D98           * 
* 0000000000000000 0000000000000000 000000001369FFA8 offset:   * 
*                                                              * 
* 000000000000042B in <sqloInitEDUServices> <NotFound:-1>      * 
*                                                              * 
* 000000001369FFA0 0000000077D0B71A 0000000000000000           * 
* 0000000000000000 0000000000000000 0000000000000000           * 
* ]]></StackTrace>                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 v97fp1                                        * 
****************************************************************
Local-Fix:
Increase application heap size
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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
First Fixed in DB2 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.09.2009
15.01.2010
31.08.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList