IBM Support

PI41494: IN PREDICATE WITH ROW VALUE CONSTRUCTOR NOT PUSHED TO ORACLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When using a row value constructor against an Oracle database
    the IN predicate is not getting pushed into the Native SQL. This
    causes split SQL down on the database and performance is
    affected
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.0                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI41494

  • Reported component name

    COG ADMINISTRAT

  • Reported component ID

    5724W12AD

  • Reported release

    A21

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-20

  • Closed date

    2015-12-23

  • Last modified date

    2015-12-23

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

    PI41144

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

Fix information

Applicable component levels

  • RB00 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
06 March 2023