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