IC85680: COMPILING CERTAIN SQL STATEMENT IN DPF CAN TAKE A LONG TIME OR RESULT IN SQL0101N

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In DPF environment, when a SQL statement meets the following
  conditions, compiling it can take a long time or run out of
  memory (SQL0101N)
  
  1. Two tables are joined together using a lot of equality
     predicates.
  2. One (or both) of the tables is a derived table that is
     derived from a query that contains a group by clause, and
     such group by clause have a lot of group by columns.
  3. Some (or all) of the group by columns participate in the
  equality join predicates.
  
  For example
  
  select ...
  from (select ... from T group by <a lot of columns>) as T1, T2
  where <a lot of equality join predicates>
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 UDB Version 9.7                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Version 9.7 FixPack 8.                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 UDB Version 9.7 FixPack 8.
  

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:

  IC90321

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP