IBM Support

IC89160: DB2 MIGHT ABEND WHILE EXECUTING A COMPOUND SQL STATEMENT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 provides support for compound SQL (compiled) statements aka
    Anonymous Blocks.
    Such blocks do not allow any DDL statements to be present inside
    and are expected to
    return a SQL0104N error message.
    
    However, under rare scenarios, the execution of such a block
    containing the DDL statement might cause DB2 to abend if the
    following conditions are satisfied:
    1. The anonymous blocks declares one or more DDL statements
    2. The block also contains one or more statements which has an
    isolation level set on them.
    
    ============================
    The crash was with signal 11  as below
    ============================
    
    0x00002AAAABA6BB18 _ZNK17sqlnq_qtbqunchild2ppEv + 0x0000
    (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1)
    0x00002AAAACF57920
    _Z30sqlnq_push_sub_select_iso_lockP9sqlnq_qun20sqlnq_isolationLe
    vel14sqlnq_lockModei  0x0056
    (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1)
    
    0x00002AAAABE12317 _Z15sqlnq_postParseP9sqlnq_qurP3loc + 0x05a7
    (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1)
    
    0x00002AAAABD32F5D
    _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
    lrr_cmpl
    _enviiPP9sqlnq_qur + 0x0bcb
    (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1)
    
    0x00002AAAABD3238D_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn
    _compileModesP14sqlrr_cmpl
    _env + 0x0021  (/db2home/dwpinst1/sqllib/lib64/libdb2e.so.1)
    

Local fix

  • Remove the DDL statements from the block.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 970 fix pack 8                        *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 version 970 fix pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89160

  • 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

    2012-12-17

  • Closed date

    2013-05-01

  • Last modified date

    2013-05-01

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

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

    IC91293

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC89160

Modified date: 01 May 2013