IBM Support

MF52251 - LIC-PERFM DBOPAQCM/findLowerLeftNode looping starting the CP

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 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, 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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770999","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
23 September 2021