IBM Support

MF69348 - OSP-MSGMCH3402-D/TQQQSVRTN USING IFS_OBJECT_STATISTICS OVER

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-MSGMCH3402-D/TQQQSVRTN USING IFS_OBJECT_STATISTICS OVER


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770999  V7R4M0    MF69235   00/00    0000
CO   5770999  V7R4M0    MF69234   00/00    0000
CO   5770999  V7R4M0    MF69046   00/00    0000
CO   5770999  V7R4M0    MF69048   00/00    0000
CO   5770999  V7R4M0    MF68868   00/00    0000
CO   5770999  V7R4M0    MF68421   00/00    0000
CO   5770999  V7R4M0    MF67495   00/00    0000
CO   5770999  V7R4M0    MF67496   00/00    0000
CO   5770999  V7R4M0    MF66572   00/00    0000
CO   5770999  V7R4M0    MF67051   00/00    0000
CO   5770999  V7R4M0    MF67052   00/00    0000
CO   5770999  V7R4M0    MF67055   00/00    0000
DIST 5770SS1  V7R4M0    SI78387   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

-----------------------------------------------
When processing query using IFS_OBJECT_STATISTICS, the SQE
optimizer calls up to the OS with LOB storage that has been
destroyed, resulting in MCH3402 in the called code. The
optimizer needs to ensure that this storage does not get cleared
when performing the call to the OS.

CORRECTION FOR APAR MA48808 :
-----------------------------
The SQE optimizer will inform XPF that, for this query, the XPF
created LOB buffer should not be reset until query close.


CIRCUMVENTION FOR APAR MA48808 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF69231      LIC-DB-OTHER Add common table expression information to Data
   MF69045      LIC-DB-OTHER Improve estimated record count for SQE OPNQRYF
   MF69018      OSP-OTHER-PERFM SELECT INTO QUERY IS SOMETIMES TAKING MULTIP
   MF68959      LIC-DB-OTHER SQE Total Temporary Storage only set when query
   MF68869      SLIC-DB INFRASTRUCTURE
   MF68836      OSP-OTHER-PERFM A COMPLEX QUERY WAS TAKING SEVERAL MINUTES T
   MF68811      INTERNAL DATABASE MAINTENANCE
   MF67550      OSP-OTHER-PERFM SQL QUERY WAITING ON A SEIZE
   MF68796      LIC-DB-OTHER New VLOG 0600 BADE if SQE plan too large to sav
   MF68790      OSP-SRCB6000336-INCORROUT SYSTEM TERMINATED WITH SRC B600033
   MF68589      LIC-DB-OTHER Internal database maintenance
   MF68553      LIC-DB-OTHER Internal maintenance
   MF68551      OSP-OTHER-PERFM PSEUDO-OPEN QUERY PERFORMS POORLY DUE TO RE-
   MF68490      LIC-DB-OTHER Internal maintenance
   MF68447      LIC-DB-OTHER Internal maintenance
   MF68423      LIC-DB-OTHER Internal maintenance
   MF68290      LIC-DB-OTHER-PERFM Fix SELECTIVITY for Various Plans
   MF68278      LIC-DB-OTHER Internal Maintenance
   MF66209      LIC-DB-OTHER Visual Explain using wrong decimal point
   MF68205      SQL-RUN-INCORROUT AQP INTERMITTENT - CURRENT REGISTER DATE R
   MF68165      OSP-OTHER-INCORROUT COLLECTION SERVICE DATA REPORTING INCORR
   MF67935      LIC-DB-OTHER Fix problem with targeted tracing and AQP withi
   MF67555      LIC-DB-OTHER Fix problem with targeted tracing and AQP withi
   MF67497      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67187      LIC-DB-OTHER Serviceability enhancements
   MF67150      OSP-DB-OTHER-SRCB6005121-UNPRED SRCB6005121 - COMPLEX QUERY
   MF67150      LIC-DB-OTHER Improve SQE plan cache storage clean up
   MF67053      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67099      LIC-DB-OTHER Internal Maintenance
   MF67099      LIC-DB-OTHER Add Longest Run and Current Run Host variables
   MF66062      LIC-DB-OTHER-UNPRED CLIENT FOUND LOTS OF 0600BADA VLOGS GENE
   MF67071      OSP-DB-OTHER  specify in SQE DBOP trace when MTI exists vs a
   MF66758      LIC-DB-OTHER Internal Maintenance
   MF66571      OSP-DB-OTHER-MSGSQL0901 AFTER PTFS INSTALLED, JOB STARTED TO
   MF66525      OSP PERIODICALLY A SQL STATEMENT RUNS LONG.

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R4M0
Licensed Program....................  5770999
APAR Fixed..........................  View details for APAR MA48808
Superseded by:......................  View fix details for PTF MF70417
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C2125740


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, 2022 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.4.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770999","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
29 November 2022