PM91262: PERFORMANCE OF DRILL-DOWN IS EXTREMELY SLOW UNDER DQM AND HUGE DATA ENVIRONMENT.

APAR status

• Closed as program error.

Error description

• Performance of drill-down is extremely slow under DQM and huge
  data environment. ?The attached testcase illustrates what the
  users are facing though it is very simplified.  ??As per the
  analysis of the generated SQL when drill-down, they insist that
  "OR" is included in where clause like below and Cognos is
  retrieving the unnecessary data from data source. ?We do not
  feel the slow performance with the described steps as it is
  sample, there are ten million and more records in their data
  source and the generated SQL like below causes the slow
  performance of drill-down, they suspect. ?(They want this to be
  "AND" instead of "OR")??-----?set fmtonly on SELECT?
  "Products"."Product_line_code" AS "column0", ?
  "Products"."Product_type_code" AS "column1", ?
  "Products"."Product_type" AS "column2", ?
  "Products"."Product_line" AS "C_sortColumn0", ?
  "Products"."Product_type" AS "C_sortColumn1"?FROM?    (?
  SELECT?        MIN("PRODUCT_LINE"."PRODUCT_LINE_EN") AS
  "Product_line", ?        MIN("PRODUCT_TYPE"."PRODUCT_TYPE_EN")
  AS "Product_type", ?        "PRODUCT_LINE"."PRODUCT_LINE_CODE"
  AS "Product_line_code", ?
  "PRODUCT_TYPE"."PRODUCT_TYPE_CODE" AS "Product_type_code"?
  FROM?        "GOSALES"."PRODUCT_LINE" "PRODUCT_LINE"?
  INNER JOIN "GOSALES"."PRODUCT_TYPE" "PRODUCT_TYPE"?
  ON "PRODUCT_LINE"."PRODUCT_LINE_CODE" =
  "PRODUCT_TYPE"."PRODUCT_LINE_CODE" ?    GROUP BY ?
  "PRODUCT_LINE"."PRODUCT_LINE_CODE", ?
  "PRODUCT_TYPE"."PRODUCT_TYPE_CODE"?    ) "Products" ?WHERE ?
  "Products"."Product_line_code" = 991 OR <<-- Problem here !!?
  "Products"."Product_type_code" = 951 ?GROUP BY ?
  "Products"."Product_line_code", ?
  "Products"."Product_type_code", ?    "Products"."Product_type",
  ?    "Products"."Product_line" ?ORDER BY ?    "C_sortColumn0"
  ASC, ?    "column0" ASC, ?    "C_sortColumn1" ASC, ?
  "column2" ASC, ?    "column1" ASC?set fmtonly
  off?-----??(Environment)?Cognos BI 10.2 -- reproduced.?Cognos BI
  10.2.1 -- reproduced.
  

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  *
  * 1                                                            *
  * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• 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 CONNECTION

• Fixed component ID

  5724W12CC

Applicable component levels

• RA20 PSN

     UP