IBM Support

MF51774 - LIC-DB-OTHER-INCORROUT ON SQE QUERY WITH ORDER BY CLAUSE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-INCORROUT ON SQE QUERY WITH ORDER BY CLAUSE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF51775   00/00    0000
CO   5770999  710  MF51275   00/00    0000
CO   5770999  710  MF51012   00/00    0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.





APAR Error Description / Circumvention

-----------------------------------------------
If the order by clause is used for the select statement, the SQE
optimizer chose a bad plan, which results in incorrect number of
records returned.

CORRECTION FOR APAR MA40258 :
-----------------------------
A fix was made to SQE hash distinct scan processing and now the
correct results are returned.

CIRCUMVENTION FOR APAR MA40258 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF51278      LIC-DB-PERFM Non-preload brings not targeting specific pool
   MF51269      LIC-DB CS and CURRENTLY COMMITTED row skipped when locked
   MF51214      LIC-DB-MSGMCH3203 IN JOB LOG / DBOP AND QEO DUMPS CREATED AN
   MF51011      LIC-DB-PERFM SQL Select with inner join on RRN performs poor
   MF50963      LIC-DB-INCORROUT EVI vector scan on right side of join retur
   MF50771      LIC-DB-MSGCPF5257 CPF5257 with MCH0001 and 0600 DEAD VLOG in
   MF50661      LIC-DB-OTHER Recursive Common Table Expression (RCTE) Enhanc
   MF50228      LIC-DB iDeliver application fails with partial damage after
   MF50183      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF50140      LIC-DB pseudo open of SQE query orphans record lock
   MF48796      LIC-DB-MSGMCH3601 F/DbpmPtbSad during access of SQE temp ind
   MF48527      LIC-DB-WAIT Dead lock possible when creating a large EVI wit
   MF49783      OSP-DB Performance enhancement for SQL MERGE statement
   MF50091      LIC-DB-OTHER-F/DBPMRRNBITMAPSCANNODE-T/QDBGETMQO-MSGMCH3402
   MF48009      LIC-DB SQE query tree validation failure due to bad position
   MF47883      LIC-DB-INCORROUT when using RCTE in combination with Random
   MF49102      LIC-DB-PERFM EVI with INCLUDE paging computations do not inc

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA40258
Superseded by:......................View fix details for PTF MF61476
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1116710


System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 December 2010