PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
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 |
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.
Was this topic helpful?
Document Information
Modified date:
07 June 2017