IBM Support

IC75206: DATABASE MAY ABEND DURING A MERGE STATEMENT IF SOURCE COLUMNS ARE MARKED AS IMPLICITLY HIDDEN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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 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
    
    (...)
    

Local fix

  • 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.
    

Problem summary

  • ****************************************************************
    * 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                           *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in V9.7 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75206

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-23

  • Closed date

    2012-01-20

  • Last modified date

    2012-01-20

  • APAR is sysrouted FROM one or more of the following:

    IC72594

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC75206

Modified date: 20 January 2012