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

-902 FROM SQLSSETUPINCREMENTALINSERTBUFFER

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
A programming error can lead to overflowed integer values in a 
memory calculation, leading to a shutdown of the database.  It 
is characterized by the following diagnostic message. 
 
2014-05-17-01.19.53.947696-240 I24199017E1564        LEVEL: 
Severe 
PID     : 6171                 TID : 139595094157056 PROC : 
db2sysc 
INSTANCE: svtdbm3              NODE : 000            DB   : 
BLUTEST1 
APPHDL  : 0-2203               APPID: 
127.0.0.1.49445.140517051950 
AUTHID  : SVTDBM3              HOSTNAME: m2svtlnx03 
EDUID   : 1752                 EDUNAME: db2agnts (BLUTEST1) 
FUNCTION: DB2 UDB, sort/list services, 
sqlsSetupIncrementalInsertBuffer, probe:40 
MESSAGE : ZRC=0x87130055=-2028797867=SQLS_PRGERR 
          "A data management services programming error 
occurred." 
          DIA8576C A data management services programming error 
occurred. 
DATA #1 : String, 50 bytes 
Error: First block is NULL!  Dumping memory buffer 
DATA #2 : SQLS_MEMBUFF, PD_TYPE_SQLS_MEMBUFF, 712 bytes 
 
SQLS_MEMBUFF: Address:0x7efaad82f100, Size:x2c8, Size:712 
   x0000        iMinBlockSize                 368934881474248704 
   x0008        offsetMap 
      SQLS_OFFSET_MAP: Address:0x7efaad82f108, Size:x18, Size:24 
         x0000  ppMemoryBlocks                0x7efaad8330a0 
         x0008  iMaxEntries                   1024 
         x0010  iNumEntries                   0 
   x0020        pMemPool                      0x7efaffc51f18 
   x02A8        iBlocksAllocated              0 
   x02AC        iCurrentBlock                 0 
   x02B0        iWorkBlockIndex               0 
   x02B4        iNumPagesReserved             4294967294 
   x02B8        iNumPagesAllocated            0 
   x02BC        iNumPagesUsed                 0 
   x02C0        memBuffFlags                  x00000002 
                - SQLS_MEMBUFF_INSERT_BUFFER
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 server environments using sorts.                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.4                              * 
****************************************************************
Local-Fix:
Update to the latest fixpack that this fix is available in.
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
The problem is first fixed in DB2 version 10.5.0.4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.05.2014
15.09.2014
15.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList