IBM Support

MF60250 - OSP-OTHER-PERFM SUBOPTIMAL INDEXES BEING CHOSEN CAUSING POOR

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-OTHER-PERFM SUBOPTIMAL INDEXES BEING CHOSEN CAUSING POOR


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  MF60033   00/00    0000
CO   5770999  710  MF59789   00/00    0000
CO   5770999  710  MF59650   00/00    0000
CO   5770999  710  MF59295   00/00    0000
CO   5770999  710  MF56942   00/00    0000
CO   5770999  710  MF56581   00/00    0000
CO   5770999  710  MF55901   00/00    0000
CO   5770999  710  MF50843   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

-----------------------------------------------
After PTFs applied, some queries with non-equal predicates
started using a less then optimal index even though better
indexes exists. This resulted in poor performing access plans
been chosen.

CORRECTION FOR APAR MA44668 :
-----------------------------
An enhancement made to the optimizer to allow the consideration
of more indexes for non-equal predicates that might prove to
have additional selectivity benefits has been determined to be
too broad.  The optimizer is scaling that enhancement back.

CIRCUMVENTION FOR APAR MA44668 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF60052      LIC-DB Enable better I/O performance for left outer joins
   MF60032      LIC-DB-OTHER-INCORROUT OLAP ORDER BY ASC NULLS FIRST WITH NU
   MF60009      SQL-RUN THE NEW OPTIMIZER USES DIFFERENT TECNIQUES TO LOCK T
   MF59975      LIC-DB-INCORROUT LIKE predicate on a VARCHAR column
   MF59975      LIC-DB-INCORROUT SMP and Subquery
   MF59913      OSP-OTHER-PERFM LONG OPTIMIZATION TIME DUE TO NUMEROUS UDFS/
   MF59829      OSP-DB-OTHER-PERFM WHEN RUNNING A QUERY AGAINST A FILE WITH
   MF59795      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 WHEN USING AN
   MF59790      LIC-DB-OTHER Internal maintenance
   MF59754      LIC-DB-OTHER-PERFM IMPROVE SQL PLAN VALIDATION
   MF59744      OSP-DB-OTHER-MSGMCH3203 A MSGMCH3203 MAY OCCUR WITH A DELETE
   MF59720      LIC-DB-PERFM not using sparse index
   MF59705      OSP-PERFM JOIN QUERY PERFORMS POORLY DUE TO FIRST N ROWS (FN
   MF59703      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY FAILS WI
   MF59653      LIC-DB-UNPRED Ensure order of partitions in partitioned tabl
   MF59636      LIC-MSGMCH3203 OPTIMIZING QUERY WITH CONSTANT SUBSTITUTION I
   MF59623      OSP-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3601 QUERY
   MF59556      LIC-DB-PERFM Enable Index Merge Ordering
   MF59572      OSP MCH3203 FUNCTION CHECK WHEN QUERY PROCESSED BY OPTIMIZER
   MF59542      LIC-DB-OTHER-UNPRED Query fails when VALUES clause reference
   MF59434      LIC-DB-OTHER-INCORROUT SCALAR FUNCTION RAND()
   MF59434      LIC-DB-OTHER-INCORROUT SCALAR FUNCTION RAND()
   MF59420      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY FUNCTION
   MF59342      LIC-DB-OTHER-PERFM LEFT EXCEPTION JOIN QUERY PERFORMS POORLY
   MF59294      LIC-DB-PERFM not using best index when multiple not equal pr
   MF59294      LIC-DB-OTHER-UNPRED QUERY WITH FAILING WITH MCHMCH3203 T/QQQ
   MF59114      LIC-DB-OTHER-PERFM RECURSIVE QUERY CONNECT BY PERFORMANCE FO
   MF58987      OSP-PERFM LONGER RUNNING QUERY WHEN IN LIST IS LARGER THAN E
   MF58978      LIC-DB-OTHER-UNPRED QUERY WITH OLAP FUNCTION FAILING AFTER U
   MF59241      LIC-DB-OTHER-PERFM HIGHER CPU CONSUMPTION FOR QUERY AFTER AP
   MF59226      LIC-PERFM SQL PERFORMANCE ISSUES INVOLVING ORDERING PLANS
   MF58913      LIC-DB-OTHER-PERFM DISTINCT QUERY TAKES TWICE AS LONG AFTER
   MF58910      LIC-DB-OTHER-PERFM QUERY OPTIMIZER IMPROVEMENTS TO COSTING.
   MF58885      LIC-DB-OTHER Internal Maintenance
   MF58830      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT IMPLEMENT VIA AN
   MF58723      LIC-DB-OTHER Internal Maintenance
   MF58732      LIC-DB-OTHER-PERFM SMP IMPLEMENTATION LEADS TO POOR SQL QUER
   MF58714      OSP-DB-OTHER-UNPRED 0600DEAD VLOGS ARE GENERATED WHEN RUNNIN
   MF58713      OSP-DB-OTHER-INCORROUT NO RECORDS RETURNED FROM PARTITIONED
   MF58710      LIC-DB-OTHER-PERFM UPDATE STATEMENT INTERMITTENTLY PERFORMS
   MF58648      LIC-DB-OTHER-PERFM OPTIMIZER SELECTS TABLE SCAN RATHER THAN
   MF58576      OSP-OTHER-PERFM A QUERY STARTED PERFORMING POORLY AFTER THE
   MF58427      LIC-DB-OTHER-PERFM VIEW CONTAINING SELECT LIST UDFS ALSO USE
   MF58386      LIC-DB-INCORROUT DELETE under commit with subquery
   MF58352      OSP MSGMCH3203 X/1720 F/UASSERT X/0004 T/ QQQOOODBOP MODULE
   MF58339      OSP-DB-OTHER-PERFM CALLDBMAINTFOROPENOROPTIMIZE
   MF58242      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF503E MSGSQL0502-F/
   MF58192      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC6-MSGSQL0952 MSGSQL0952 F
   MF58131      OSP-DB SQL STATEMENT THAT USES HIERARCHICAL RECURSION FAILS
   MF58123      OSP-PERFM GROUPING QRY OVER SINGLE TABLE RUNS LONG WITH PLAN
   MF58121      OSP-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/DBPMTRAP
   MF58061      LIC-DB-OTHER-PERFM AN INSERT STATEMENT WITH A SUBSELECT OVER
   MF58033      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0243 A MSGSQL0243 MAY OCCUR WIT
   MF58014      LIC-DB-OTHER-PERFM PRELOAD OF QUERY DATA SOURCES CAUSES PERF
   MF57979      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT USE ALL AVAILABL
   MF57978      OSP-DB-OTHER-T/QQQOOODBOP-RC1720-MSGMCH3203 WITH A LEFT OUTE
   MF57957      LIC-DB-OTHER-PERFM A COMPLEX QUERY PERFORMS POORLY.
   MF57946      OSP-PERFM PERFORMANCE PROBLEMS WITH UNION QUERY USING DISTIN
   MF57918      OSP-PERFM SPARSE MTI CHOSEN OVER PERMANENT INDEX RESULTING I
   MF57814      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SELECT * FROM
   MF57834      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT USE ALL AVAILABL
   MF57809      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   MF57809      LIC-DB-OTHER-PERFM IMPROVE PARTITION AVOIDANCE FOR JOIN
   MF57763      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 SQL TRAPS IN
   MF57734      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203
   MF57676      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SQL MCH3203 QQ
   MF57583      OSP-DB MSGMCH3203 X/1720 F/UASSERT X/0004 T/ QQQOOODBOP MODU
   MF57574      OSP-DB-OTHER-UNPRED MSGMCH3203 F/ASSERT T/QQQOOODBOP
   MF57573      OSP-OTHER-UNPRED DROP TABLE RESTRICT DOES NOT END
   MF57547      OSP-DB-OTHER-INCORROUT THE CUSTOMER IS SEEING INCONSISTENT O
   MF57538      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MCH3203 F/ASSE
   MF57510      OSP-DB INCORRECT OUTPUT RUNNING A SELECT STATEMENT.
   MF57412      OSP-DB-OTHER-INCORROUT FULL OUTER JOIN QUERY RESULTS MAY VAR
   MF57381      LIC-DB-OTHER-UNPRED NUMBER OF MTIS EXCEEDS SYSTEM LIMIT
   MF57345      OSP-F/DBPMTRAP-T/QDBGETMQO-MSGMCH3203 MSGMCH3203 F/DBPMTRAP
   MF57302      LIC-DB-PERFM Index scanned instead of probed with many OR pr
   MF57286      OSP-DB-OTHER-THREADS-F/ASSERT-T/QQQOOODBOP-MSGMCH3203X/1720
   MF57284      PERFM-HLIC-94XXBASE UDF DEFINED AS NOT DETERMINISTIC, EXTERN
   MF57282      LIC-DB-OTHER-PERFM POOR QUERY PERFORMANCE WHEN RUN AGAINST V
   MF57261      LIC-DB-OTHER-INCORROUT SQL MAX WITH EVI INCORROUT
   MF57142      OSP-PERFM QUERY USING WITH CLAUSE NOT USING BEST INDEX RESUL
   MF57103      OSP-DB-OTHER-PERFM FACILITATE JOIN DOWNGRADE THROUGH A UNION
   MF57039      LIC-DB-OTHER-INCORROUT SQL OPTIMIZER USING SPARSE INDEXES WI
   MF56936      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56935      OSP-PERFM QUERY PERFORMANCE OVER A VIEW
   MF56934      LIC-DB-OTHER-INCORROUT EMBEDDED SQL RPG DOES NOT RETURN THE
   MF56926      OSP-DB-OTHER-THREADS-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203
   MF56913      OSP-PERFM QUERY PERFORMANCE
   MF56909      OSP-OTHER-PERFM QUERY OVER QSYS/SYSTSTAT VIEW IS SLOWER THEN
   MF56858      LIC-DB-PERFM FieldProc
   MF56839      LIC-DB-OTHER-INCORROUT WITH EVI INCLUDE AND UDFS
   MF56805      OSP-PAR-940XMISC INDEXING STRATEGY
   MF56795      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-RC2-MSGCPF5027 DIFFERENT
   MF56793      LIC-DB-OTHER-INCORROUT SQL QUERY USING WITH ROLLUP INCORROUT
   MF56756      LIC-DB-INCORROUT SMP query using EVI AGG index
   MF56699      LIC-DB-OTHER-PERFM WHOLE FILE AGGREGATION ON A VERY LARGE TA
   MF56699      LIC-DB-OTHER-INCORROUT THE CUSTOMER HAS AN SQL THAT IS FAILI
   MF56596      LIC-DB-OTHER-PERFM SQL STATEMENT WITH UDF PERFORMS POORLY
   MF56594      SQL-DB-PERFM Index advice for ORed predicates
   MF56578      OSP-DB-PERFM Visual Explain while running fails for short ru
   MF56574      OSP-PERFM Not reusing SQL plans with override optimization g
   MF56509      OSP FETCH WITH SCROLLABLE CURSOR IS NOT POSITIONING CORRECTL
   MF56474      OSP-PERFM SQL STATEMENTS THAT GET AN OPTIMIZATION GOAL OVERR
   MF56472      OSP-DB-OTHER-INCORROUT WHEN SQL CUBE GROUPING SET IS RUN WIT
   MF56462      LIC-DB-OTHER Locks being obtained too early for some queries
   MF56462      LIC-DB-MSGMCH3203 from DbpmTrap when Partitioned Table
   MF56375      LIC-DB-OTHER-INCORROUT SPECIFYING NUMBER OF TASKS FOR SMP WI
   MF56344      OSP-DB-OTHER-MSGMCH3203 MCH3203 - FUNCTION ERROR X'1720' IN
   MF56338      LIC-DB-MSGMCH3203 ArrayAgg query with ORDER BY
   MF56315      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 M
   MF56303      LIC-DB-UNPRED CASE Running THEN when it is FALSE
   MF56253      OSP-DB SQL Plan Cache - filter by index advise key columns
   MF56246      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SQL JOIN SELEC
   MF56185      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 A QUERY
   MF56122      OSP-DB MCH3203 X/1720 F/ASSERT X/000004 T/QQQOOODBOP QQQOOOI
   MF56095      LIC-DB-OTHER-INCORROUT FULL OUTER JOIN NOT PRODUCING CORRECT
   MF56069      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF56060      OSP-DB QUERY WITH CTE AND DISTINT CAN CAUSE MCH3203
   MF55975      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 T/QQQOOODBOP
   MF55951      LIC-DB-MSGMCH3601 relating to partitioned tables and EVIs
   MF55928      LIC-DB-OTHER-PERFM-DB  EVI Includes and GROUP SETS enhanceme
   MF55923      OSP-PAR-940XMISC WRONG JOIN ORDER BEING CHOSEN BY THE OPTIMI
   MF55899      OSP-DB-Visual Explain diagram with disconnected icons
   MF55849      LIC-DB-MSGMCH3203 VLOG when EVI Aggregate and NLSS index
   MF55849      OSP-DB-OTHER-F/DBOPRELQDSPTL-T/QQQ-MSGMCH3601 SELECT USING M
   MF55838      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55778      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 Grouping sets
   MF55746      OSP-INCORROUT INCORRECT OUTPUT WITH HIERARCHICAL QUERY OF CO
   MF55721      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 COMPLEX SQL QU
   MF55712      LIC-DB-OTHER-MSGMCH3203 Grouping set queries fail when query
   MF55712      OSP-PERFM POOR SQL PLAN CHOSEN - NO CACHE OVER THE AGGREGATE
   MF55668      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT ON QUERY WITH COMMON
   MF55653      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 COMPLEX SQL QU
   MF55412      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF55404      OSP-DB-OTHER-F/QQQOOOINV-T/QQQOOOINV-MSGMCH3203 MCH3203, CPF
   MF55329      LIC-DB-MSGMCH3203 UDTF with XMLAGG operand
   MF55329      OSP-DB-OTHER Avoid indexes when creating EVI INCLUDE index
   MF55329      OSP-DB-OTHER-PERFM SQL OLAP FUNCTION PERFORMS POORLY DUE TO
   MF55156      OSP-DB-OTHER-PERFM SQL STMT WITH CONTAINS FUNCTION RUNS SLOW
   MF55186      OSP-DB-OTHER-F/DBLISTHOME-T/QQQOOODBOP-MSGMCH3601 SELECT INT
   MF54963      OSP-PERFM QUERY RUNNING LONGER WHEN DATE RANGE GREATER THAN
   MF54963      LIC-DB-PERFM Table Probe IO Costing when secondary in a join
   MF54955      LIC-DB-OTHER IMPROVE SQE TRACING
   MF54953      LIC-DB-OTHER ADD METHOD TO ELIMINATE ALL ORDER BY PUSHDOWN R
   MF54947      LIC-DB-OTHER OPTIMIZER CHOOSING LESS OPTIMAL INDEX BASED ON
   MF54919      OSP-DB-OTHER-INCORROUT SQL SELECT STATEMENT MAY NOT RETURN C
   MF54723      LIC-DB-MSGMCH3203 complex Join query
   MF54610      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 SQL UPDATE of MULTI-DS
   MF54599      OSP-PERFM SLOW QUERY PERFORMANCE. THE IN PREDICATE WITH MULT
   MF54558      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 T/QQQOOODBOP
   MF54463      LIC-DB-OTHER-SRC0600BADA SRCB6000302 - DB STACK CORRUPTION
   MF54445      OSP-DB INCORRECT OUTPUT WITH DEFAULT VALUES
   MF54388      OSP-DB Perform key selection for LIKE predicate with leading
   MF54313      LIC-DB-OTHER-PERFM UPDATE QUERY TAKES LONGER THEN EXPECTED
   MF54312      LIC-DB-OTHER ENHANCE INI PARM ALLOW_TEMPORARY_INDEXES
   MF54299      LIC-DB-PERFM OLAP QUERY RUNS FAST IN ISQL, AND SLOW IN RUNSQ
   MF54186      LIC-DB-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 TO MODULE QQQ
   MF54138      OSP-DB-OTHER-PERFM MISSING CACHE NODE CAUSING QUERY TO PERFO
   MF54127      LIC-DB-MSGMCH3202 AffinityMap error on MERGE
   MF54054      OSP QUERY GETS STUCK IN OPTIMIZATION
   MF54049      OSP-DB-OTHER INCORROUT ON SQL WITH IFNULL
   MF54025      LIC-DB-PERFM-OTHER Problems with costing Select/Omit indexes
   MF54025      LIC-DB-MSGMCH3202 AffinityMap error on MERGE
   MF54008      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT UTILIZE EXPECTED
   MF53940      F/ASSERT-MSGMCH3203 MCH3203 F/ASSERT T/QQQOOODBOP STATEMENT:
   MF53621      OSP-DB-OTHER-UNPRED SQL INSERT WITH SUM HANGS WHEN RAN WITH
   MF53621      OSP-MSGMCH3203-D/TASSERT-PAR-940XMISC OSP-MSGMCH3203-D/TASSE
   MF53621      OSP-PAR-940XMISC QUERY SPENDS A LOT OF TIME IN OPTIMIZER COD
   MF53559      LIC-DB-UNPRED MQT optimization
   MF53559      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 SELECT
   MF53559      LIC-OTHER-PERFM LONG OPTIMIZATION TIMES FOR COMPLEX QUERIES
   MF53546      LIC-DB-OTHER-THREADS-PERFM SMALL QUERY EXECUTED MILLIONS OF
   MF53421      OSP-PERFM OPTIMIZE ALL ROWS LEADS TO COMPLEX LPG PLAN
   MF53339      OSP-OTHER-PERFM QUERY PERFORMANCE WITH PARTITIONED TABLES
   MF53282      OSP-LOOP LIC-DB-OPTIMZER LOOPING WHEN USING SELECT/OMIT
   MF53174      LIC-DB-PERFM FETCH N ROWS WAS PREVENTING TRANSITIVE CLOSURE
   MF53174      LIC-DB-OTHER-PERFM Complex Query Optimization Time
   MF53174      LIC-DB-OTHER-PERFM COMPLEX SQL STATEMENT RUNS MUCH LONGER AT
   MF53174      LIC-DB-MSGMCH3203 A MULTIPLE UNION ALL WITH CTE SQL STATEMEN
   MF53171      LIC-DB-OTHER-MSGCPF5035 UPDATE WITH WHERE CLAUSE FAILS WITH
   MF53111      OSP-DB-OTHER-F/DBPMPTHACCESSOPERATIONX/00056C-MSGMCH3601 AFT
   MF53055      LIC-DB-OTHER-PERFM SQE QUERY OVER A VIEW USES HIGH TEMP STOR
   MF53005      OSP-PERFM SQL SUBQUERY WITH MIN MAX FUNCTION PERFORMANCE DEG
   MF52861      OSP-DB-OTHER-INCORROUT SPARSE PREDICATE VALIDATION NOT HANDL
   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 MA44668
Superseded by:......................View fix details for PTF MF65429
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C5317710


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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"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":""}}]

Document Information

Modified date:
10 June 2015