PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/DBOPSTRATEGYNORMALIZATION-T/QQQOOODBOP- MSGMC
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770999 V7R3M0 MF62602 00/00 0000
CO 5770999 V7R3M0 MF63713 00/00 0000
CO 5770999 V7R3M0 MF63584 00/00 0000
CO 5770999 V7R3M0 MF63435 00/00 0000
CO 5770999 V7R3M0 MF63297 00/00 0000
CO 5770999 V7R3M0 MF63298 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
-----------------------------------------------
msgMCH3203 F/DbopStrategyNormalization T/QQQOOODBOP VL0600BADD
CORRECTION FOR APAR MA46467 :
-----------------------------
The problem involves rewriting the query with multiple UNIONs in
to a wide UNION for optimization time performance. The logic
made an assumption about the number of entries on a UNION select
list that was not always true when converting 'n' unions/union
alls in to one wide union. This assumption was 'asserted' to be
true and it should not have been.
CIRCUMVENTION FOR APAR MA46467 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF63755 OSP-OTHER-PERFM COGNOS QUERY PERFORMS POORLY AFTER BOTH THE
MF63743 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-RCFUNCTIONERRORX'17
MF63714 OSP-UNPRED QUERY ESTIMATED RUNTIME WITH XMLELEMENT FIELD SEL
MF63583 LIC-DB-OTHER-PERFM LEFT OUTER JOIN QUERY PERFORMANCE
MF63570 LIC-DB-PERFM Random IO for tables
MF63553 OSP-DB-OTHER-F/DBOPAFFINITYX/68C4-T/QQQOOODBOPX4994-MSGMCH32
MF63445 OSP-DB-OTHER-F/DBOPAFFINITYX/68C4-T/QQQOOODBOPX4994-MSGMCH32
MF63445 LIC-DB-MSGMCH3203 T/F QQQOOODBOP/DbopAffinity when using CUB
MF63434 LIC-DB-OTHER-PERFM Optimization time improvements for comple
MF63412 OSP-PERFM OPTIMIZER ENHANCEMENT TO MAKE THE CORRECT DECISION
MF63370 OSP-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 IF LOGICAL FIL
MF63340 LIC-DB Improve AQP's ability to re-optimize LPG plans
MF63301 LIC-DB Internal Maintenance
MF63281 LIC-DB-OTHER-PERM Improve query performance by removing extr
MF63268 LIC-DB Optimizer choosing index with 8k page size leads to p
MF63208 LIC-DB-OTHER-PERFM LONG OPTIMIZATION OF COMPLEX QUERY WITH M
MF63173 OSP-DB-OTHER-PERFM SLOW TABLE SCAN USED FOR SCROLL CURSOR WI
MF63159 OSP-OTHER-PERFM JOIN QUERY PERFORMANCE
MF63117 LIC-DB-PERFM Long optimization time for OLAP and SMP queries
MF63085 LIC-DB-OTHER-PERFM IMPROVE PARTITION AVOIDANCE FOR JOIN
MF63069 LIC-DB-OTHER-INCORROUT SQLRPGLE USING XML FAILS WITH SQLSTAT
MF62937 LIC-DB-MSGMCH3203 Scalar OLAPs and RANK OLAP
MF62922 LIC-DB-PERFM Poor Plan
MF62874 LIC QUERY WITH TRANSITIVE JOIN NOT RETURNING THE CORRECT RES
MF62862 LIC-DB-PERFM Index Merge Ordering
MF62855 OSP-DB QUERY THAT REUSING A PLAN IS NOT UPDATING ALL PREDICA
MF62850 LIC-DB-PERFM Excessive optimization time when MQTs enabled
MF61420 LIC-DB-MSGMCH3203 DbstMdDadDataSpaceConcrete
MF61207 OSP-DB MSGMCH3601 F/DBPMFORMAT T/QQQOOODBOP VL0600 BADD
MF62762 OSP-DBPARL-PERFM LIMITED PLAN CHOICE DUE TO JOIN ORDER RESUL
MF62743 OSP-DB-OTHER-F/DBPMTRAPX/09B8-T/DBQQQOOODBOPX/4963-MSGMCH320
MF62649 F/QQQOOODBOP-MSGMCH3203 MCH3203 F/ QQQOOODBOP T/ QQQOOOINV
MF62647 LIC-DB-OTHER-INCORROUT QUERY/400 RETURNS TOO MANY ROWS IN SQ
MF62606 LIC-DB-OTHER-INCORROUT Incorrectly sorted results possible w
MF62504 DB-LIC-MSGMCH3203 Plan Cache Snapshot sEstimatedIoTimeInUs_
MF62498 LIC-DB-OTHER OLAP function over union subselect may fail
MF62459 LIC-DB-OTHER IS NULL index advice ordering.
MF62435 LIC-DB-OTHER Internal Database Maintenance.
MF62419 LIC-DB-INCORROUT update with datapartitionname and smp
MF62416 LIC-DB-INCORROUT SMP Query with Ordering
MF62412 F/DBOPOPERATIONMISC-MSGMCH3203 F/DBOPOPERATIONMISC-MSGMCH320
MF62373 LIC-DB-PERFM Not using EVI Only Access
MF62368 LIC-DB-OTHER-PERFM IMPROVE PERFORMANCE OF COMPLEX SQL QUERIE
MF62365 LIC-DB-PERFM Optimization time with many nested subquery lev
MF62315 OSP-DB-OTHER-UNPRED RECORD NOT FOUND ON A PARTITIONED TABLE
MF62305 LIC-DB-PERFM SMP support for OLAP queries
MF62296 LIC-DB-OTHER-PERFM QRY/400 TAKES MORE TIME TO OPTIMIZE
MF62243 OSP-DB-OTHER-UNPRED TMPSTGLK SQE BUCKET 8 *DATABASE SEGMENT
MF62219 LIC-DB-OTHER Fixes error caused by null ordering on DENSE_RA
MF62198 LIC-DB-OTHER-F/DBOPEXPRQDS-T/QQQOOODBOP-MSGMCH3601 SQL SELEC
MF62195 LIC-DB-OTHER-INCORROUT WRKQRY OUTPUT IS NOT IN THE SPECIFIED
MF62122 LIC-DB-OTHER Optimizer support for PERCENTILE_CONT and PERCE
MF62117 OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
MF62117 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 WRONG SE
MF62078 LIC-DB Internal Maintenance
MF62077 LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 RUNNING COMPLI
MF62071 OSP-DB_OTHER FULL OUTER JOIN ESCAPING QUERY NORMALIZATION
MF62042 LIC-DB-MSGMCH3203 Partitioned table query with SMP and LPG
MF62021 LIC-DB-OTHER Internal Maintenance
MF62020 LIC-DB-OTHER-UNPRED Grouping set query fails with MCH3203 un
MF61856 OSP-DB-OTHER-INCORROUT INCORRECT RESULTS MAY OCCUR WITH REPL
MF61853 OSP-DB-OTHER-PERFM SLOW PERFORMANCE AFTER CUME JOIN OPTIMIZA
MF61853 OSP-DB-OTHER MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP
MF61853 OSP-INCORROUT WHEN FULL OUTER JOIN QUERY HAS SPECIFIC STRUCT
MF61725 LIC-DB PERFM LONG RUNNING SQL QUERY WITH EVI ACCESS.
MF61713 LIC-DB-OTHER Index advising for IS NULL predicates.
MF61692 LIC-DB-MSGMCH3203 OLAP Aggregate query
MF61684 LIC-DB Internal Database Maintenance
MF61646 LIC-DB-PERFM SMP with Grouping and UNION
MF61609 OSP-DB-OTHER-THREADS-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203
MF61609 OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT MAY OCCUR WITH A CRO
MF61583 LIC-DB-INCORROUT Scalar aggregate OLAP when arg is constant
MF61551 LIC-DB-INCORROUT Grouping query with OLAP
MF61506 LIC-DB-PERFM SQL Improve column elimination in union queries
MF61398 LIC-DB-PERFM Optimizer picking PTL scan over index probe pla
MF61375 LIC-DB-INCORROUT OLAPs with Different Partition By clauses
MF61334 LIC-DB Internal Maintenance
MF61217 OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3601 WHEN A D
MF61125 OSP-DB-OTHER-F/DBLISTHOME-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203
MF61125 F/QSQFETCH-MSGSQL0811-RCTYPE1 FROM SQL QUERY WITH FETCH FIRS
MF61125 LIC-DB-OTHER-F/QDBSIGEX-MSGCPF5149 MAY OCCUR WHEN USING USIN
MF61125 LIC-INCORROUT NTH_VALUE when used with other OLAP aggregates
MF61125 LIC-DB-OTHER-F/DBPMTRAPX/0958-T/QQQOOODBOP-RCX/1720-MSGMCH32
MF60929 LIC-DB-MSGMCH32303 Aggregate OLAP and Ordering
MF60929 LIC-DB-PERFM SQL EVI Only Access query optimization techniqu
MF60929 OSP-UNPRED WHEN USING SQE QUERY ENGINE DUPLICATE MTI'S MAY B
MF61588 LIC-DB-PERFM bad plan when running commit *ALL
MF61256 OSP-DB-OTHER-INCORROUT A SQL QUERY MAY SHOW A NULL FOR A COL
MF61211 LIC-DB-OTHER-PERFM SLOW PERFORMANCE ON A RECURSIVE COMMON TA
MF61148 LIC-PERFM-PAR-940XMISC Bad Query Plan
MF61063 LIC-DB-PERFM Union Queries
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770999
APAR Fixed.......................... View details for APAR MA46467
Superseded by:...................... View fix details for PTF MF71368
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C7283730
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, 2021, 2022, 2023 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.
Was this topic helpful?
Document Information
Modified date:
23 October 2023