IBM Support

PM96167: REPORT WITH MANY COLUMNS TAKES A LONG TIME TO GENERATE SQL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A report is created which is relatively simple but contains many
    columns. This may be exacerbated by union reports which increase
    the number of columns for every query unioned together.  The SQL
    generated by the report executes quickly on the database, but
    generating the SQL for the report takes much longer than
    expected.  This may be on the order of 1 minute to generate
    queries which run in 1 second on the database, given a
    sufficiently wide report.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 2                                                            *
    * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM96167

  • Reported component name

    COG ADMINISTRAT

  • Reported component ID

    5724W12AD

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-30

  • Closed date

    2014-03-31

  • Last modified date

    2014-03-31

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

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

Fix information

  • Fixed component name

    COG ADMINISTRAT

  • Fixed component ID

    5724W12AD

Applicable component levels

  • RA20 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHM94","label":"Administration and Configuration v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
31 March 2014