IBM Support

MF61790 - OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM NO OR INCORRECT INDEX

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM NO OR INCORRECT INDEX


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF56662   00/00    0000
CO   5770999  710  MF61132   00/00    0000
CO   5770999  710  MF56178   00/00    0000
CO   5770999  710  MF50693   00/00    0000
CO   5770999  710  MF55245   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

-----------------------------------------------
Bad selectivity estimate for a predicate over a column in which
a high percentage of the values are in a very small range, with
a small number of outliers very far away.  The bad estimate
results in an inefficient plan choice.

CORRECTION FOR APAR MA45486 :
-----------------------------
The fix will be to improve the algorithm used to provide the
estimate.

CIRCUMVENTION FOR APAR MA45486 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF54898 :
=================================================

Column statistics showing the problem fixed by this PTF will need to be
re-collected after applying the PTF in order to correct the statistics
data.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF61133      LIC-DB-OTHER-PERFM Improved column statistics collection for
   MF59165      OSP-DB-OTHER-UNPRED MSGMCH3203 VL0600A029 VL02001720
   MF56670      LIC-DB Prevent Statistics Collection while file in an online
   MF56316      LIC-DB-OTHER-PERFM Slow queries over partitioned tables with
   MF56158      LIC-DB Detect skew in partitioned tables
   MF55244      OSP-F/VEDHANDLER-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/VEDHAN
   MF54898      OSP-DB-OTHER-INCORROUT RETRIEVING STATISTICS DATA RESULTS IN
   MF54361      PERFM-HLIC HIGH COLUMN STAT COUNT CAUSING LONGER RUNNING QUE
   MF53948      LIC-DB Improvements for Global Context Manager portion of AQ
   MF53160      OSP-OTHER-PERFM INCORRECT STATISTICAL ESTIMATE CAUSES A QUER
   MF51931      LIC DB - 0600 BADD LIC logs from removeIter
   MF51379      LIC-DB-PERFM SQE optimization performance
   MF50722      LIC-DB-OTHER Internal maintenance
   MF49057      LIC-DB-OTHER-THREADS-LOOP QSQSRVR Jobs Won't End With Dbst C
   MF48461      LIC-DB-OTHER-THREADS  0600 - A21C/A1B8/BADD Vlogs From Corru
   MF48952      OSP-DB-OTHER-THREADS-PERFM MULTIPLE SHORT LIVED THREADS BEIN
   MF55814      LIC-DB Avoid immediate refresh of stats when error during co
   MF52497      LIC-DB Implement join skew testing via EVI counts
   MF50692      LIC-DB F/QDBFSTCCOL-CREATESTATISTIC DBFSTCCOL JOB RUNNING MO

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA45486
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C6320710


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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"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":""}}]

Document Information

Modified date:
10 May 2016