IZ99667: QUERY INVOLVING TYPED TABLES WITH MULTIPLE REFERENTIAL INTEGRITY CONSTRAINTS MIGHT FAIL WITH A SQL0901N ERROR

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• A query may fail with a SQL0901N error message if the following
  conditions are true:
  1. There are typed tables involved.
  2. The typed table has multiple referential integrity (RI)
  constraints associated with it.
  3. The query is a select and has an outer join referencing the
  typed table
  4. The query does not reference all the columns from the typed
  table which are involved in the multiple RIs,
      i.e. some of the constraints are unreferenced in the query.
  

Local fix

• Rewrite the query to reference the unused columns in the query
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 v9.5 Fixpak 9                                 *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 v9.5 Fixpak 9
  

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:

  IC76796

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R950 PSY

     UP