IBM Support

MF56316 - LIC-DB-OTHER-PERFM Slow queries over partitioned tables with

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-PERFM Slow queries over partitioned tables with


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF56157   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

-----------------------------------------------
Queries over partition tables may unexpectedly run more slowly
if there are column statistics collected over empty partitions
in the table. An 0600 A1B8 LIC log is produced when the query
runs slowly.

CORRECTION FOR APAR MA42439 :
-----------------------------
A problem with how the SQL query optimizer was evaluating the
column statistics over empty partitions caused internal
optimization functions to fail. This fix enables the
optimization functions to run correctly.

CIRCUMVENTION FOR APAR MA42439 :
--------------------------------
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
--------------  ------------------------------------------------------------
   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 MA42439
Superseded by:......................View fix details for PTF MF61790
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C3037710


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:
08 November 2012