IBM Support

MF52861 - OSP-DB-OTHER-INCORROUT SPARSE PREDICATE VALIDATION NOT HANDL

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT SPARSE PREDICATE VALIDATION NOT HANDL


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF50828   00/00    0000
PRE  5770999  710  MF51011   00/00    0000
PRE  5770999  710  MF50590   00/00    0000
CO   5770999  710  MF52862   00/00    0000
CO   5770999  710  MF52863   00/00    0000
CO   5770999  710  MF52864   00/00    0000
CO   5770999  710  MF52414   00/00    0000
CO   5770999  710  MF52415   00/00    0000
CO   5770999  710  MF51181   00/00    0000
CO   5770999  710  MF50843   00/00    0000
CO   5770999  710  MF47924   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

-----------------------------------------------
SQL incorrect output for sparse predicate validation not handled
correctly.

CORRECTION FOR APAR MA40794 :
-----------------------------
Some access plan specific to the use of sparse or select/omit
indexes are missing validation predicates.

CIRCUMVENTION FOR APAR MA40794 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF52802      LIC-DB-MSGMCH3601 SQL Materialized Query Table with Grouping
   MF52795      OSP-DB-OTHER-T/QQQOOODBOPX/-MSGMCH3203 SQL SELECT STMT FAILS
   MF52794      OSP-PAR-940XMISC PARTICULAR QUERY CAUSES HIGH PAGE FAULTING
   MF52752      OSP-DB-OTHER-F/DBOPRELATION-MSGMCH3601 INSERT STMT FAILS WIT
   MF52734      OSP-OTHER-PERFM LONG RUNNING QUERY
   MF52693      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL RCT
   MF52634      LIC-DB-OTHER-LOOP COMPLEX SQE QUERY LOOPS IN OPTIMIZATION
   MF52606      OSP-DB MCH3203 1720 F/ASSERT X/0004 T/QQQOOODBOP MODULE QQQO
   MF52509      LIC-DB-INCORROUT-UNPRED Update with Subquery not creating fu
   MF52509      LIC-DB-OTHER-PERFM SQE NOT MATCHING CONCAT DERIVED KEY INDEX
   MF52461      LIC-DB Connect By infrastructure
   MF52413      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52413      LIC-DB-INCORROUT NLSS specified on a UNION DISTINCT query
   MF49330      LIC-DB-OTHER-PERFM SQL STATEMENT WITH LEFT OUTER JOIN PERFOR
   MF52334      LIC-DB-MSGMCH3203 SQL FieldProcs and EVIs
   MF52313      OSP-DB-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 Distinct subquery wi
   MF52313      LIC-DB-OTHER-PERFM SQL JOIN SLOWER AFTER UPGRADE FROM R530 T
   MF52313      LIC-DB-PERFM FIX A PROBLEM IN COSTING RRN BITMAP PLANS
   MF52313      OSP-DB-OTHER-PERFM SQL RUNS LONGER WHEN HASHING IS EMPLOYED
   MF52306      LIC-DB-PERFM SQE AND UDF IN a VIEW CAUSING PERFORMANCE ISSUE
   MF52306      OSP-DB-OTHER-INCORROUT INCORROUT USING FULL OUTER JOIN WHEN
   MF52304      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52075      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0527 when ALWCPYDTA(*NO)
   MF51925      OSP-DB Select/Omit logical files with NULL capable fields
   MF51925      LIC DB - 0600 BADD LIC logs from removeIter
   MF51997      OSP-DB-OTHER-F/DBOPNODEX/01B6A8-MSGMCH3601 SELECT DISTINCT R
   MF51974      LIC-DB-MSGMCH3601 F/DBOPSTRATEGYRIOSPIN-MSGMCH3601 F/DBOPSTR
   MF51874      OSP-DB-OTHER-F/ASSRTX/0004-T/QQQOOODBOPX/4473-MSGMCH3203 RUN
   MF51874      LIC-DB-PERFM WITH LOB FIELD, JOB USES EXCESSIVE TEMP STORAGE
   MF51874      OSP-DB-OTHER-PERFM JOB PROCESSING LOB FIELD RAN SLOW, WITH H
   MF51874      OSP-OTHER-PERFM NULL CAPABLE YES FIELD COMPARED TO NOT NULL
   MF51861      OSP-DB-OTHER-INCORROUT LIKE PREDICATE with SORTSEQ INDEX
   MF51849      OSP-DB-OTHER-MSGCPD4364 MSGCPD4364 MSGSQL0243
   MF51578      LIC-DB-PERFM SQL Select with inner join on RRN performs poor
   MF51576      OSP-DB-MSGMCH3601 running T3 stress test for Deflated tables
   MF51401      LIC-DB-MSGMCH3203 when UDF in the grouping sets query
   MF51401      OSP-DB-OTHER-LOOP CREATE FUNCTION LOOPS
   MF51389      OSP-DB Deflated tables cannot use SMP parallelism
   MF51383      LIC-DB-PERFM SQE optimization performance
   MF50475      LIC-DB-INCORROUT Wrong result Count(*) over derived table of
   MF51185      OSP-DB Creation of SQL deflated table
   MF51114      OSP-OTHER-PERFM QUERY IS PERFORMING POORLY AND LOCKING MANY
   MF51114      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 MSGMCH3
   MF51090      LIC-DB-OTHER Internal Maintenance
   MF51064      OSP-DB-OTHER-F/DBPMTRAPX/05C8-T/QQQOOODBOP/QQQOOOINVX/4139-
   MF51042      LIC-DB-MSGMCH3203 JOIN Query using PTL Probe
   MF51042      LIC-DB-OTHER-PERFM SELECT OVER VIEW WITH UNION AND DISTINCT
   MF51042      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50973      LIC-DB-PERFM Not matching index between UTF8 and UTF16
   MF50956      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY USING HA
   MF50945      OSP-DB-OTHER-F/QQQOOODBOP-MSGMCH3601 FOR QUERY WITH ORDER BY
   MF50830      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 M
   MF50821      LIC-DB-OTHER MCH3601 DbopStrategyGrouping + 01FA1C
   MF50759      LIC-DB-OTHER-PERFM SQL SQE QUERY RUNS MUCH LONGER AFTER UPGR
   MF50651      LIC-DB-PERFM Poorly performing query
   MF50599      LIC-DB-PERFM SSD support during query optimization
   MF50498      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50498      LIC-DB-MSG3203 Assert from generateOperations__25DbopAccessP
   MF50498      LIC-DB-OTHER-PERFM QUERY RUNS FOR DAYS AND CONSUMES HIGH CPU
   MF50498      OSP-OTHER-PERFM QUERY USING A LOT OF CPU AFTER AN UPGRADE
   MF50498      LIC-DB-INCORROUT Cached Probe over COUNT(*) subselect may re
   MF50463      LIC-DB-PERFM Plans not switching to *ALLIO
   MF50365      LIC-DB-OTHER-PERFM LONG RUNNING JOIN QUERY AFTER GOING TO RE
   MF50365      LIC-DB-OTHER-PERFM QUERY DOES MORE I/O AT V6R1 AS COMPARED T
   MF50309      LIC-DB-MSGMCH3203 MSGMCH3203 SQL Materialized Query Table wi
   MF50174      LIC-DB-MSGMCH3203 assert on Grouping Set query
   MF50101      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RCX/4473-MSGMCH3203 QUERY
   MF49960      OSP-DB-OTHER-T/QQQOOODBOP--MSGMCH3203 RUNNING SQL SELECT WIT
   MF49960      LIC-DB-INCORROUT Subquery IS NULL returns wrong result
   MF49960      LIC-DB-OTHER LPG HIGHLIGHTING IS NOT WORKING CORRECTLY IN TH
   MF49960      OSP-DB SQL0802 F/QSQRUN2 T/QSQRUN2 HEX of Left Outer Join co
   MF49960      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49926      LIC-DB-PERFM Wrong EVI plan chosen
   MF49800      OSP-DB Performance enhancement for SQL MERGE statement
   MF49637      DB-LIC-MSGMCH3203  module DbpmTrap + 00001138 entry ENTRY  s
   MF49612      LIC-DB-PERFM Enable Create EVI with INCLUDE with SMP setting
   MF49554      LIC-DB-Other Improved Heap usage
   MF49554      LIC-DB-MSGMCH3203 from assert Complex Grouping query
   MF49554      LIC-DB-MSGMCH3203- Common Table Expression query Fails
   MF49530      LIC-DB-PERFM Optimizer not using S/O logical file when it sh
   MF49404      DB-LIC-INCORROUT Wrong results possible with Encoded Vector
   MF48894      LIC-DB Choose Non-Equal PTL Probe Predicate based on Selecti
   MF48626      LIC-DB-OTHER-PERFM QUERY RUNNING LONGER AT 610 WHEN THE LEFT
   MF48359      LIC-DB-MSGMCH3203 DbpmAttributeOperation + 00003D20
   MF49400      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49352      LIC-DB-OTHER-PERFM QUERY PERFORMANCE PROBLEM FOR COMPLEX JOI
   MF49181      OSP-DB-OTHER-PERFM INDEX ADVISOR RECOMMENDS AN EVI INDEX OVE
   MF49106      LIC-DB-MSGMCH3203 Query with ROLLUP in grouping clause fails
   MF49087      LIC DB MSGMCH3203 DbpmTrap sDspNodeRequired
   MF48971      LIC-DB SQL query runs very poorly after AQP plan replacement
   MF48910      LIC-DB-PERFM Allow MQTs and EVIs with INCLUDE to coexist
   MF48906      LIC-DB-PERFM ADD NEW ACCESS PLAN FOR DISTINCT QUERIES
   MF48789      OSP-DB-OTHER-INCORROUT UNPREDICTABLE SQL RESULT IS RETURNED
   MF48609      LIC DB MSGMCH3203 DbpmTrap sAttributeOperationRefreshFailed
   MF48573      OSP DB OTHER EVI INCLUDE and literal matching.
   MF48508      LIC-DB-INCORROUT Wrong results for query with XMLAGG express
   MF48494      LIC-DB-MSGMCH3601 SQL FAILURE FROM DBOP WHEN ATTEMPTING TO O
   MF48440      LIC DB MSG MCH3203 DbpmTrap sAttributeOperationRefreshFailed
   MF48355      LIC-DB-MSGMCH3203 SQL query with grouping set clause fails
   MF48348      OSP DB OTHER Partition tables and aggregate EVIs
   MF48163      OSP DB OTHER Incorrect output, XMLAgg with ordering, null gr
   MF48123      OSP DB OTHER Incorrect output multiple XMLAgg order bys
   MF48057      OSP-DB-OTHER Incorrect output multiple XMLAgg with order by
   MF48028      LIC-DB-MSGPOINTERNOTSET-F/DBOPSTRATEGYINDEXSELECTION
   MF48028      LIC-DB-OTHER-PERFM SQE QUERY PERFORMS WORSE WHEN A SPECIFIC
   MF47922      LIC-DB-MSGSQL0508 while running update query

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA40794
Superseded by:......................View fix details for PTF MF65429
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, 2018 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:
02 May 2011