JR28916: SQL1585N COMPILING QUERY THAT INCLUDES A SUBQUERY IN A PREDICATE

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
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 to compile with SQLCODE -1585, SQLSTATE 54048
  if there is a predicate that contains a subquery.  This may
  occur even though there exists a temporary table space with the
  maximum page size of 32k.
  

Local fix

• Reduce the query optimization class to 1.
  

Problem summary

• Users affected : all
  Problem summary : possible incorrect -1585 error compiling a
  query
  Problem conclusion  : this apar will prevent the error from
  happening
  

Problem conclusion

• The problem was first fixed in v9.5 fixpak 4
  

Temporary fix

Comments

APAR Information

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

  JR28915

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

Fix information

• Fixed component name

  DB2 UDB EXE WIN

• Fixed component ID

  5724E4901

Applicable component levels

• R950 PSN

     UP