IBM Support

IC68942: SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL IS SET TO YES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If system is using SMP set-up (INTRA_PARALLEL db cfg parameter
    IS SET TO YES) , then collecting section explain with actuals to
    investigate poor query performance could return wrong row counts
    when the same query is executed more then once.
    
    Please, install this fix, or use information from one execution
    of the query only.
    

Local fix

  • use information from one execution of the query only
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * SMP systems only                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN             *
    * INTRA_PARALLEL                                               *
    * IS SET TO YES                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * install this fix                                             *
    ****************************************************************
    

Problem conclusion

  • SECTION ACTUALS CAN RETURN WRONG ROW COUNTS WHEN INTRA_PARALLEL
    IS SET TO YES
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68942

  • 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

    2010-06-01

  • Closed date

    2010-09-16

  • Last modified date

    2010-09-16

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

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

    IC68972

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • 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:
16 September 2010