IC89918: A FEDERATED QUERIY CONTAINING SUBQUERY PREDICATES MAY FAIL WITH SQL0901N IN AN SMP ENVIRONMENT.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • In SMP mode, a federated query containing subquery predicates
    may fail with SQL0901N during compilation.
    An example of the failing query:
    SELECT 1 FROM NNT1 A  WHERE    (EXISTS(SELECT 1 FROM NNT2 WHERE
    C1=LOCALFUNC1('test')) OR C2='test');
    where NNT1/NNT2 are remote tables and LOCALFUNC1 is a local
    function that accesses local tables.
    
    Error received:
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason
    "sqlnoSmpPlanShipOp
    [100]:rc(     0)                ".)  SQLSTATE=58004
    
    The following error stack can be found in the trace:
    -------Frame------ ------Function + Offset------
    0x09000000004CD6B0 pthread_kill + 0xB0
    0x0900000005255D48 sqloDumpEDU + 0xA4
    0x09000000052B43BC sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
    0x100
    0x0900000005215250
    sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2@glue59B + 0x98
    0x0900000005690BBC sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x360
    0x0900000009243FD4 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x50
    0x0900000005920798 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
    0x238
    0x09000000055D96DC sqlnn_erds__FiN41e + 0x340
    0x09000000082B2600
    sqlnoSmpPlanShipOp__FP20SQLNO_SMP_POSTOPT_CBP21SQLNO_POSTOPT_CON
    TEXTPP19sqlno_plan_operator + 0x400
    0x09000000082ACCCC
    sqlnoSmpPlanNLJNOp__FP20SQLNO_SMP_POSTOPT_CBP21SQLNO_POSTOPT_CON
    TEXTPP19sqlno_plan_operator + 0xB38
    0x09000000082ACCCC
    sqlnoSmpPlanNLJNOp__FP20SQLNO_SMP_POSTOPT_CBP21SQLNO_POSTOPT_CON
    TEXTPP19sqlno_plan_operator + 0xB38
    0x09000000082B02A8
    sqlnoSmpPlanMateOp__FP20SQLNO_SMP_POSTOPT_CBP21SQLNO_POSTOPT_CON
    TEXTPP19sqlno_plan_operator + 0x54C
    0x09000000082B0678
    sqlnoSmpPlanPipeOp__FP20SQLNO_SMP_POSTOPT_CBP21SQLNO_POSTOPT_CON
    TEXTPP19sqlno_plan_operator + 0x340
    0x09000000082C7054
    sqlno_smp_process_subsection__FP20SQLNO_SMP_POSTOPT_CBP19sqlno_p
    lan_operatorP17sqlno_smp_ss_info + 0x444
    0x09000000082B612C
    sqlnoSmpPlanPass__FP20SQLNO_SMP_POSTOPT_CBP19sqlno_plan_operator
    P13sqlno_costtyp + 0x6C8
    0x09000000082B5934 sqlnoSmpPostPassMain + 0x2F8
    0x090000000658EA9C sqlno_final_phase__FP13sqlno_globals + 0x5B0
    0x0900000008E1A9D0 sqlno_exe__FP9sqlnq_qur + 0x638
    0x0900000008FE9084 sqlno_exe__FP9sqlnq_qur@glue1754 + 0x84
    0x0900000008FE91D0
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x94
    0x09000000090987E8
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x40
    

Local fix

  • Disable SMP
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 v10.1 FP1 or earlier.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v10.1 Fix Pack 2.                             *
    ****************************************************************
    

Problem conclusion

  • The problem was fixed in DB2 v10.1 Fix Pack 2.
    

Temporary fix

  • Disable SMP
    

Comments

APAR Information

  • APAR number

    IC89918

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-30

  • Closed date

    2013-02-19

  • Last modified date

    2013-02-19

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

    IC83806

  • 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

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC89918

Modified date:

2013-02-19

Translate my page

Machine Translation

Content navigation