| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT02008 | Status: Closed |
-902 FROM SQLSSETUPINCREMENTALINSERTBUFFER | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * 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. | |
| available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Solution | |
The problem is first fixed in DB2 version 10.5.0.4 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.05.2014 15.09.2014 15.09.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.4 |
|