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

DB2TOP DUMPS CORE WHEN ENTERING AN INVALID SQL HASH STRING

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
db2top can dump core when an ivalid SQL HASH STRING was entered. 
 
Reproduction steps: 
 
1) db2top -d sample 
 
2) D 
 
3) L 
 
4) ENTER SQL HASH STRING: 
SELECT AAAAAAAAAAAAAAAAA from xxxxxxx.XX_XXXX_XXXX WHERE TAG = 
'10000003-0000-9000-3030-303630303137' AND 
BBBBBBBBBBBBBBBBBBBBBBB LIKE 'MIGRA%' AND CCCCCCCCCCCC = 
'EXTERNAL' AND LABEL <= ? AND LABEL > ?? 
 
In this case something like: 
 
4) ENTER SQL HASH CODE: 00000000070889701463804304 
 
is expected. Anyways there should not be a core. 
 
The failing stack is: 
 
Segmentation fault in pthread_kill at 0x9000000007a57d0 ($t1) 
0x9000000007a57d0 (pthread_kill+0xb0) e8410028          ld 
r2,0x28(r1) 
(dbx) where 
pthread_kill(??, ??) at 0x9000000007a57d0 
_p_raise(??) at 0x9000000007a5048 
finish() at 0x100002270 
interrupt(??, ??, ??) at 0x100055cc0 
wborder_set(??, ??, ??, ??, ??, ??, ??, ??) at 0x90000003c6dae44 
box32(??, ??, ??) at 0x90000003c6dd8bc 
mybox() at 0x100022f24 
putMsg() at 0x1000225ac 
do_sqltext() at 0x100037cc4 
select_sqltext() at 0x1000375a0 
do_detail() at 0x10002c5fc 
do_foreground() at 0x1000011f4 
main() at 0x1000009fc
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.8                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.8 FixPack 5.                            * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 UDB Version 9.8 FixPack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
21.11.2011
15.06.2012
15.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.8.FP5
Problem behoben lt. FixList in der Version
9.8.0.5 FixList