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