IBM Support

MF53478 - LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF53476   00/00    0000
CO   5770999  710  MF52413   00/00    0000
CO   5770999  710  MF51181   00/00    0000
CO   5770999  710  MF49402   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

-----------------------------------------------
Add a new QAQQINI option

PSEUDO_OPEN_CHECK_HOST_VARS

Indicates if host variable selectivity should be checked at
pseudo-open time for certain queries that do not use default
values for selectivity checks.  If the host variable selectivity
changes enough, the query will be hard-closed and the query will
be re-optimized with the new host variable values.   The option
setting in effect at the time of the full-open is the one that
is used. If REOPTIMIZE_ACCESS_PLAN QAQQINI option is set to
*ONLY_REQUIRED, the PSEUDO_OPEN_CHECK_HOST_VARS option has no
effect.

Supported values:
- *DEFAULT - Default Value is *NO
- *NO - Do not check host variable selectivity at Pseudo-open
time.  This is compatible with previous behavior.
- *OPTIMIZE - Let the Optimizer determine when host variable
selectivity should be checked. In general, the SQE engine will
monitor the query and if after a certain number runs it
determines that there is no advantage to checking host variable
values, ie the selectivity is not changing enough, the optimizer
will stop checking for host variable selectivity changes at
pseudo-open time.   Full-opens will do the normal plan
validation.
- *YES Always check host variable selectivity at Pseudo-open
time for eligible queries.

CORRECTION FOR APAR MA40353 :
-----------------------------
Support is added for PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option.

CIRCUMVENTION FOR APAR MA40353 :
--------------------------------
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
--------------  ------------------------------------------------------------
   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 MA40353
Superseded by:......................View fix details for PTF MF63587
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1270710


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.

[{"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":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 August 2011