PK81479: INCORROUT (OUTPUT NOT IN REQUESTED ORDER) ON QUERY WITH INTERSECT / EXCEPT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect output (not in requested order) when running a query
  with Intersect or Except and Orderby clause.
  .
  An example of the failing query is like:
  SELECT DBNAME, TSNAME, PARTITION AS PART
  FROM SYSIBM.SYSTABLEPART
  WHERE DBNAME = 'DSNDB06'
  INTERSECT
  SELECT DBNAME, TSNAME, DSNUM AS PART
  FROM SYSIBM.SYSCOPY
  WHERE ICTYPE = 'F'
  ORDER BY TSNAME DESC
  .
  Keywords:  DB2INCORR/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users that have DML statements with  *
  *                 INTERSECT or EXCEPT clauses.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect results may be returned for   *
  *                      DML statements that contain INTERSECT   *
  *                      or EXCEPT clauses.  Various abends      *
  *                      are also possible, such as              *
  *                      ABND=04E-00E70005,                      *
  *                      LOC=DSNXGRDS.DSNXGINB:M125              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Incorrect results may be returned for DML statements that
  contain INTERSECT or EXCEPT clauses.
  
  Various abends are also possible, including
  ABND=04E-00E70005,LOC=DSNXGRDS.DSNXGINB:M125
  
  Additional Keywords:
  INCORROUT SQLINCORR SQLINTERSECT SQLEXCEPT
  

Problem conclusion

• Code is changed to correct the problem causing incorrect results
  and abend conditions.
  
  As a result, additional sorting may occur during the processing
  associated with INTERSECT or EXCEPT.  The additional sorting
  may cause the DML statement to execute slower than before, but
  is necessary to ensure correct results are returned.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK51132

Modules/Macros

• DSNXODSO DSNXOGA1 DSNXOGP  DSNXONDA DSNXOSOB
  DSNXOSOC DSNXOTS1 DSNXOVC  DSNXOV1  DSNXQAR  DSNXV1P
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK51132

     UP09/11/03 P F911

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.