IBM Support

MF57556 - LIC-DB-OTHER-INCORROUT Queries which group over LOB columns

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-INCORROUT Queries which group over LOB columns


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF51097   00/00    0000
CO   5770999  710  MF57547   00/00    0000
CO   5770999  710  MF57002   00/00    0000
CO   5770999  710  MF56066   00/00    0000
CO   5770999  710  MF55952   00/00    0000
CO   5770999  710  MF55839   00/00    0000
CO   5770999  710  MF54297   00/00    0000
CO   5770999  710  MF51184   00/00    0000
CO   5770999  710  MF51187   00/00    0000
CO   5770999  710  MF51257   00/00    0000
CO   5770999  710  MF49930   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

-----------------------------------------------
Occasionally SQL queries which group over a BLOB or CLOB column
may produce wrong results if a MIN or MAX aggregation and a
COUNT aggregation over the same BLOB or CLOB column are
specified.

CORRECTION FOR APAR MA43135 :
-----------------------------
The SQL optimizer was incorrectly building some access plans for
aggregation functions over BLOB and CLOB columns. This fix
corrects these plans.

CIRCUMVENTION FOR APAR MA43135 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF57546      OSP-DB-OTHER-INCORROUT THE CUSTOMER IS SEEING INCONSISTENT O
   MF57497      LIC-DB-OTHER-PERFM SMP QUERY EXECUTION IS PREVENTED BY HIGH
   MF57035      LIC-DB-OTHER-INCORROUT SQL OPTIMIZER USING SPARSE INDEXES WI
   MF57025      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/A
   MF57003      OSP-DB-OTHER-INCORROUT SYSIXADV RECOMMENDS FIELDS MORE THAN
   MF56938      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56302      LIC-PERFM LARGE NUMBER OF SEIZES DURING ON SPARSE MTIS OPTIM
   MF56180      LIC-DB-OTHER-F/DBOPOPERATIONMISC-T/QQQOOODBOP-MSGMCH3601
   MF56068      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF55950      LIC-DB-MSGMCH3601 relating to partitioned tables and EVIs
   MF55835      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55733      LIC-DB-OTHER-MSGMCH3203 Queries of aggregate DISTINCT data w
   MF55617      LIC-DB-INCORROUT INDEX CREATED OVER PARTITIONED TABLE WILL C
   MF55500      LIC-DB-UNPRED Using LOBs as input to UDTF
   MF55420      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF54693      LIC-DB-MSGMCH3402 0600 BADD VLOG Running Partitioned Table Q
   MF54573      LIC DB - Query fails due to lost seize during MTI creation
   MF54296      LIC-DB-PERFM Union QDS's incorrectly requesting preload on r
   MF54024      LIC-DB-PERFM-OTHER Problems with costing Select/Omit indexes
   MF53024      LIC-DB-OTHER-PERFM COMPLEX QUERY PLAN IS TOO LARGE TO BE SAV
   MF52460      LIC-DB Connect by infrastructure
   MF51927      LIC DB - 0600 BADD LIC logs from removeIter
   MF51499      LIC-DB-MSGMCH3203 Visual Explain with a FieldProc
   MF51381      LIC-DB-PERFM SQE optimization performance
   MF51181      OSP-DB Creation of SQL deflated table
   MF51065      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0901 SOME SQL CAUSES
   MF51044      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50597      LIC-DB-PERFM SSD support during query optimization
   MF50597      LIC-DB-OTHER Internal Maintenance
   MF50494      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50310      LIC-DB-MSGMCH3203 SQL Field Procedure in a partitioned table
   MF49961      LIC-DB-OTHER LPG HIGHLIGHTING IS NOT WORKING CORRECTLY IN TH
   MF49961      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49924      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49552      LIC SMP CAN CHOOSE A VERY HIGH SMP NUMBER WHEN USING EVI'S
   MF49401      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49393      LIC-DB-MSGMCH3203 SQL Array and XML Agg
   MF49386      LIC-DB-INCORROUT COLLATE_ERRORS *YES not being honored for G
   MF48790      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 COMPLEX
   MF48774      LIC-DB-SQL Add long index schema to dbmon
   MF48676      LIC DB MSGMCH3203 DbpmTrap sAttributeOperationRefreshFailed
   MF48600      LIC-DB-MSGMCH3203 SQL Arrays
   MF48491      LIC-DB-MSGMCH3203 SQL Arrays
   MF48568      LIC-DB SQL query does not complete.
   MF48346      OSP DB OTHER Partitioned table and aggregate EVI support
   MF47920      LIC-DB-OTHER-MSGCPF4204 CPF4204 WHEN RUNNING OVER LARGE PART

Summary Information

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


IBM 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, 2018, 2019, 2020 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770999","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770999","Edition":""}]

Document Information

Modified date:
10 December 2020