IBM Support

MF55986 - OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 F

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 F


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF55844   00/00    0000
PRE  5770999  710  MF55643   00/00    0000
PRE  5770999  710  MF54225   00/00    0000
CO   5770999  710  MF55987   00/00    0000
CO   5770999  710  MF55943   00/00    0000
CO   5770999  710  MF55849   00/00    0000
CO   5770999  710  MF55856   00/00    0000
CO   5770999  710  MF55835   00/00    0000
CO   5770999  710  MF54893   00/00    0000
CO   5770999  710  MF51399   00/00    0000
CO   5770999  710  MF48118   00/00    0000
DIST 5770SS1  710  SI45826   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

-----------------------------------------------
A msgMCH3203 F/ASSERT-T/QQQOOODBOP may occur with a query where
a SELECT/OMIT logical file is used for implementation with a
maintained temporary index (MTI)

CORRECTION FOR APAR MA42264 :
-----------------------------
Failure building plan after choosing to use a select/omit
logical file to populate an MTI.  Index is incorrectly removed
from consideration in post-optimization code attempting to
construct MTI, resulting in the failure/VLOG.

CIRCUMVENTION FOR APAR MA42264 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF55979      OSP-DB-OTHER QQQOOODBOP MSGMCH3402 Assert XMLTABLE
   MF55944      LIC-DB-PERFM Performance Problems when DBMON active
   MF55868      LIC-DB-PERFM Overflow condition on EVI with INCLUDE over tab
   MF55854      LIC-DB-OTHER-INCORROUT Grouping set queries with concatenati
   MF55836      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55768      OSP-DB Visual Explain, Not able to explain a query access pl
   MF55720      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 COMPLEX SQL QU
   MF55669      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT ON QUERY WITH COMMON
   MF55652      OSP-OTHER-PERFM QUERY PERFORMANCE. LONG OPTIMIZATION TIME. P
   MF55498      LIC-DB-UNPRED Using LOBs as input to UDTF
   MF55413      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF55265      LIC-DB-OTHER not revalidating on Workload Group changes
   MF55248      LIC-DB Internal maintenance
   MF55142      LIC-DB-PERFM Table Probe IO Costing when secondary in a join
   MF54942      LIC-DB-OTHER Wrong host variables in VE diagram when PSEUDO_
   MF54892      LIC-DB-OTHER SQE Optimizer support for Workload Group
   MF54722      LIC-DB-OTHER Internal Maintenance
   MF54687      OSP-DBPARL-UNPRED QSQSRVR QSQDBXXXXXX SPACE OBJECTS USING TE
   MF54675      OSP-DB Incorrout with Col1 Is Null OR Col1 Is Not Null
   MF54667      OSP-DB-OTHER-F/ASSERTX/004-T/QQQOOODBOPX/4474-RCX1720- MSGMC
   MF54609      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 SQL UPDATE of MULTI-DS
   MF54387      OSP-DB Perform key selection for LIKE predicate with leading
   MF54330      PERFM-LIC FILTERING BY STATEMENT TEXT ON INAV 'SHOW STATEMEN
   MF54298      LIC-DB-PERFM Remove unnecessary Preload of QDS objects
   MF54293      LIC-DB-INCORROUT XML NULL on NULL
   MF54293      LIC-DB-MSGMCH3203 Common Table expression reference in subqu
   MF54009      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53809      LIC-DB Internal maintenance
   MF53742      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY OVER A F
   MF53718      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53591      OSP-DB Internal Maintenance for Database Monitor
   MF53479      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   MF53479      LIC-DB-OTHER Translated Keys not showing up as translated on
   MF53479      LIC-DB-MSGSQL0901 Fetching numeric with precision 63
   MF53445      OSP-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/ASSE
   MF53227      OSP-DB-OTHER-LOOP AFTER UPGRADING TO R710, A QUERY WITH NEST
   MF53338      OSP-OTHER-PERFM QUERY PERFORMANCE WITH PARTITIONED TABLES
   MF53338      LIC-PERFM CAST(CHAR as TIMESTAMP) index not being used
   MF53163      LIC-DB-OTHER-MSGCPF5035 UPDATE WITH WHERE CLAUSE FAILS WITH
   MF53099      OSP-DB-OTHER-INCORROUT A FIELDPROC MAY SHOW CACHED RESULTS I
   MF53060      OSP-OTHER-PERFM PERFORMANCE DIFFERENCE BETWEEN LEFT AND SUBS
   MF52507      OSP-DB-OTHER-UNPRED SQL ROQ SIZES TOO LARGE AND BEING CACHED
   MF52507      LIC-DB-OTHER-PERFM SQE NOT MATCHING CONCAT DERIVED KEY INDEX
   MF52459      LIC-DB Connect By infrastructure
   MF52414      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52121      LIC-DB INDEX ADVISOR SUGGESTS AN INDEX OVER A 'NOTUSED' COLU
   MF51928      OSP-DB Select/Omit logical files with NULL capable fields
   MF51928      LIC DB - 0600 BADD LIC logs from removeIter
   MF51767      OSP-DB Select/Omit logical files with NULL capable fields
   MF51620      LIC-DB Database optimizer heap leak fix
   MF51436      OSP-DB-OTHER Enable in memory files for indexes
   MF51402      LIC-DB-PERFM SQL queries not honoring pre-load plans
   MF51402      LIC-DB-PERFM SQE optimization performance
   MF51402      OSP-DB-OTHER-LOOP CREATE FUNCTION LOOPS
   MF51402      LIC-DB-PERFM MQT not matching when DECFLOAT
   MF51402      OSP-DB-OTHER-PERFM SQE ONR COSTING TO LOW
   MF51183      OSP-DB Creation of SQL deflated table
   MF51089      LIC-DB-OTHER Internal Maintenance
   MF51043      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50983      LIC-DB-Other Add support for validating LF mappings
   MF50865      LIC-DB-OTHER Internal maintenance
   MF50596      LIC-DB-OTHER Internal Maintenance
   MF50493      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50493      LIC-DB-MSG3203 Assert from generateOperations__25DbopAccessP
   MF50464      LIC-DB-OTHER Plan Cache Dump not showing the correct pool in
   MF50311      LIC-DB-PERFM SQL Field Procedure Index only access
   MF50070      LIC-DB-MSGMCH3402 BADD Vlog DbVisualExplainStream + 000A34
   MF49962      OSP-DB SQL0802 F/QSQRUN2 T/QSQRUN2 HEX of Left Outer Join co
   MF49962      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49925      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49799      OSP-DB Performance enhancement for SQL MERGE statement
   MF49638      LIC-DB-INCORROUT SQL field procedure with cached DecFloat pa
   MF49553      LIC-DB-OTHER-PERFM QUERY WITH MANY VALUES IN AN IN PREDICATE
   MF49553      OSP-DB-OTHER-UNPRED MCH3203 FROM ASSERT TO QQQOOODBOP
   MF49553      LIC-DB-Other Improved Heap usage
   MF49402      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49392      LIC-DB-MSGMCH3203 SQL Array and XML Agg
   MF49216      INCORROUT XML encoding option wrong results
   MF49157      LIC-DB Array fixes
   MF48987      OSP-DB-OTHER-PERFM SQL STATEMENTS PERFORM WORSE AT R610 OVER
   MF48987      LIC-DB-MSGMCH3203 0200/1722 MODULE HmDerivedHeap when LOBs
   MF48911      LIC-DB-PERFM Allow MQTs and EVIs with INCLUDE to coexist
   MF48904      LIC-PERFM SQL Field Procedures
   MF48792      LIC-DB DBMonitor 3012 record Global Variable
   MF48792      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      lic-db-unpred System crash
   MF48458      LIC-DB MSGMCH3203 X/1720 F/ASSERT X/000004 T/QQQOOODBOP MODU
   MF48423      LIC-DB VLOG contains many VLOGs with major code 0600, minor
   MF48356      LIC-DB MSGMCH3203 Queries with Arrays fail
   MF48165      LIC-DB-MSGMCH3203 Function check when running Grouping set q
   MF48117      OSP DB OTHER Incorrect output multiple XMLAgg order bys
   MF48029      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL UPD
   MF47921      LIC-DB-MSGMCH3203 VLOG occurs when running a Grouping Sets q

Summary Information

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


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