IC74626: CORRELATED SUBQUERY THAT RAN FINE IN 9.40 IS HANGING OR NEVER RETURNING IN 11.50; ESTIMATED COST IS VERY HIGH

APAR status

• Closed as program error.

Error description

• Customer is upgrading from 9.40 to 11.50.  They have a query
  that does a correlated subquery and it returns in less than 1
  minute in 9.40.  In 11.50, they kill it after a few hours.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users using OR clauses in a query, and identical subterms in *
  * all arms of the OR clause.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The query takes a long time.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xc9 when it is available.               *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 11.50.xC9.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP

• RB15 PSY

     UP