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

SORT PRIVATE MEMORY COUNTER UNDERFLOW DETECTED IN DB2DIAG.LOG

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The following message may be recorded when you are executing 
SQL statement. 
 
2009-06-22-14.26.04.867439+540 I65310A568         LEVEL: Error 
PID     : 561288               TID  : 11576       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-20878              APPID: 
192.168.1.35.49281.09062205213 
AUTHID  : db2inst1 
EDUID   : 11576                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, sort/list services, sqlsReleasePrivateSpace, 
probe:10 
MESSAGE : Sort private memory counter underflow detected 
DATA #1 : Hexdump, 4 bytes 
0x07000002877F8188 : 0000 0007 
.... 
 
2009-06-22-14.26.04.867718+540 I65879A553         LEVEL: Error 
PID     : 561288               TID  : 11576       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-20878              APPID: 
192.168.1.35.49281.09062205213 
AUTHID  : db2inst1 
EDUID   : 11576                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : Current allocation: 
DATA #1 : Hexdump, 4 bytes 
0x07000002877F80E8 : 0000 0000 
....
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* You will see this messages in db2diag.log.                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See APAR description.                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 9.7 fixpack 1.                    * 
****************************************************************
Local-Fix:
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
Problem was first fixed in DB2 UDB Version 9.7 FixPack 1.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.08.2009
24.12.2009
24.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList