DB2 FOR LUW / DB2FORLUW / 970 - DB2

If the source table has ROW CHANGE TIMESTAMP columns which are 
marked as IMPLICITLY HIDDEN then performing a merge query might 
lead to database crash with the following stack trace: 
 
Windows: 
<StackTrace> 
 
<![CDATA[ 
 
--EBP------EIP------ARGS----------------------------- 
 
044668D8 6D662F97 00000000 54B4F234 55330060 54B4F228 offset: 
00000003 
in <?op@sqlnq_attattdpparent@@QAEPAVsqlnq_atd@@XZ> 
 
<T:/db2_v95fp6/nt32/s100918/engn/include/sqlnq_reldef.h:1377> 
 
04466A9C 6D9BF11C 553A031C 00000003 00000711 553A9400 offset: 
0000258E 
in 
<?sqlnq_sem_merge@@YAHQAPAUstknode_@@HW4actiontype@@PAEPAVloc@@@ 
Z> 
 
<sqlnq_sem_merge.C:2211> 
 
04466AEC 6D7E3BE4 553A0220 000007E4 00000020 00000001 offset: 
00000544 
in <?sqlnp_smactn@@YAHPAUsqlnp_cb@@H@Z> <sqlnp_prs.C:655> 
 
04466B58 6D7E2E89 553A0220 0365093C 4CD32BF2 0008A6D8 offset: 
000001CF 
in <?sqlnp_parser@@YAHPAUsqlnp_cb@@@Z> 
 
<T:/db2_v95fp6/nt32/s100918/engn/sqnp/inc/sqlnp_lpgprse.h:1031> 
 
04466BA8 6D7DEF83 044680B0 00000001 044680F4 20202020 offset: 
000002D7 
in <?sqlnp_main@@YAHPAVsqlnq_string@@FPAPAVsqlnq_qur@@@Z> 
 
<sqlnp_main.C:455> 
 
044681BC 6D6AA67D 7B0AA3E0 04468D44 00000001 00000002 offset: 
00000861 
in<?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compile 
Mode@@FPAU 
 
sqlrr_cmpl_env@@HHPAPAVsqlnq_qur@@@Z> <sqlnn_cmpl.C:2518> 
 
044681E8 6D6A9E14 7B0AA3E0 04468D44 00000001 00000002 offset: 
00000024 
in<?sqlnn_cmpl@@YAHPAVsqeAgent@@PAUsqlrrstring@@FW4sqlnn_compile 
Mode@@FPAU 
 
sqlrr_cmpl_env@@@Z> <sqlnn_cmpl.C:498> 
 
04468DB8 6DD9FDA6 5515DFB0 54AD2AC0 5570FE40 00000185 offset: 
000005E2 
in<?sqlra_compile_var@@YAHPAUsqlrr_cb@@PAUsqlra_cmpl_env@@PAEHGH 
HHHHPAUsql 
 
ra_cached_var@@PAHPA_K@Z> <sqlra_cmpl.C:955> 
 
04469790 6DDA3E9D 5515DFB0 55A680B0 00000000 00000000 offset: 
00000449 
in<?sqlra_find_var@@YAHPAUsqlrr_cb@@PAUsqlra_cached_stmt@@Usqlra 
_stmt_id@@ 
 
IIPAEIGEPAUsqlra_cmpl_env@@HPAHH5HHH5PAUSQLP_LOCK_INFO@@PAPAUsql 
ra_cached_var@@5PA_K_N@Z> 
<sqlra_dyn.C:3509> 
04469EA8 6DDADDD0 5515DFB0 00000001 00000000 00000000 offset: 
000004B6 
in <?sqlra_get_var@@YAHPAUsqlrr_cb@@HH_NPA_N2@Z> 
<sqlra_var.C:589> 
04469F48 6DD45E75 5515DFB0 00000000 545E07F4 545E0060 offset: 
000000D7 
in <?sqlrr_execute_immediate@@YAHPAUsqlrr_cb@@H@Z> 
<sqlrr_sql.C:1798> 
04469F78 6DCC7D1E 5608FDD0 5608FDD0 00000001 0000002F offset: 
00000112 
in <?sqlrr_execimmd@@YAHPAUdb2UCinterface@@@Z> 
<sqlrr_req_sql.C:3224> 
0446A02C 6D56E13B 5608FDD0 0446A0DC 7B0BFC90 0446A074 offset: 
00000811 
in 
<?sqljs_ddm_excsqlimm@@YAHPAUdb2UCinterface@@PAUsqljDDMObject@@@ 
Z> 
 
<sqljsexe.C:1983> 
 
0446A08C 6D561468 545E07F4 00000355 00000000 7B0BFC90 offset: 
0000020C 
in<?sqljsParseRdbAccessed.@@YAHPAUsqljsDrdaAsCb@@PAUsqljDDMObjec 
t@@PAUdb2UCinterface@@@Z> 
<sqljspar.C:410> 
 
On Unix: 
 
<StackTrace> 
--Frame--- ------Function + Offset------ 
0x17CF54A8 _ZN17sqlnq_fcsqclchild2ppEv + 0x0006 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF5674 _Z15sqlnq_sem_mergePP8stknode_i10actiontypePhP3loc + 
0x286b 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF56B4 _Z12sqlnp_smactnP8sqlnp_cbi + 0x0480 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF5724 _Z12sqlnp_parserP8sqlnp_cb + 0x01f8 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF5784 _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur + 0x036a 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF6DB0 
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq 
lrr_cmpl_enviiPP9sqlnq_qur 
+ 0x09b8 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF6DEC 
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq 
lrr_cmpl_env 
+ 0x0034 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF7910 
_Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP16sqlr 
a_cached_varPiPy 
+ 0x05bf 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF82D0 
_Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj 
jPhjthP14sqlra_cmpl_enviPiiS7_iiiS7_P14SQLP_LOCK_INFOPP16sqlra_c 
ached_varS7_Pyb 
+ 0x03c4 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF89F0 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x047b 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF8A74 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x1235 
                (/home/dbguest3/sqllib/lib32/libdb2e.so.1) 
0x17CF8AAC _Z14sqlrr_execimmdP14db2UCinterface + 0x0340 
 
(...)

**************************************************************** 
* USERS AFFECTED:                                              * 
* Customer using a MERGE with implicitly hidden columns        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If the source table has ROW CHANGE TIMESTAMP columns which   * 
* are marked as IMPLICITLY HIDDEN then performing a merge      * 
* query might lead to database crash.                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 fixpack 5 or later                           * 
****************************************************************

Reverse the order of processing with UPDATE operation before 
INSERT operation. The workaround might not work if there is no 
UPDATE clause in the matching condition.

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
 

This problem was first fixed in V9.7 Fixpack 5

not known / see Local fix

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

23.03.2011
20.01.2012
20.01.2012

9.7.FP5