DB2 FOR LUW / DB2FORLUW / 970 - DB2

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 STRING: 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

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see ERROR DESCRIPTION                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 5.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC79927 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.05.2011
08.12.2011
08.12.2011

9.7.FP5