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