MF59650 - LIC-DB-UNPRED Ensure order of partitions in partitioned tabl

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF59655   00/00    0000
CO   5770999  710  MF59652   00/00    0000
CO   5770999  710  MF59653   00/00    0000
CO   5770999  710  MF59654   00/00    0000
CO   5770999  710  MF59656   00/00    0000
CO   5770999  710  MF58236   00/00    0000
CO   5770999  710  MF55244   00/00    0000
CO   5770999  710  MF54580   00/00    0000
DIST 5770SS1  710  SI55802   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

-----------------------------------------------
Random order of partitions in a partitioned table query could
result in unpredictable performance if only a subset of rows are
selected

CORRECTION FOR APAR MA44330 :
-----------------------------
The partitions in a partitioned table query will be ordered in a
fixed order to ensure predictable performance

CIRCUMVENTION FOR APAR MA44330 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF58411      OSP-DB-OTHER-INCORROUT DIFFERENCES BETWEEN CCSID 65535 AND 5
   MF58237      LIC-DB-OTHER-PERFM SLOW PARTITION DUE TO CONCURRENT IDENTICA
   MF57285      PERFM-HLIC-94XXBASE UDF DEFINED AS NOT DETERMINISTIC, EXTERN
   MF57264      LIC-DB-OTHER Internal maintenance
   MF57141      OSP-PERFM QUERY USING WITH CLAUSE NOT USING BEST INDEX RESUL
   MF56941      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56066      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF55245      OSP-F/VEDHANDLER-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/VEDHAN
   MF54579      LIC-DB MCH3601 After Removing PTF
   MF51922      LIC DB - 0600 BADD LIC logs from removeIter
   MF51372      LIC-DB-PERFM SQE optimization performance
   MF50613      LIC-DB-OTHER Internal Database Maintenance
   MF50606      LIC-DB-LOOP Hanging Lock on DB List Object
   MF49365      LIC-DB Internal maintenance
   MF49056      LIC-DB-OTHER-THREADS-LOOP QSQSRVR Jobs Won't End With Dbst C
   MF48459      LIC-DB-OTHER-THREADS  0600 - A21C/A1B8/BADD Vlogs From Corru
   MF48821      LIC-DB Internal Maintenance

Summary Information

System i Support