IBM Support

IC84779: DB2 MIGHT ABEND WHEN EXECUTING EXISTENTIAL SUBQUERIES WITH ROWNUM PREDICATE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 supports usage of ROWNUM olap function in a predicate
    context when DB2_COMPATIBILITY_VECTOR is set.
    Under rare scenario when this might be used with a existential
    subquery this can lead to a DB2 abend.
    
    <Stack Trace>
    0        ossDumpStackTraceEx
    1        OSSTrapFile::dumpEx
    2        OSSTrapFile::dump
    3        sqlo_trce
    4        sqloEDUCodeTrapHandler
    5        __pthread_mutex_cond_lock
    6        sqlno_analyze_countingSQ
    7        sqlno_analyze_pred_expr
    8        sqlno_assign_optprd
    9        sqlno_assign_prd
    10       sqlno_call_sf
    11       sqlno_each_opr
    12       sqlno_call_sf
    13       sqlno_assign_walk_quns_and_ff
    14       sqlno_call_sf
    15       sqlno_each_opr
    16       sqlno_call_sf
    17       sqlno_top_qtb
    18       sqlno_call_sf
    19       sqlno_each_qur
    20       sqlno_call_sf
    21       sqlno_scan_qgm
    22       sqlno_prep_phase
    23       sqlno_exe
    24       sqlnn_cmpl
    25       sqlnn_cmpl
    26       sqlra_compile_var
    27       sqlra_find_var
    28       sqlra_get_var
    29       sqlrr_prepare
    30       sqljs_ddm_prpsqlstt
    31       sqljsParseRdbAccessed
    32       sqljsParse
    33       sqljsSqlam
    34       sqljsDriveRequests
    35       sqljsDrdaAsInnerDriver
    36       sqljsDrdaAsDriver
    37       sqeAgent::RunEDU
    38       sqzEDUObj::EDUDriver
    39       sqlzRunEDU
    40       sqloEDUEntry
    41       pthread_create@@GLIBC_2.2.5
    42       clone
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 970 fixpack 7                                 *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in DB2 970 fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC84779

  • 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-06-20

  • Closed date

    2012-12-05

  • Last modified date

    2012-12-05

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

    IC84728

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

    IC85198

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 December 2012