PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
LIC-PERFM DBOPAQCM/findLowerLeftNode looping starting the CP
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770999 710 MF49782 00/00 0000
CO 5770999 710 MF52180 00/00 0000
CO 5770999 710 MF51181 00/00 0000
CO 5770999 710 MF50464 00/00 0000
CO 5770999 710 MF49909 00/00 0000
CO 5770999 710 MF49211 00/00 0000
CO 5770999 710 MF48977 00/00 0000
CO 5770999 710 MF48569 00/00 0000
CO 5770999 710 MF48357 00/00 0000
CO 5770999 710 MF47998 00/00 0000
CO 5770999 710 MF50498 00/00 0000
DIST 5770SS1 710 SI37397 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
-----------------------------------------------
Loop in DbopAQPCommon::findLowerLeftNode when querying a LF with
more than 2 members.
CORRECTION FOR APAR MA40505 :
-----------------------------
The SQE optimizer was incorrectly handling the query trees when
LFs had more than 2 members and it was a long running query.
The problem has been corrected.
CIRCUMVENTION FOR APAR MA40505 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF52183 LIC-DB-OTHER Internal Maintenance
MF51929 LIC DB - 0600 BADD LIC logs from removeIter
MF51380 LIC-DB-PERFM SQE optimization performance
MF50491 OSP-DB-PERFM Not using MQT when MQT matches query selection
MF51322 LIC-DB-OTHER-PERFM SQE performance improvements
MF51189 OSP-DB Creation of SQL deflated table
MF49927 LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
MF48571 OSP-OTHER-PERFM DUPLICATE TRANSLATE TABLES
MF50862 LIC-DB-OTHER Internal maintenance
MF50650 OSP-DB Visual Explain showing incorrect host variable values
MF50649 OSP-DB Visual Explain showing incorrect host variable values
MF50462 LIC-DB-OTHER Plan Cache Dump not showing the correct pool in
MF49991 LIC-DB Generating DbopTrace on MSGMCH6260
MF49959 LIC-DB-OTHER LPG HIGHLIGHTING IS NOT WORKING CORRECTLY IN TH
MF49911 LIC-DB-INCORROUT Correctly transfer translate table storage
MF49798 OSP-DB Performance enhancement for SQL MERGE statement
MF49766 LIC-DB Array fixes
MF49636 LIC-DB-INCORROUT Graphic values in the DBMON 3010 record
MF48338 LIC-DB Not deallocating storage
MF49611 DB-LIC-PERFM Enable CREATE EVI with INCLUDE with SMP settin
MF49529 LIC-DB-PERFM STRDBMON missing QQQ3010 record and BADD vlog
MF49417 LIC-DB-OTHER Update Detailed Plan Cache Dump
MF49397 DB-LIC-INCORROUT Wrong results possible with Encoded Vector
MF49346 LIC-DB-PERFM REDUCE PAGE FAULTING DURING SQL PLAN VALIDATION
MF49346 LIC-DB-OTHER INDEX ADVISE INFRASTRUCTURE CHANGE
MF49346 LIC-DB-OTHER SQL OPTIMIZER TRACING IMPROVEMENTS
MF49341 LIC-DB 0600 BADA VLOGs generated while running SQL queries
MF49158 OSP-DB Array fixes
MF49112 LIC-DB-INCORROUT Missing decFloat values in DBMON 3010 recor
MF49037 LIC-DB SQL query performs poorly
MF48981 OSP-DB-OTHER-PERFM SQL STATEMENTS PERFORM WORSE AT R610 OVER
MF48970 LIC-DB-SQL query runs very poorly after AQP plan replacement
MF47999 LIC DB DBST Static Variable Cleanup
MF48909 LIC DB PERFM Allow MQTs and EVIs with INCLUDE to coexist.
MF48793 OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 COMPLEX
MF48753 LIC-DB Visual Explain of plan contains value of 'UNKNOWN' fo
MF48753 LIC-DB Beam fix for NULL class pointer
MF48622 OSP DB OTHER EVI Include and aggregation rounding mode
MF48567 LIC-DB SQL query does not complete.
MF48567 OSP-DB-OTHER-PERFM NEW QAQQINI OPTION, DETERMINISTIC_UDF_SCO
MF48424 LIC-DB VLOG contains many VLOGs with major code 0600, minor
MF48354 LIC-DB Numerous Database VLOGs, major code 0600, minor code
MF48030 LIC-DB-MSG3203 SQL query with grouping sets clause fails
MF48125 LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 AND TEMP STORA
MF47919 LIC-DB Too many DataBase Monitor Records
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770999 |
APAR Fixed.......................... | View details for APAR MA40505 |
Superseded by:...................... | View fix details for PTF MF64909 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C1116710 |
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 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 September 2021