IBM Support

MF65721 - OSP-PERFM SQL STATEMENT THAT HAS MULTIPLE UDF PREDICATES PER

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-PERFM SQL STATEMENT THAT HAS MULTIPLE UDF PREDICATES PER


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R2M0    MF58880   00/00    0000
CO   5770999  V7R2M0    MF65301   00/00    0000
CO   5770999  V7R2M0    MF65278   00/00    0000
CO   5770999  V7R2M0    MF65141   00/00    0000
CO   5770999  V7R2M0    MF65139   00/00    0000
CO   5770999  V7R2M0    MF64366   00/00    0000
CO   5770999  V7R2M0    MF64367   00/00    0000
CO   5770999  V7R2M0    MF64353   00/00    0000
CO   5770999  V7R2M0    MF61259   00/00    0000
CO   5770999  V7R2M0    MF59853   00/00    0000
CO   5770999  V7R2M0    MF58957   00/00    0000
DIST 5770SS1  V7R2M0    SI54318   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 is seeing poor performance from any of their queries
that call a UDF for multiple predicates.

CORRECTION FOR APAR MA47494 :
-----------------------------
Code will be added to take a deeper look at UDF predicate
optimization, specifically which predicates should be applied
first.

CIRCUMVENTION FOR APAR MA47494 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF65692      OSP-DB-OTHER-INCORROUT possible due to DIN RIO spinning inad
   MF65651      OSP-DB-OTHER-PERFM EVI INCLUDES
   MF65639      OSP-DB SQL FAILS WITH MSGMCH3203 T/QQQOOODBOP
   MF65607      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 MSGMCH32
   MF65536      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 RCAC TAB
   MF65524      OSP-OTHER-PERFM OPNQRYF ACCESS PLAN STARTED USING AN INDEX P
   MF65492      OSP-DB-OTHER-F/DBOPACCESSPLANQDSPOPULATE-T/QQQOOODBOP- MSGMC
   MF65439      OSP-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 SQL STATEMENT FAILS W
   MF65423      OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3203 SQL GENE
   MF65392      LIC-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 SQL FAIL
   MF65325      SQL-RUN-INCORROUT FETCH RELATIVE - RETURNS DUPLICATE ROWS -
   MF65359      OSP-OTHER-PERFM INDEX ADVISOR RECOMMENDING TOO MANY EVIS
   MF65302      LIC-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3203 RCAC
   MF65308      OSP-OTHER-PERFM COMPLEX JOIN QUERY PERFORMS POORLY
   MF65277      LIC-DB-OTHER-F/DBOPEXPRQDS-T/QQQOOODBOP-MSGMCH3203 MAY OCCUR
   MF65206      LIC-DB-OTHER-PERFM COMPLEX CONNECT BY QUERY RUNS POORLY AFTE
   MF65189      OSP-DB-OTHER-MSGSQL0913 WITH ISOLATION LEVEL UR *CHANGE WHEN
   MF65188      OSP-DB-OTHER-F/DBPMHASH-T/QDBGETMQO-MSGMCH3402 DRDA APPLICAT
   MF65177      OSP-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 MSGCPF9898 MSGCPF
   MF65153      LIC-DB-OTHER-PERFM REDUCE USE OF SPARSE MTIS WHEN THERE IS A
   MF65142      LIC-DB-OTHER Allow duplicate keys in JSON_OBJECT and JSON_OB
   MF65056      OSP-OTHER-PERFM COMPLEX JOIN QUERY PERFORMS POORLY
   MF65034      LIC-DB-OTHER MSGCPD4364 Temporary query member creation not
   MF64863      OSP-DB-OTHER-PERFM JOIN FAN-IN WASN'T RECOGNIZED IN SOME CAS
   MF64858      LIC-DB-OTHER Internal maintenance
   MF64825      OSP-DB-OTHER OPNQRYF WITH DIFFERENT KEYFLD AND GRPFLD PARAME
   MF64828      LIC-DB-OTHER-PERFM JOIN QUERY PERFORMANCE WITH SCROLLABLE CU
   MF64823      LIC-DB-OTHER Internal Maintenance
   MF64798      LIC-DB-INCORROUT OLAPs and GROUPing queries
   MF64798      LIC-DB-INCORROUT Grouping when SMP
   MF64794      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL W
   MF64787      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 MSGMCH32
   MF64729      LIC-DB-OTHER-PERFM QUERY OPTIMIZER CHOOSES SUB-OPTIMAL INDEX
   MF64707      OSP-DB-OTHER-F/DBOPOPERATIONMISC-T/QQQOOODBOP-MSGMCH3601 MSG
   MF64587      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   MF64587      LIC-DB-OTHER-INCORROUT Queries that use Bitmap Probe on part
   MF64587      LIC-DB-OTHER Update of partitioned table fails
   MF64656      LIC-DB-OTHER-INCORROUT Queries with complex aggregate functi
   MF64654      OSP-DB-OTHER-PERFM WHEN RCAC PERMISSIONS ARE ADDED TO A FILE
   MF64556      F/DBOPQUERY-MSGMCH3203 NATIVE QUERY USING TODAY CONSTANT STA
   MF64474      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 RUNNI
   MF64433      OSP-OTHER-PERFM QUERY PERFORMANCE
   MF64365      OSP-DB-OTHER-PERFM SQL
   MF64349      LIC-DB-OTHER Query with grouping sets and table function fai
   MF64347      LIC-DB-OTHER-INCORROUT Grouping queries over DecFloat column
   MF64347      LIC-DB-OTHER-INCORROUT LISTAGG, XMLAGG, JSON_ARRAYAGG may ha
   MF64321      OSP-DB-OTHER-SAP400-THREADS-INCORROUT SELECT STMT WITH '=' ,
   MF64260      LIC-DB-OTHER-F//DBPMNATIVEACCESS-T/QDBGETKY-MSGMCH1825 QUERY
   MF64260      LIC-DB-OTHER Redundant index advice on equal join predicates
   MF64094      LIC-DB-OTHER Internal Database Maintenance.
   MF64087      OSP-DB-OTHER-PERFM INEFFICIENT JOIN ORDER WHEN PREDICATES AR
   MF64051      OSP-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 QUERY FAILS WITH MSGM
   MF64039      LIC-DB Internal Maintenance
   MF63990      OSP-OTHER-PERFM OPTIMAL INDEX WAS COSTED HIGHER THEN A LESS
   MF63937      LIC-DB-OTHER VL0600BADD - ADDAFFINITYEXPRESSION QUERY FAILUR
   MF63836      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 UNION
   MF63813      LIC-DB-OTHER-INCORROUT QUERY FAILS TO RETURN EXPECTED RESULT
   MF63793      OSP-DB-OTHER-F/DBOPSTRATEGYNORMALIZATION-T/QQQOOODBOP- MSGMC
   MF63751      OSP-UNPRED QUERY ESTIMATED RUNTIME WITH XMLELEMENT FIELD SEL
   MF63626      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-RCFUNCTIONERRORX'17
   MF63552      LIC-DB-PERFM Not using EVI Only Access
   MF63546      OSP-DB-OTHER-F/DBOPAFFINITYX/68C4-T/QQQOOODBOPX4994-MSGMCH32
   MF63546      LIC-DB-MSGMCH3203 T/F QQQOOODBOP/DbopAffinity when using CUB
   MF63503      OSP-DB-OTHER-F/DBOPQUERY-T/QQQOOODBOPX/4994-MSGMCH3203 QRYDF
   MF63422      LIC-DB-OTHER-PERFM Optimization time improvements for comple
   MF63307      LIC-DB Internal Maintenance
   MF63284      LIC-DB-OTHER-PERFM LEFT OUTER JOIN QUERY PERFORMANCE
   MF63283      LIC-DB-OTHER-PERM Improve query performance by removing extr
   MF63209      LIC-DB-OTHER-PERFM LONG OPTIMIZATION OF COMPLEX QUERY WITH M
   MF63172      OSP-DB-OTHER-PERFM SLOW TABLE SCAN USED FOR SCROLL CURSOR WI
   MF63049      LIC-DB-OTHER-INCORROUT SQLRPGLE USING XML FAILS WITH SQLSTAT
   MF62899      LIC-DB Optimizer choosing index with 8k page size leads to p
   MF62881      LIC-DB-OTHER-PERFM IMPROVE PARTITION AVOIDANCE FOR JOIN
   MF62853      OSP-DB QUERY THAT REUSING A PLAN IS NOT UPDATING ALL PREDICA
   MF62829      LIC QUERY WITH TRANSITIVE JOIN NOT RETURNING THE CORRECT RES
   MF62801      LIC-DB Improve AQP's ability to re-optimize LPG plans
   MF62801      OSP-OTHER-PERFM JOIN QUERY PERFORMANCE
   MF58353      OSP MSGMCH3203 X/1720 F/UASSERT X/0004 T/ QQQOOODBOP MODULE
   MF62748      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   MF62742      OSP-DB-OTHER-F/DBPMTRAPX/09B8-T/DBQQQOOODBOPX/4963-MSGMCH320
   MF62648      F/QQQOOODBOP-MSGMCH3203 MCH3203 F/ QQQOOODBOP T/ QQQOOOINV
   MF62581      OSP-DBPARL-PERFM LIMITED PLAN CHOICE DUE TO JOIN ORDER RESUL
   MF62545      OSP-PERFM OPTIMIZER ENHANCEMENT TO MAKE THE CORRECT DECISION
   MF62486      LIC-DB-OTHER Index advising for IS NULL predicates.
   MF62447      F/OPTIMIZER-UDFINCORROUTAFTERCLEARINGPLANCACHE UDF INCORRECT
   MF62418      LIC-DB-OTHER Internal Database Maintenance.
   MF62420      LIC-DB-INCORROUT SMP Query with Ordering
   MF62411      F/DBOPOPERATIONMISC-MSGMCH3203 F/DBOPOPERATIONMISC-MSGMCH320
   MF62214      LIC-DB-OTHER Fixes error caused by null ordering on DENSE_RA
   MF62211      LIC-DB-OTHER-PERFM QRY/400 TAKES MORE TIME TO OPTIMIZE
   MF62156      LIC-DB-OTHER-INCORROUT QUERY/400 RETURNS TOO MANY ROWS IN SQ
   MF62114      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   MF62110      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 WRONG SE
   MF62086      LIC-DB-PERFM Index Read Ahead when no RIO node
   MF61675      LIC-DB-OTHER-INCORROUT WRKQRY OUTPUT IS NOT IN THE SPECIFIED
   MF62019      LIC-DB-OTHER-UNPRED Grouping set query fails with MCH3203 un
   MF61990      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 RUNNING COMPLI
   MF61984      OSP-DB_OTHER  FULL OUTER JOIN ESCAPING QUERY NORMALIZATION
   MF61934      LIC-DB-OTHER-PERFM DBPMSERVER TASKS DRIVING HIGH DISK LOAD F
   MF61921      LIC-DB Internal Maintenance
   MF61860      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY FAILS WI
   MF61751      LIC-DB-OTHER-PERFM POOR PERFORMING QUERY WHEN IMPLEMENTED WI
   MF61723      LIC-DB PERFM LONG RUNNING SQL QUERY WITH EVI ACCESS.
   MF61682      LIC-DB Internal Database Maintenance
   MF61669      LIC-DB-OTHER-INCORROUT Left outer join query returns wrong r
   MF61653      OSP-DB-OTHER-UNPRED TMPSTGLK SQE BUCKET 8 *DATABASE SEGMENT
   MF61570      LIC-DB-INCORROUT Grouping query with OLAP
   MF61504      LIC-DB-PERFM SQL Improve column elimination in union queries
   MF61501      OSP-INCORROUT WHEN FULL OUTER JOIN QUERY HAS SPECIFIC STRUCT
   MF61419      OSP-DB-OTHER-THREADS-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203
   MF61331      LIC-DB-MSGMCH3203 DbstMdDadDataSpaceConcrete
   MF61307      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT MAY OCCUR WITH A CRO
   MF61264      LIC-DB-PERFM - EAO with Partitioned Tables
   MF61234      OSP-DB-OTHER-PERFM SLOW PERFORMANCE AFTER CUME JOIN OPTIMIZA
   MF61234      OSP-PERFM JOIN QUERY INTERMITTENTLY PERFORMS POORLY DUE TO T
   MF61213      OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3601 WHEN A D
   MF61206      OSP-DB MSGMCH3601 F/DBPMFORMAT T/QQQOOODBOP VL0600 BADD
   MF61199      OSP-DB-OTHER-INCORROUT INCORRECT RESULTS MAY OCCUR WITH REPL
   MF61191      LIC-DB-OTHER-PERFM SLOW PERFORMANCE ON A RECURSIVE COMMON TA
   MF61142      LIC-PERFM-PAR-940XMISC Bad Query Plan
   MF61089      OSP-DB-OTHER MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP
   MF61079      OSP-DB-OTHER-INCORROUT A SQL QUERY MAY SHOW A NULL FOR A COL
   MF61055      OSP-DB-OTHER-F/DBLISTHOME-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203
   MF60943      LIC-DB-PERFM Union Queries
   MF60888      LIC-DB Internal maintenance
   MF60821      OSP-UNPRED WHEN USING SQE QUERY ENGINE DUPLICATE MTI'S MAY B
   MF60785      OSP-OTHER-PERFM LONG OPTIMIZATION TIME DUE TO NUMEROUS UDFS/
   MF60776      OSP-PAR-940XBASE ALLOW REMOVAL OF NON-SHAREABLE MTIS IN A MO
   MF60761      LIC-DB-PERFM SQL EVI Only Access query optimization techniqu
   MF60748      LIC-DB-INCORROUT SMP XML INCORRECT OUTPUT AFTER UPGRADE
   MF60741      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60736      LIC-DB-OTHER-F/DBPMTRAPX/0958-T/QQQOOODBOP-RCX/1720-MSGMCH32
   MF60712      F/QSQFETCH-MSGSQL0811-RCTYPE1 FROM SQL QUERY WITH FETCH FIRS
   MF60697      OSP-DB-OTHER-UNPRED A SQLSTATE 01003 (SQLCODE 000) MAY OCCUR
   MF60696      F/QQQOOODBOP-MSGMCH3203-RCX'1720'-MOD/QQQOOOINV- OPCS/CALLDB
   MF60692      OSP-MSGMCH3203-D/TQQQOOODBOP-PAR QUERY WITH COMMON TABLE EXP
   MF57962      OSP-DB-OTHER-T/CALLDBMAINTFOROPENOROPTIMIZE-MSGMCH3203 IN SE
   MF57962      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOOUPCL-MSGMCH3203 SQL SELECT F
   MF60655      LIC-DB-OTHER-PERFM SQL WITH DISTINCT AND UNION PERFORMS POOR
   MF06008      OSP-DB-OTHER-F/DBPMFORMAT-T/QDBGETMQO-MSGMCH3203 A MSGMCH320
   MF60550      LIC-DB-OTHER-PERFM QUERY WITH OLAP FUNCTIONS AND DATA SKEW M
   MF60453      OSP-PERFM JOIN QUERY PERFORMS POORLY DUE TO FIRST N ROWS (FN
   MF60451      LIC-DB-OTHER-F/QDBSIGEX-MSGCPF5149 MAY OCCUR WHEN USING USIN
   MF60439      SQL-RUN THE NEW OPTIMIZER USES DIFFERENT TECNIQUES TO LOCK T
   MF60433      OSP-DB-OTHER-WAIT FILEORD COLUMN WOULD AFFECT THE ORDERING O
   MF60354      F/ASSERT-MSGMCH3203-MOD/QQQOOODBOP QUERY WITH AGGREGATE FAIL
   MF60299      OSP-DB-OTHER-INCORROUT A SELECT STMT RETURNS THE WRONG RESUL
   MF60254      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 A MCHMSG3203 MAY OCCUR
   MF60251      OSP-OTHER-PERFM SUBOPTIMAL INDEXES BEING CHOSEN CAUSING POOR
   MF60224      OSP-DB-OTHER-F/DBOPRELINDEX-T/QQQOOODBOP-MSGMCH3203 OPNQRYF
   MF60169      OSP-PAR-940XMISC QUERY RUNS LONGER AFTER R720 UPGRADE. OPTIM
   MF60119      OSP-DB-OTHER-PERFM INDEX NOT USED, LPG
   MF60058      LIC-DB-PERFM SQL Enable Index Merge Ordering query optimizat
   MF60034      LIC-DB-OTHER-INCORROUT OLAP ORDER BY ASC NULLS FIRST WITH NU
   MF59993      LIC-DB-OTHER-PERFM IMPROVE SQL PLAN VALIDATION
   MF59985      OSP-PAR-940XMISC LARGE IN LISTS HANDLED DIFFERENT AT 720 COM
   MF59976      LIC-DB-INCORROUT LIKE predicate on a VARCHAR column
   MF59976      LIC-DB-INCORROUT SMP and Subquery
   MF59891      LIC-DB-OTHER Internal maintenance
   MF59880      OSP-DB QUERY WITH TIME/TIMESTAMP FUNCTIONS IS FAILING WITH M
   MF59855      LIC-DB-UNPRED Ensure order of partitions in partitioned tabl
   MF59846      OSP-DB-OTHER-F/DBOPQUERY-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203
   MF59841      LIC-MSGMCH3203 OPTIMIZING QUERY WITH CONSTANT SUBSTITUTION I
   MF59830      OSP-DB-OTHER-PERFM WHEN RUNNING A QUERY AGAINST A FILE WITH
   MF59821      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 WHEN USING AN
   MF59820      OSP MCH3203 FUNCTION CHECK WHEN QUERY PROCESSED BY OPTIMIZER
   MF59820      OSP-DB-OTHER-MSGMCH3203 A MSGMCH3203 MAY OCCUR WITH A DELETE
   MF59765      LIC-DB-PERFM IN list query
   MF59727      LIC-DB-PERFM not using sparse index
   MF59627      OSP-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3601 QUERY
   MF59585      LIC-DB-OTHER-INCORROUT UDFS WITHIN RCAC PERMISSIONS
   MF59573      LIC-DB-OTHER-UNPRED Query fails when VALUES clause reference
   MF59553      LIC-DB-PERFM Enable Index Merge Ordering
   MF59526      LIC-DB-PERFM not using best index when multiple not equal pr
   MF58248      OSP-PERFM PERFORMANCE PROBLEMS WITH UNION QUERY USING DISTIN
   MF59463      LIC-DB-OTHER-INCORROUT SCALAR FUNCTION RAND()
   MF59463      LIC-DB-OTHER-PERFM DISTINCT QUERY TAKES TWICE AS LONG AFTER
   MF59463      LIC-DB-OTHER-INCORROUT SCALAR FUNCTION RAND()
   MF59363      LIC-DB-OTHER-PERFM LEFT EXCEPTION JOIN QUERY PERFORMS POORLY
   MF59341      LIC-DB-OTHER-UNPRED QUERY WITH FAILING WITH MCHMCH3203 T/QQQ
   MF59302      OSP-PERFM LONGER RUNNING QUERY WHEN IN LIST IS LARGER THAN E
   MF59244      LIC-DB-OTHER-PERFM HIGHER CPU CONSUMPTION FOR QUERY AFTER AP
   MF59244      LIC-PERFM SQL PERFORMANCE ISSUES INVOLVING ORDERING PLANS
   MF59137      LIC-DB-OTHER-PERFM RECURSIVE QUERY CONNECT BY PERFORMANCE FO
   MF59121      LIC-DB-OTHER-UNPRED QUERY WITH OLAP FUNCTION FAILING AFTER U
   MF59094      LIC-DB-OTHER-PERFM UPDATE STATEMENT INTERMITTENTLY PERFORMS
   MF59094      LIC-DB-OTHER-PERFM QUERY OPTIMIZER IMPROVEMENTS TO COSTING.
   MF58954      LIC-DB-OTHER Internal Maintenance
   MF58859      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT IMPLEMENT VIA AN
   MF58842      LIC-DB-OTHER-F/QDBGETM-T/DBPMNATIVEACCESS-MSGMCH1825 ON A _R
   MF58812      OSP-DB-OTHER-UNPRED 0600DEAD VLOGS ARE GENERATED WHEN RUNNIN
   MF58812      LIC-DB-OTHER-PERFM SMP IMPLEMENTATION LEADS TO POOR SQL QUER
   MF58787      LIC-DB-OTHER QRY/400 fails with selection and ordering on co
   MF58771      OSP-DB-OTHER-PERFM CALLDBMAINTFOROPENOROPTIMIZE
   MF58752      OSP-DB-OTHER-INCORROUT NO RECORDS RETURNED FROM PARTITIONED
   MF58680      LIC-DB-OTHER-PERFM OPTIMIZER SELECTS TABLE SCAN RATHER THAN
   MF58544      LIC-DB-OTHER-PERFM VIEW CONTAINING SELECT LIST UDFS ALSO USE
   MF58476      LIC-DB-PERFM not using ICU index
   MF58380      LIC-DB-MSGMCH3203 CONNECT BY when running SMP
   MF58336      OSP-PERFM GROUPING QRY OVER SINGLE TABLE RUNS LONG WITH PLAN
   MF58333      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF503E MSGSQL0502-F/
   MF58330      LIC-DB-MSGMCH3203 during UPDATE statement
   MF58330      LIC-DB-INCORROUT DELETE under commit with subquery
   MF58247      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT USE ALL AVAILABL
   MF58228      LIC-DB-PERFM Internal Maintenance
   MF58191      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC6-MSGSQL0952 MSGSQL0952 F
   MF58174      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SQL MCH3203 QQ
   MF58140      LIC-DB-OTHER-PERFM AN INSERT STATEMENT WITH A SUBSELECT OVER
   MF58140      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0243 A MSGSQL0243 MAY OCCUR WIT
   MF58140      OSP-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/DBPMTRAP
   MF58140      OSP-DB SQL STATEMENT THAT USES HIERARCHICAL RECURSION FAILS
   MF58132      LIC-DB-MSGMCH3203 Delete from a Partitioned Table
   MF58130      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203
   MF58064      LIC-DB-MSGMCH3203 Max query and SMP
   MF57977      OSP-PERFM SPARSE MTI CHOSEN OVER PERMANENT INDEX RESULTING I
   MF57975      LIC-DB-OTHER-PERFM A COMPLEX QUERY PERFORMS POORLY.
   MF57975      OSP-DB-OTHER-T/QQQOOODBOP-RC1720-MSGMCH3203 WITH A LEFT OUTE
   MF57947      LIC-DB Internal Maintenance
   MF57932      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SELECT * FROM
   MF57920      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 SQL TRAPS IN
   MF57773      LIC-DB Internal Maintenance
   MF57704      LIC-DB-MSGMCH3203 Grouping Sets
   MF57622      LIC-DB Internal Maintenance
   MF57805      LIC-DB Internal Maintenance
   MF59425      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY FUNCTION
   MF58151      LIC-DB Internal Maintenance

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA47494
Superseded by:......................View fix details for PTF MF68917
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C9297720


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

Document Information

Modified date:
01 October 2021