IBM Support

MF63587 - OSP-DB-OTHER-INCORROUT DUMP OF PLAN CACHE SHOWS INCORRECT OU

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT DUMP OF PLAN CACHE SHOWS INCORRECT OU


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF61755   00/00    0000
CO   5770999  710  MF63586   00/00    0000
CO   5770999  710  MF63005   00/00    0000
CO   5770999  710  MF59650   00/00    0000
CO   5770999  710  MF58650   00/00    0000
CO   5770999  710  MF58421   00/00    0000
CO   5770999  710  MF56412   00/00    0000
CO   5770999  710  MF55899   00/00    0000
DIST 5770SS1  710  SI40214   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

-----------------------------------------------
Customer uses Plan Cache to analyze query performance issues.
Using iNav, He specifies the filter to obtain information from a
certain range of time and date. The query output shows
information from a smaller period of time than the requested
one.

CORRECTION FOR APAR MA46372 :
-----------------------------
Open cursors sporadically report run time statistics back to the
plan cache to avoid performance concerns with plan cache
accesses. This can cause plans to appear to not have ran in a
given time frame for a filtered plan cache snapshot when they
actually have ran. The plan cache snapshot tooling will be
modified to acquire a more accurate last run time stamp for a
given plan.

CIRCUMVENTION FOR APAR MA46372 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF62991      LIC-DB-OTHER-INCORRECT INAVIGATOR PLAN CACHE ANALYSIS OF ACC
   MF61871      LIC-DB-UNPRED 0600 BADD vlogs during Plan cache snapshot
   MF61776      LIC-DB-OTHER Add key range estimate information to database
   MF61248      LIC-DB-OTHER-INCORROUT ON SQL PLAN CACHE SNAPSHOT SHOW STATE
   MF60587      LIC-DB Internal maintenance
   MF59656      LIC-DB-UNPRED Ensure order of partitions in partitioned tabl
   MF58720      LIC-DB-OTHER Internal Maintenance
   MF58649      LIC-DB-OTHER Internal maintenance
   MF58422      OSP-DB SOME FUNCTIONS IN VISUAL EXPLAIN MAY FAIL IF AN INDEX
   MF58412      OSP-DB-OTHER-INCORROUT DIFFERENCES BETWEEN CCSID 65535 AND 5
   MF57718      OSP-DB-Other Enable additional Plan Cache Properties and opt
   MF57713      OSP-DB-OTHER-INCORROUT VISUAL EXPLAIN FAILS WITH "NO EXPLAIN
   MF57521      OSP-DB-OTHER-MSGCPF5035 CPF5035 WHEN DUMPING PLAN CACHE SNAP
   MF57341      OSP-INCORROUT VISUAL EXPLAIN 3 OF TIMESTAMPS ARE INCORRECT.
   MF56605      LIC-DB-OTHER-F/QQQDBLOG-T/QQQSRVE1-MSGCPD4382 MAY OCCUR WHEN
   MF56591      SQL-DB-PERFM Index advice for ORed predicates
   MF56411      LIC-DB-PERFM Add job scoping information to SQE Plan Cache
   MF56037      OSP-INCORROUT OSP INCORROUT PLANCACHE POOLID
   MF55901      OSP-DB-Visual Explain diagram with disconnected icons
   MF55769      OSP-DB Visual Explain, Not able to explain a query access pl
   MF55436      LIC-DB-OTHER-PERFM SUPPORT PLAN CACHE AUTOSIZING
   MF54893      LIC-DB-OTHER SQE Optimizer support for Workload Group
   MF54777      LIC-DB-OTHER IMPROVE DBMON PERFORMANCE
   MF54026      OSP-DB Database Monitor field QQKS not set correctly for spa
   MF53921      OSP-DB Database Monitor host variable value of Infinity
   MF53589      OSP-DB Internal Maintenance for Database Monitor
   MF53478      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   MF52463      LIC-DB Connect By infrastructure
   MF52415      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF51187      OSP-DB Creation of SQL deflated table
   MF50864      LIC-DB-OTHER Internal maintenance
   MF50492      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF49952      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49403      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49211      LIC-DB Array fixes
   MF49054      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3402 SELECT STMT IN A QZASOI
   MF48358      LIC-DB MSGMCH3203
   MF47925      OSP-DB Field QFC11 not set correctly for QQQ1000 monitor rec

Summary Information

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


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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 June 2017