APAR CLOSED STATUS DB2 V8 DB2 9 DB2 10 HIPER Description
PK68295 2009-03-17 N/A UK44934 N/A Y MODIFY INDEX EXPLOITATION FOR UPPER AND LOWER BIFS WITH NO LOCALE NAME SPECIFIED IN THE FUNCTIONS
PK71618 2009-02-06 N/A UK43839 N/A INDEX IO (IMIO) UNDERESTIMATED WHEN NUMBER OF INDEX PAGES FITS IN BUFFER POOL FOR AN INDEX ON THE INNER TABLE
PK73161 2009-02-26 N/A UK44395 N/A PREDICATE NOT PUSHED INTO MATERIALIZED VIEW DUE TO DATATYPE MISMATCH
PK74980 2009-03-30 N/A UK45352 N/A ENABLING PARALLELISM (DEGREE = ANY) RESULTS IN A BAD PERFORMING ACCESS PATH
PK75285 2009-01-27 N/A UK43521 N/A PAIRJOIN PLAN MAY BE INCORRECTLY FAVORED WHEN A PUSHDOWN PLAN EXISTS PROCESSING THE SAME DIMENSION TABLES BEFORE THE FACTTBL
PK75593 2009-01-27 UK43519 UK43520 N/A INEFFICIENT INDEX ACCESS WHEN OPTIMAL INDEX IS A SUPERSET OF A UNIQUE INDEX THAT HAS DIFFERENT ORDERING (ASC/DESC)
PK75698 2009-02.25 UK44359 N/A N/A INACCURATE COST ESTIMATE BECAUSE THE SCAN COST OF MATERIALIZED NON-CORRELATED SUBQUERY BLOCK COST WAS NOT ADDED
PK76100 2009-02-17 N/A UK44120 N/A ENABLE PAIRWISE JOIN FOR STAR JOIN QUALIFIED QUERIES
PK76284 2009-01-06 UK42908 UK42909 N/A Y ABEND04E-00E20003,U=XXX ,M=(N),C=810.LOCN=XX.XX.XX.XX ,LOC=DSNGEPLC.DSNSVBK +0602
PK76426 2009-04-16 N/A UK45827 N/A INDEX FILTER FACTOR ESTIMATION CAN BE INCORRECT WHEN MCARD EXISTS IN SOME CASES
PK77379 2009-12-28 UK42788 UK42789 N/A INCORRECT FILTER FACTOR FOR A RANGE PREDICATE ON A PARTITIONING COLUMN WHEN SYSCOLSTATS ARE NOT PRESENT
PK77559 2009-01-29 N/A UK43588 N/A Y INCORROUT FOR A QUERY USING PAGE RANGE ACCESS WHEN THE LIMIT KEYIS PADDED WITH SPACES
PK77814 2009-02-27 N/A UK44455 N/A AN IN PRED MAY CAUSE MULTI-COLUMN FREQUENCY STATS TO BE IGNORED WHEN EQUAL AND IN PRED EACH HAVE MULTI-COLUMN FREQUENCY STATS
PK77858 2009-02-06 UK43922 N/A N/A INCORRECT CPU ESTIMATE FOR LEFT OUTER JOIN WITH COL IS NULL PREDICATE ON THE INNER TABLE.
PK78031 2009-03-04 UK44575 N/A N/A RSCAN OR POOR IDX ACCESS, HOST VARIABLES OR PARAMETER MARKERS ONPARTITIONED TABLE SPACE USING PAGE RANGE 09/01/29 PTF PECHANGE
PK78095 2009-03-18 N/A UK44998 N/A POOR JOIN SEQUENCE OF UNMATERIALIZED SNOWFLAKE FOR STAR SCHEMA QUERIES 09/01/12 PTF PECHANGE
PK78463 2009-02-26 N/A UK44410 N/A Y INCORRECT OUTPUT CAN OCCUR WHEN USING AN INDEX CONTAINING A KEY THAT IS DEFINED AS RANDOM AND THERE IS NO COL=LIT ON THAT COLUMN
PK78843 2009-03-02 N/A UK44490 N/A INCORRECT COMBINED FILTER FACTOR ESTIMATION WITH MULTI-COLUMN HISTOGRAM STATISTICS
PK79236 2009-02-27 N/A UK44461 N/A Y UNPREDICTABLE INCORROUT RETURNED ON QUERY WITH UK42199
PK79415 2009-03-17 N/A UK44980 N/A ABEND04E RC00C90101 AT DSNIDM.DSNIWKFT:5003 WHEN USING PAIR-WISEJOIN WITH PARALLELISM
PK79598 2009-03-16 UK44932 UK44933 N/A SOMETIMES A GOOD INDEX ACCESS PATH IS NOT CHOSEN WHEN A VOLATILETABLE IS INVOLVED
PK79826 2009-04-28 UK45626 UK45627 N/A INEFFICIENT ACCESS PATH WHEN INDEX EXISTS TO COVER JOIN COLUMNS AND OPTIMIZE/FETCH FIRST N ROWS IS SPECIFIED
PK79832 2009-04-08 N/A UK45641 N/A DISCOURAGE NESTED LOOP JOIN WITH TABLESPACE SCAN OF THE INNER TABLE WHEN THE INNER TABLE IS A WORKFILE
PK79920 2009-04-06 UK45554 N/A N/A POOR PERFORMING ACCESS PATH INVOLVING LIST PREFETCH DUE TO JOIN PREDICATES CAUSING DB2 TO UNDERESTIMATE # OF RIDS TO SORT
PK79927 2009-10-06 N/A UK50799 N/A ENABLE PAGE RANGE WITH ONE FETCH ACCESS
PK80206 2009-04-15 N/A UK45811 N/A POOR QUERY PERFORMANCE FOR QUERY JOINING 3 OR MORE TABLES
PK80856 2009-04-06 N/A UK45551 N/A ABEND S0C4 on BIND using new stats
PK81046 2009-03-27 N/A UK45310 N/A MODIFY INDEX EXPLOITATION FOR UPPER AND LOWER BIFS WITH NO LOCALE NAME SPECIFIED IN THE FUNCTIONS勇NABLING APAR
PK81576 2009-05-07 N/A UK46375 N/A SQLCODE670 FROM DSNXOSOB AFTER MIGRATION TO V9
PK81838 2009-04-20 UK45891 UK45892 N/A WRONG INDEX CHOSEN ON FACT TABLE CAUSES BAD PERFORMANCE
PK81857 2009-04-13 UK45736 N/A N/A THE FF*FF LOWER BOUND SHOULD BE APPLIED ONLY WHEN THERE IS NO EXACT MATCHING FREQUENCY.
PK82223 2009-05-04 UK46271 UK46272 N/A """COL OP (NON-CORRELATED SUBQUERY)"" INCORRECTLY MARKED AS STAGE 2WHEN OP IS OTHER THAN ""="" AND A NULLABILITY MIS-MATCH EXISTS"
PK82356 2009-04-21 N/A UK45908 N/A VERY LONG PREPARE TIME AND BAD ACCESS PATH FOR A STAR JOIN QUERY
PK82631 2010-04-13 N/A UK56037 N/A RESIDUAL XMLEXISTS EVALUATION AVOIDANCE
PK82783 2009-05-19 UK46742 UK46743 N/A V8 OPTIMIZER DO NOT CHOOSE LIST PREFETCH
PK83715 2009-05-15 UK46672 UK46673 N/A INACCURATE COST ESTIMATION FOR QUERIES WITH EXISTS CORRELATED SUBQUERY
PK83952 2009-05-14 UK46611 UK46612 N/A Y INCORRECT OUTPUT FOR THE QUERY THAT CONTAINS LIKE PREDICATE AND REFERENCE A VIEW OR TABLE EXPRESSION WHICH HAS UNION
PK84057 2009-11-02 UK51657 UK51658 N/A ENHANCE THE FILTER FACTOR ESTIMATION WHEN FREQUENCY STATS ARE INCONSISTENT WITH SYSCOLUMN STATS
PK84092 2009-05-19 UK46738 UK46739 N/A EXTEND OPTIXOPREF TO CHOOSE INDEX ONLY ACCESS OVER INDEX+DATA WHEN INDEX DOES NOT SUPPORT ANY ORDERING
PK84152 2009-05-07 N/A UK46364 N/A Y INCORROUT (LESS ROW FOUND) WITH GROUPBY EXPRESSION AND INDEX ACCESS
PK84297 2009-06-29 N/A UK47917 N/A DB2 MAY UNDERESTIMATE THE MATCHING FILTER FACTOR WHEN WHILE SOME REFERENCE '?' AND OTHER REFERENCE LITERAL.
PK84694 2009-05-27 UK46951 N/A N/A SOMETIMES A GOOD INDEX ACCESS PATH OR JOIN SEQUENCE IS NOT CHOSEN WHEN A VOLATILE TABLE IS INVOLVED. 09/06/05 PTF PECHANGE
PK84794 2009-05-19 N/A UK46740 N/A AN INEFFICIENT ACCESS PATH CAN BE CHOSEN IF THE SUBQUERY SELECT LIST INCLUDES A DECIMAL COLUMN AND OPTXQB IS ON
PK84943 2009-05-28 N/A UK46979 N/A SUB-OPTIMAL ACCESS PATH FOR A NON-READ ONLY CURSOR THAT HAS A NON-CORRELATED SUBQUERY
PK85457 2009-06-29 UK47883 UK47884 N/A IS (NOT) NULL PREDICATE IS PICKED UP AS INDEX MATCHING OVER MOREFILTERING BETWEEN PREDICATE.
PK85475 2009-05-18 N/A UK46718 N/A SUBOPTIMAL JOIN SEQUENCE IS CHOSEN FOR A QUERY WITH ONE OR MORE SUBQUERIES AND TWO OR MORE BASE TABLES
PK85818 2009-07-15 N/A UK48416 N/A THE CLUSTERING DATA I/O COST OF INDEX IS NOT CORRECT
PK86413 2009-06-29 UK47919 UK47920 N/A INEFFICIENT ACCESS PATH FOR STAR JOIN QUERY WHEN TWO OR MORE DIMENSION TABLES JOIN TO THE SAME FACT TABLE COLUMN
PK87657 2009-07-23 N/A UK48608 N/A UNNECESSARY SORT IN ACCESS PATH WHEN THE SELECTED INDEX IS ALREADY ABLE TO PROVIDE ORDERBY OR GROUPBY ORDER
PK88120 2009-06-30 UK47966 N/A N/A ABEND0CC RC0C IN DSNXOGBM+3FE4 DURING ACCESS PATH SELECTION
PK88150 2009-09-17 N/A UK50213 N/A REOPT(AUTO) MAY NOT KICK OFF RE-OPTIMIZATION AT RUN TIME
PK88501 2009-08-10 UK49141 UK49142 N/A TWO INDEXES SUPPORT ORDER BY BUT THE INDEX MATCHING ALL PREDICATES WAS NOT CHOSEN
PK88774 2009-07-21 N/A UK48569 N/A INDEX COST UNDERESTIMATED FOR A DPSI OR PI WHEN ALL PARTITIONS QUALIFY
PK89017 2009-09-03 UK49929 UK49930 N/A PROVIDE A ZPARM TO FENCE THE CHANGES IN PK66355
PK89206 2010-02-23 UK54627 UK54628 N/A WRONG INDEX WAS CHOSEN DUE TO OVERESTIMATED LIST PREFETCH COST OF NPI WHEN PAGE RANGE REDUCTION IS APPLICABLE
PK89637 2009-09-09 UK49945 UK49946 N/A COST UNDERESTIMATED FOR ACCESS OF THE INNER TABLE OF A NESTED LOOP JOIN WHEN THE ACCESS IS IN THE ORDER OF THE INNER INDEX
PK90334 2009-10-15 UK51090 UK51091 N/A INCREASE COST OF HYBRID JOIN SORTN_JOIN = NO WITH HIGH DUPLICATES IN OUTER
PK90370 2009-09-21 N/A UK50619 N/A INEFFICIENT ACCESS PATH MAY OCCUR WHEN QUERY USES OPTIMIZE FOR NROWS AND PARALLELISM IS ENABLED
PK90521 2009-08-21 UK49455 N/A N/A Y INCORROUT FEWER ROWS FOR QUERIES WITH PARTITIONED TABLE WITH > OR >= RANGE PREDICATE AND DPSI INDEX AND P 09/07/07 PTF PECHANGE
PK91840 2009-09-24 N/A UK50450 N/A SUBOPTIMAL ACESS PATH MAY BE CHOSEN FOR A QUERY WHEN MULTI-COLUMN HISTOGRAM STATISTICS EXIST
PK91853 2009-09-03 N/A UK49844 N/A SMJ COST ESTIMATE IS MISCALCULATING THE CARDINALITY OF COMPOSITE KEYS.
PK92908 2009-09-17 N/A UK50215 N/A INCORRECT FILTER FACTOR FOR XMLEXISTS WHEN VALUE INDEX IS SMALL AND FAILURE TO USE XML INDEX ON A VOLATILE TABLE
PK93042 2009-08-28 UK49692 UK49693 N/A Y INCORROUT (LESS ROW RETURNED) WHEN USING PAGE RANGE SCREENING
PK93305 2009-11-03 N/A UK51692 N/A Y MATERIALIZATION OF MANY ROWS MAY OCCUR FOR AN SQL REFERENCING MULTIPLE VIEWS WHERE 1 VIEW CONTAINS UNION OR UNION ALL
PK94481 2009-09-18 UK50256 UK50257 N/A WRONG SYSCOLSTATS CAN BE USED TO EVALUATE RANGE PREDICATE FILTERFACTOR
PK95144 2009-10-14 N/A UK51019 N/A POOR PERFORMANCE FOR A READ ONLY QUERY WITH A 'FOR UPDATE OF' CLAUSE. R-SCAN IS CHOOSEN INSTEAD OF AN INDEX SCAN.
PK95384 2009-10-20 N/A UK51217 N/A BIND/REBIND WITH OPTHINT IS SUCCESSFUL, BUT EXPLAIN DOESN'T GENERATE ROWS IN PLAN_TABLE, AND STATUS='H' IN SYSPACKSTMT
PK95698 2009-09-28 N/A UK50562 N/A ACCESS PATH CHANGES DURING REBIND WHEN STATISTICS AND BIND OPTIONS ARE UNCHANGED.
PK95939 2009-11-02 N/A UK51639 N/A INCORRECT FILTER FACTOR OF BIGINT PREDICATES
PK96294 2010-10-15 N/A UK61407 N/A Y INCORROUT (NO ROW FOUND) ON QUERY USING A PADDED INDEX-ON-EXPRESSION
PK96558 2010-02-04 N/A UK54176 N/A MULITPLE INDEX ACCESS PATH ISSUE FOR QUERY WITH XMLEXISTS
PK97015 2009-12-17 UK53002 UK53003 N/A INDEX W/LIST PREFETCH IS SELECTED FOR VOLATILE TABLE IF THIS INDEX CREATED LAST EVEN IF OTHER INDEXES EXIST
PK97110 2009-11-13 N/A UK51928 N/A Y SPARSE INDEX NOT USED FOR A NON-CORRELATED SUBQUERY WITH A FIELDPROC
PK98496 2010-01-04 N/A UK53312 N/A OVERESTIMATED MATCHING FILTERING FOR THE INNER TABLE INDEX FOR NLJ WITH SORT COMPOSITE WHEN JOIN PREDICATE IS COL=COLEXP
PK98754 2009-12-17 UK53113 UK53114 N/A INTERMITTENT QUERY PERFORMANCE PROBLEM CAN OCCUR WHEN OPTIXOPREFSUBSYSTEM PARAMETER IS ON
PK98769 2009-12-03 N/A UK52549 N/A NON PAIRWISE JOIN PLAN CAN BE LOST IN COSTING WHEN ALL THE DIMENSION TABLES CAN BE EVALUATED IN THE RID RETRIEVING PHASE
PK98879 2010-07-30 UK59345 UK59346 N/A INCORRECT FILTER FACTOR FOR A PREDICATE GENERATED BY PREDICATE TRANSITIVE CLOSURE
PK99198 2009-12-01 N/A UK52459 N/A CHOOSING A POOR PERFORMING ACCESS PATH FOR A QUERY WITH MULTIPLEDISTINCTS, AND THE BAD PLAN REQUIRES A FINAL SORT
PK99238 2009-12-10 UK52774 N/A N/A COST OF SORT MERGE JOIN WITH 1 SMJ COLUMN IS UNDERESTIAMTED, THUS A BETTER PLAN WITH MORE SMJ COLUMN IS NOT USED
PK99332 2010-01-04 N/A UK53318 N/A COST UNDERESTIMATED FOR A NON-CORRELATED SUBQUERY
PM00141 2009-11-23 N/A UK52225 N/A FILTER FACTOR IS INCORRECT WHEN A DECIMAL COLUMN HAS MINUS VALUEIN HIGH2KEY OR LOW2KEY
PM00367 2009-12-12 N/A UK52819 N/A SQLCODE670 ISSUED WHEN QUERY WITH GROUP BY DOESN'T CHOOSE CORRECT ACCESS PATH TO AVOID SORT 10/01/18 PTF PECHANGE
PM00578 2009-11-25 N/A UK52301 N/A A 'NOT IN CORSUBQ' PREDICATE HAS A INCORRECT FILTER FACTOR AND LEADS TO BAD ACCESS PATH.
PM01913 2010-01-11 N/A UK53491 N/A ACCESS PATH CHANGES DURING REBIND WHEN STATISTICS AND BIND OPTIONS ARE UNCHANGED
PM02317 2010-04-07 N/A UK55913 N/A ENABLE SPARSE INDEX WITH AN EXPRESSION IN THE COMPOSITE
PM02489 2010-02-22 N/A UK54577 N/A Y INCORROUT FOR A QUERY WHEN THE CHOSEN INDEX CONTAINS A RANDOM COLUMN AND THERE IS NO COLUMN=LITERAL PREDICATE ON THAT COLUMN.
PM02571 2010-10-12 N/A UK61259 N/A BAD JOIN SEQUENCE INVOLVING A CARTESIAN JOIN RESULTING IN POOR PERFORMANCE
PM03134 2010-02-23 N/A UK54610 N/A COST UNDERESTIMATED FOR SPARSE INDEX PROBES OR SORT NEW
PM04185 2010-02-22 N/A UK54575 N/A UNNECESSARY SORT IN UNION BLOCKS IN V9.
PM04629 2010-04-02 N/A UK55797 N/A UNINITIALIZED VARIABLE CAUSE FILTER FACTOR ERROR
PM04697 2010-08-25 N/A UK60016 N/A POOR PERFORMANCE WITH BAD INDEX CHOSEN FOR A STARJOIN QUERY INVOLVING A SNOWFLAKE DUE TO UNDERESTIMATED COLUMN CARDINALITY
PM04776 2010-04-14 N/A UK56082 N/A PAIR WISE JOIN ACCESS PATH CHOSEN WHEN A MORE EFFICIENT NON PAIR WISE JOIN PLAN IS AVAILABLE
PM05030 2010-02-12 N/A UK54360 N/A INCONSISTENT SEQUENTIAL COST IF INNER TABLE OF NESTED LOOP JOIN HAS SUBQUERY, MAY CAUSE SUBOPTIMAL ACCESS PATH UNDER PARALLELISM
PM05056 2010-03-12 UK55178 UK55179 N/A NOT EQUAL LOCAL PREDICATE IS NOT CONSIDERED AS SCREENING PREDICATE, AND IT MAY CAUSE SUBOPTIMAL ACCESS PATH BE CHOSEN
PM05586 2010-03-29 N/A UK55676 N/A SUBOPTIMAL ACCESS PATH SELECTED FOR A HIGHLY FILTERING QUERY AFTER RUNSTATS WITH STATCLUS=ENHANCED
PM06942 2010-05-31 N/A UK57487 N/A INACCURATE FILTER FACTOR ESTIMATION FOR A COMPOUND PREDICATE
PM07130 2010-05-31 UK54957 UK54958 N/A DB2 OVERESTIMATED MULTI COLUMN FILTER FACTOR WHEN NON UNIFORM DISTRIBUTION STATS EXIST AND INDIVIDUAL FILTER FACTOR IS LOWER
PM07281 2010-03-29 N/A UK55675 N/A LIST PREFETCH INCORRECTLY CHOSEN WHEN VERY FEW ROWS QUALIFY 10/02/10 PTF PECHANGE
PM07409 2010-04-15 N/A UK56103 N/A ALLOW INDEX ONLY ACCESS FOR UPDATABLE CURSORS IF ALL UPDATABLE COLUMNS ARE COVERED BY EQUAL PREDICATES
PM07428 2010-03-24 N/A UK55528 N/A IMPROVE CPU PERFORMANCE FOR APPS WITH A DYNAMIC SQL CURSOR PLUS MANY SQL STATEMENTS (STATIC/DYNAMIC), AND CURSOR IS RE-PREPARED
PM07481 2010-04-14 N/A UK56083 N/A POOR PERFORMANCE FOR A STAR JOIN QUERY WITH OVERLAPPING DIMENSIONS
PM07632 2010-03-24 N/A UK55522 N/A Y POOR PERFORMANCE DUE TO MISSING PREDICATE PUSHDOWN 10/02/15 PTF PECHANGE
PM08299 2010-04-08 N/A UK55940 N/A INCORRECT FILTER FACTOR FOR PREDICATES AGAINST COLUMNS WITH COLCARDF=2 WHEN EITHER LOW2KEY OR HIGH2KEY IS NULL
PM08578 2010-06-30 N/A UK58471 N/A ALLOW INDEX ON EXPRESSION MATCHING FOR BEFORE JOIN PREDICATES
PM08749 2010-03-24 N/A UK55648 N/A ALLOW JOIN PREDICATES WITH DATA TYPE MISMATCHES TO BE CONSIDEREDSTAGE 1 WITH XMLTABLE WHEN THE INNER TABLE IS A BASE TABLE
PM09740 2010-04-08 N/A UK55941 N/A INCORROUT FILTER FACTOR WHEN MANY FREQUENCY STATISTICS EXIST
PM10333 2010-06-02 N/A UK57569 N/A POOR PERFORMANCE OR LOOP WHEN DEGREE = 'ANY' AND JOIN (INNER/OUTER)
PM10823 2010-05-24 N/A UK57221 N/A OVERESTIMATED NON-CLUSTER I/O COST CAUSES INEFFICIENT INDEX ACCESS FOR UPDATE STATEMENT
PM11413 2010-07-30 UK59337 UK58754 N/A ABEND0CF RC0F DSNXOCN +8340 10/07/12 PTF PECHANGE
PM11458 2010-07-30 N/A UK59347 N/A COST OVERESTIMATED FOR SINGLE COLUMN INDEX LIST PREFETCH PLANS MATCHING ON A RANGE PREDICATE
PM11588 2010-04-28 N/A UK56507 N/A POOR ACCESS PATH CHOSEN FOR A VOLATILE TABLE FOR A QUERY CONTAINING AN IN SUBQUERY
PM12054 2010-08-15 N/A UK59692 N/A REMOVE ADDITIONAL LIST-PREFETCH WHEN LEADING TABLE USE FULLY EQUAL MATCHING INDEX SCAN IF PARALLELISM IS NOT CHOSEN.
PM12896 2010-06-10 N/A UK57862 N/A INCORRECTLY ESTIMATED CARDINALITY OF GROUPBY MAY RESULT IN INEFFICIENT ACCESS PATH WHEN MCARD STATS ARE USED
PM12924 2010-06-04 N/A UK57650 N/A INEFFICIENT INDEX CHOICE FOR THE LEADING TABLE IN A HIGHLY SELECTIVE QUERY
PM13714 2010-07-14 N/A UK58816 N/A INCORRECT FILTER FACTOR ESTIMATION FOR IN OR EXISTS SUBQUERY PREDICATE WHEN GLOBAL OPTIMIZATION IS ENABLED
PM13747 2010-12-06 N/A N/A UK62824 ABEND04E RC00E72018 IN DSNXGRDS DSNXSMRE+4EAA WHEN SPARSE INDEX USED
PM13794 2010-10-27 N/A UK61784 N/A ADDITIONAL SORT IS CHOSEN THOUGH ORDER BY LIST IS A PREFIX OF GROUP BY LIST
PM13869 2010-05-25 N/A UK57272 N/A ABEND0C4 IN DSNXOGNC+253C DURING BIND PACKAGE. HAPPENS INTERMITTENTLY.
PM13975 2010-11-02 UK61848 UK61849 N/A ABEND04E RC00E70005 IN DSNXGINL :M990 WHEN PREPARING A QUERY CONTAINING A HUGE 'OR' PREDICATE LIST WITH LITERAL CONSTANTS
PM14487 2010-07-23 N/A UK59121 N/A PERFORMANCE IMPACT FOR SQL WITH EXISTS OR IN SUBQUERY WITH CORRELATED PREDICATE
PM14568 2010-11-10 N/A UK62054 N/A POOR PERFORMANCE DUE TO JOIN ORDER CONSIDERATIONS WITH A TABLE PROVIDING NO FILTERING AND JOINED ON A UNIQUE KEY
PM15354 2010-07-06 UK58589 UK58590 N/A ABEND04E RC00E70005 DSNXOTF M909
PM15389 2010-08-26 N/A UK60017 N/A INEFFICIENT ACCESS PATH MAY BE CHOSEN WHEN A QUERY WITH NON-CORRELATED SUBQ HAS OPTIMIZE FOR N ROWS CLAUSE
PM15420 2010-07-12 N/A UK58754 N/A MULTIPLE COLUMN FREQUENCY STATISTIC NOT USED WHEN ALTERNATE STATISTICS EXIST ON THE SAME COLUMN GROUP
PM16020 2010-07-29 UK59309 UK59310 N/A NEW FEATURE TO ADJUST PARALLELISM REDUCTION
PM17234 2011-05-04 N/A UK67420 UK67419 ALLOW MORE JOIN PERMUTATIONS TO BE CONSIDERED WHEN THERE ARE A HIGH NUMBER OF QUERY BLOCKS
PM17697 2010-09-20 N/A UK60606 N/A IMPROVE PERFORMANCE FOR PARSING HEAVY TEXT XML DOCUMENTS
PM19972 2010-10-25 N/A UK61783 N/A SLOW PERFORMANCE FOR EFFICIENT MULTI-INDEX ACCESS IS NOT CONSIDERED
PM20032 2011-04-19 N/A UK66920 UK66919 MULTI INDEX ACCESS NOT CHOSEN WHEN A CANDIDATE INDEX EXISTS THATPROVIDES GOOD SCREENING FILTERING BUT POOR MATCHING FILTERING
PM20157 2010-10-28 N/A UK61755 N/A INDEX LOOKASIDE NOT USED FOR INDEX PAGES WITH ZERO OR ONE ROWS
PM20356 2011-01-13 N/A UK63949 N/A SLOW PERFORMANCE FOR EFFICIENT MULTI-INDEX ACCESS IS NOT CONSIDERED
PM20434 2010-12-13 N/A UK63052 N/A INCORRECT FILTER FACTOR FOR LIKE PREDICATES WITH AN UNDERSCORE ('_') WILDCARD
PM20831 2011-01-24 UK64182 N/A N/A COST OVERESTIMATED FOR MULTI-COLUMN SORT MERGE JOIN 10/08/19 PTF PECHANGE
PM21335 2010-12-13 N/A UK63050 UK63049 INEFFICIENT INDEX SELECTED WHEN MULTIPLE INDEXES ARE HIGHLY SELECTIVE
PM22182 2010-10-21 N/A UK61577 N/A OVERESTIMATED JOIN COMPOSITE SIZE ESTIMATE FOR A QUERY WITH AN OR PREDICATE
PM22265 2010-11-29 N/A UK62645 N/A COST UNDERESTIMATED FOR THE INNER TABLE OF A NESTED LOOP OR HYBRID JOIN
PM22405 2010-12-01 N/A UK62731 UK62730 MATCHING INDEX FILTERING CAN BE INCORRECTLY ESTIMATED FOR COLUMNS IN MORE THAN ONE EQUAL PREDICATE
PM22539 2010-11-04 N/A UK61926 N/A ONECOMPROWS IN DSN_DETCOST_TABLE IS INACCURATE FOR A QUERY WHERE THE OUTER TABLE OF A JOIN HAS HISTOGRAM STATISTICS
PM22768 2010-10-28 UK61777 UK61778 N/A Y ACCESS PATH REGRESSION OCCURS BECAUSE PREDICATES ARE MARKED AS NOT SARGEABLE. 10/09/20 PTF PECHANGE
PM22867 2010-11-12 N/A UK62154 N/A Y ABEND04E RC00E20027 LOC=DSNXOAF .DSNSVBK OFFSET 0A02 BECAUSE OF 1 BYTE OVERLAY WHEN REBIND PACKAGE WITH DEGREE(ANY)
PM23025 2011-02-08 UK64670 UK64671 N/A Y INCORROUT OR POOR PERFORMANCE DUE TO INCORRECT SELECTION OF KEYSFOR MULTI-COLUMN SORT MERGE JOIN WITH SORTC_JOIN='N'
PM23606 2010-11-23 N/A UK62499 UK62498 ABEND0CF-0F IN DSNXOLET+198E WHEN A COLUMN HAD COLCARD=1 AND LOW2KEY=HIGH2KEY=NULL WHEN PARALLELISM IS ENABLED
PM24273 2011-01-24 UK64186 UK64187 N/A Y INCORROUT (NO ROW FOUND) ON COMPLEX QUERY WITH IN-SUBQUERY
PM24430 2010-12-13 N/A UK63051 N/A COST UNDERESTIMATED FOR SPARSE INDEX ACCESS TO A TABLE WITH A SUBQUERY
PM24833 2011-03-02 N/A UK65367 UK65366 LIST PREFETCH IS INCORRECTLY SELECTED FOR UPDATE STATEMENT THAT SHOULD USE INDEX ONLY
PM25059 2011-01-31 UK64445 UK64446 UK64444 UNNECESSARY SORT FOR ORDER BY
PM25554 2011-03-10 N/A UK65682 UK65681 OPTIMIZER MAY OVERESTIMATE COST OF A PARTITIONING INDEX WHEN ITS LEADING COLUMN MATCHES AN IN-LIST PREDICATE.
PM25629 2011-03-24 N/A N/A UK66093 POOR PERFORMANCE DUE TO JOIN ORDER CONSIDERATIONS WITH A TABLE PROVIDING NO FILTERING AND JOINED ON A UNIQUE KEY (FF PM14568)
PM25701 2011-02-28 N/A UK65275 UK65274 POOR PERFORMANCE WITH GLOBAL QUERY OPTIMIZATION AND OPTIMIZER SELECTING A POOR INDEX FOR A CORRELATED SUBQUERY
PM25812 2010-12-11 N/A UK63038 UK63037 INDEX ON CLONE TABLE IS UNAVAILABLE WHEN THE INDEX ON THE BASE TABLE IS IN REBUILD PENDING STATUS DURING THE LOAD
PM25934 2011-02-18 N/A UK65018 UK65017 DPSI'S COST COULD BE UNDERESTIMATED WHEN MULTIPLE PARTS QUALIFY
PM25957 2011-03-07 N/A UK65540 N/A ENHANCEMENT TO MAKE SPARSE INDEX COSTING SENSITIVE TO MXDTCACH SETTING
PM26471 2011-04-05 N/A N/A UK66563 POSSIBLE SLOW QUERY WHEN MULTI-INDEX ACCESS IS CHOSEN INAPPROPRIATELY, ESP. WHEN QUERY HAS MULTIPLE LEVELS OF AND/OR
PM26473 2011-01-18 N/A N/A UK64047 POSSIBLE POOR QUERY PERFORMANCE WHEN INDEX FILTER FACTOR IS SET INCORRECTLY
PM26521 2011-01-17 N/A UK64004 UK64003 FILTER FACTOR OF IS NULL IS 1E-9 WHEN HISTOGRAM EXISTS BUT FREQUENCY DOES NOT EXISTS
PM26922 2011-02-10 N/A UK64692 UK64691 INCORRECT FILTER FACTOR FOR AN EQUAL JOIN PREDICATE IF HISTOGRAMSTATISTICS EXISTS FOR THE COLUMNS ON BOTH SIDES OF THE JOIN
PM27699 2011-02-07 N/A UK64629 UK64628 PREDICATE COMPOUND FILTER FACTOR CAN BE UNDERESTIMATED WHEN MULTI-COLUMN FREQUENCY STATISTICS EXIST, CAUSING SLOW QUERY PERF
PM28102 2011-02-08 UK64649 UK64650 UK64648 PTC FOR ASCII OR UNICODE WITH FOR BIT DATA IS NOT SUPPORTED
PM28224 2011-01-27 N/A N/A UK64334 ABEND04E RC00E70005 AT DSNXOTCP M200 WHEN ALL ELEMENTS OF AN INLIST ARE IDENTICAL AND TRANSITIVE CLOSURE OCCURS
PM29262 2011-04-04 N/A UK66478 UK66477 A QUERY'S TOTAL ESTIMATED COST DISPLAYED IN THE EXPLAIN OUTPUT MAY NOT INCLUDE THE SUBQUERY ESTIMATED COSTS
PM29804 2011-05-13 N/A UK67738 N/A LIST PREFETCH IS INCORRECTLY SELECTED FOR AN INDEX WITH GOOD CLUSTER RATIO
PM30064 2011-03-19 N/A UK65977 UK65976 VIEW MATERIALIZATION FOR UNION ALL WITH CLOB AND HOST VARIABLE
PM30595 2011-03-17 N/A N/A UK66006 INEFFICIENT INDEX ACCESS CAN BE CHOSEN WHEN QUERY HAS GROUP BY OR ORDER BY AND THERE IS AN INDEX TO SUPPORT THE GB/OB ORDER
PM30877 2011-05-24 N/A N/A UK68115 ENHANCEMENT FOR INLIST PREDICATE PROCESSING AS A MATCHING PREDICATE OF AN INDEX ACCESS ACCESS PATH
PM31008 2011-05-11 N/A UK67636 UK67635 INEFFICIENT ACCESS PATH MAY BE CHOSEN IF THERE EXISTS A DATA TYPE MISMATCHED JOIN PREDICATE IN A QUERY
PM31403 2011-04-22 N/A N/A UK67057 INCORRECT FILTER FACTOR ESTIMATION FOR A PREDICATE ON A UNIQUE COLUMN IF THAT COLUMN IS IN A SINGLE-COLUMN INDEX
PM31741 2011-03-17 N/A UK65983 UK65982 SLOW QUERY PERFORMANCE ON QUERY WITH A COLUMN HAVING HISTOGRAM STATS COLLECTED ON IT, AND COLUMN IS IN AN EQUAL PREDICATE
PM32373 2011-04-14 N/A UK66836 UK66835 Y INCORROUT WHEN UNION, INTERSECT, OR EXCEPT ARE USED IN A IN SUBQUERY REFERENCING A COLUMN WITH A FIELDPROC
PM32378 2011-04-07 UK66576 UK66577 UK66575 WHEN PARALLELISM IS USED, DB2 DOES NOT STOP AFTER FINDING A QUALIFYING ROW FOR AN EXISTS SUBQUERY
PM32384 2011-07-20 N/A N/A UK69998 INDEX FILTER FACTOR ESTIMATION CAN BE INCORRECT WHEN MCARD EXISTS IN SOME CASES
PM32401 2011-05-11 N/A N/A UK67932 INACCURATE FILTER FACTOR ESTIMATION FOR A COMPOUND PREDICATE
PM32404 2011-05-11 N/A N/A UK68203 INCORRECT FILTER FACTOR ESTIMATION FOR IN OR EXISTS SUBQUERY PREDICATE WHEN GLOBAL OPTIMIZATION IS ENABLED
PM32677 2011-04-15 N/A N/A UK66834 ADDITIONAL SORT IS CHOSEN THOUGH ORDER BY LIST IS A PREFIX OF GROUP BY LIST
PM33661 2011-04-19 N/A N/A UK66917 SLOW PERFORMANCE FOR EFFICIENT MULTI-INDEX ACCESS IS NOT CONSIDERED
PM34025 2011-05-03 N/A N/A UK67384 ENHANCEMENT TO MAKE SPARSE INDEX COSTING SENSITIVE TO MXDTCACH SETTING
PM34039 2011-04-14 N/A UK66792 UK66791 BAD PERFORMANCE (GET MORE PAGES) WHEN NATIVE SQL PROCEDURE HAS SQL VARIABLE IN LIKE PREDICATE
PM34814 2011-05-06 N/A UK68202 UK68201 SUBOPTIMAL ACCESS PATH WHEN THE QUERY HAS DGTT
PM34936 2011-05-03 N/A N/A UK67416 OVERESTIMATED JOIN COMPOSITE SIZE ESTIMATE FOR A QUERY WITH AN OR PREDICATE
PM35294 2011-07-13 N/A UK69695 UK69694 Y INTERMITTENT INCORROUT (NO ROW FOUND) ON QUERY CONTAINING HOST VARIABLE AND CURRENT TIMESTAMP AND REOPT(AUTO) BIND OPTION
PM35321 2011-06-26 N/A UK69152 N/A Y ENABLE PREDICATE TRANSITIVE CLOSURE FOR IN LISTS
PM35466 2011-08-02 N/A N/A N/A DISCOURAGE NESTED LOOP JOIN WITH TABLESPACE SCAN ON THE INNER TABLE
PM35585 2011-05-19 N/A UK67934 UK67933 INACCURATE INDEX FILTER FACTOR AND TOTAL TABLE FILTER FACTOR MAY OCCUR WHEN MULTI-COLUMNS HISTOGRAM STATS EXIST
PM36049 2011-07-05 N/A N/A UK69453 UNDERESTIMATED COMPOSITE SIZE WHEN TABLE EXPRESSION CONTAINS UNION
PM36392 2011-05-19 N/A N/A UK67935 IINACCURATE FILTER FACTOR OF EQUAL PREDICATE MAY OCCURE WHEN BOTH FREQUENCE AND HISTOGRAMS STATS COLLECTED ON THE SAME COLUMN
PM37038 2011-06-29 N/A UK69336 UK69335 INCORRECT MATCHING INDEX FILTER FACTOR FOR A ROW EXPRESSION PREDICATE RESULTING IN A SUBOPTIMAL ACCESS PATH
PM37128 2011-06-29 N/A N/A UK69337 COST UNDERESTIMATED FOR SPARSE INDEX ACCESS TO A TABLE WITH A SUBQUERY (FF PM24430)
PM37547 2011-06-29 N/A UK69339 UK69338 INCORRECT FILTER FACTOR FOR AFTER JOIN PREDICATE ON A COLUMN DEFINED AS NOT NULL
PM38082 2011-08-25 UK71245 UK71246 UK71244 SIGNIFICANT LOSS OF PAGE RANGE SCREENING FOR QUERIES INVOLVING MULTI-COL PARTITIONING KEYS WITH HOSTVAR/PARAM MKR ON THOSE COLS
PM38413 2011-08-23 N/A N/A UK71130 ENABLE PERFORMANCE ENHANCEMENT FOR COMPLEX XPATH PREDICATES.
PM38468 2011-05-31 N/A N/A UK69786 PREDICATES CONTAINING CASE EXPRESSIONS USING CAST WITHOUT A SUBQUERY ARE NOT HANDLED AS STAGE 1 / INDEXABLE PREDICATES
PM38744 2011-08-04 N/A N/A UK70468 COST UNDERESTIMATED FOR THE INNER TABLE OF A NESTED LOOP JOIN OR HYBRID JOIN
PM38935 2011-07-15 N/A UK69793 UK69792 PARALLELISM ADDS LIST PREFETCH TO AN ACCESS PATH EVEN THOUGH TOO MANY RIDS QUALIFY RESULTING IN RIDPOOL OVERFLOW AND POOR PERFM
PM38954 2011-06-21 N/A UK68993 UK68992 Y INCORROUT (WRONG ORDER SEQUENCE) ON QUERY WITH RANK AND INDEX ACCESS
PM39079 2011-07-05 N/A UK69484 UK69483 PERFORMANCE SLOWS DOWN DUE TO ACCESS PATH CHANGES ON LIKE PREDICATES ON VARCHAR COLUMN ON WHICH PADDED INDEX DEFINES
PM39477 2011-07-27 N/A UK70232 UK70231 PERFORMANCE DEGRADATION DURING CREATE TABLE WITH XML COLUMNS (IMPLICIT CREATE)
PM39849 2011-08-18 N/A N/A UK71000 LIST PREFETCH IS INCORRECTLY SELECTED FOR AN INDEX WITH GOOD CLUSTER RATIO
PM40235 2011-08-19 N/A N/A UK71025 UNPREDICATABLE ACCESS PATH WHEN INDEX-ONLY ACCESS IS POSSIBLE
PM40789 2011-07-29 N/A UK70314 N/A Y ABEND04E RC00E20003 FROM DSNSVBK OR RC00E20016 FROM DSNSVSTK USING PAIR-WISE JOIN FOR THE QUERY WITH SET FUNCTION
PM41119 2011-07-12 N/A UK69691 N/A ABEND04E RC00E2000B DSNXERT2 DSNSVBK +062A STORAGE SHORTAGE / LEAK
PM42686 2011-08-05 N/A UK70543 UK70542 UNDERFLOW FILTER FACTOR FOR A PREDICATE THAT HAS COLCARDF=1 OR 2 CAUSES A POOR PERFORMING ACCESS PATH
PM42945 2011-09-14 N/A N/A UK71890 Y INDEX ON DGTT IS NOT USED BY THE QUERIES WHICH HAVE MATCHING PREDICATES IN V10.
PM43722 2011-08-24 N/A UK71155 UK71154 BAD ACCESS PATH WITH SORT MERGE AND R-SCAN ON HUGE TABLE WAS CHOSEN AFTER MIGRATION TO V9 CM
PM43780 2011-08-23 N/A UK71142 N/A Y INCORROUT WHEN USE OPTIMIZATION HINT FOR THE QUERY WITH GROUP BY AND COLUMNS IN GROUP BY ALSO HAVE EQUAL PREDICATE
PM43817 2011-11-08 N/A N/A UK73630 IMPROVE EXECUTION STATISTICS FOR BOTH STATIC AND DYNAMIC SQL WITH CONCURRENTLY RUNNING THREADS ON DB2 10
PM44942 2011-09-08 N/A N/A UK71709 POOR PERFORMING ACCESS PATH CAUSED BY INCORRECT COMPOUND FILTER FACTOR estimation
PM45048 2011-08-28 N/A UK71315 UK71313 WRONG FILTER FACTOR FOR DISTINCT FROM PREDICATE WHEN COLCARDF IS 1
PM45629 2011-10-20 UK73084 N/A N/A SEQUENTIAL PREFETCH INCORRECTLY SELECTED FOR A UNIQUE INDEX WITH EQUAL PREDICATES ON ALL COLUMNS
PM48011 2011-10-15 N/A UK72975 UK72974 INEFFICIENT ACCESS PATH WITH SORT MERGE JOIN IS CHOSEN FOR A QUERY WITH CORRELATED SUBQUERY
PM49154 2012-02-06 N/A N/A UK75960 Y INCORROUT OR PERFORMANCE DEGRADATION IS POSSIBLE IN QUERIES THAT USE SPARSE INDEX (PRIMARY_ACCESSTYPE = 'T')
PM49449 2012-02-28 N/A N/A UK76480 INCORRECT VALUES IN DSN_COLDIST_TABLE AFTER EXPLAIN CAUSING WRONG ACCESS PATH CHOSEN
PM50507 2011-11-11 N/A N/A UK73797 DB2 MAY CHOOSE SUBOPTIMAL ACCESS PLAN WHEN THE OPTIMAL HASH ACCESS PLAN IS AVAILABLE
PM50516 2011-12-15 N/A UK74867 UK74866 COMPOUND FILTER FACTOR UNDERESTIMATED WHEN THERE IS SIGNIFICANT DATA SKEW ON ONE OR MORE ATOMIC PREDICATES
PM50592 2012-02-15 N/A UK76212 UK76211 IMPROVING PERFORMANCE FOR SHORT RUNNING PAIR-WISE JOIN QUERY.
PM51623 2012-02-02 N/A UK75155 UK75154 INEFFICIENT TABLESPACE SCAN CHOSEN FOR INSTEAD OF DELETE TRIGGER
PM52006 2012-01-27 N/A N/A UK75766 ABEND0C4 RC00000038 IN DSNSLD4 . DSNSVSFB +065C OFFSET WHEN BINDING A SQL STATEMENT WITH REOPT(AUTO) OPTION
PM52410 2012-02-17 N/A UK76354 UK76353 Y ABEND04E RC00E70005 DSNXOWIN:P001 OR DSNXGSFL:M111 OR OTHER ABND INCORROUT, OR EXTRA SORT ON QUERY USING MULTIPLE OLAP FUNCTIONS
PM52694 2012-02-02 N/A UK74928 UK74927 BAD PERFORMING ACCESS PATH FOR A MATERIALIZED QUERY BLOCK (MQB) AFTER ADDING FETCH FIRST FOR N ROWS TO THE SQL
PM54468 2012-02-20 N/A N/A UK76273 UNNECESSARY SORT ADDED WHEN IN LIST TABLE (ACCESSTYPE='IN') ACCESS IS CHOSEN WITH A GROUP BY AND ORDER BY
PM54498 2012-02-08 N/A N/A UK76033 Y ABEND04E RC00E20003 IN DSNSVSTK +05B8 OFFSET05B8 MAY OCCUR WITH DSNXOPPD AS THE CALLER REQUESTING STORAGE
PM54681 2012-02-02 N/A N/A UK75450 DB2 MAY CHOOSE AN INEFFECTIVE ACCESS PATH FOR THE PREDICATES REFERENCING A COLUMN WITH FREQUENCY, HISTOGRAM.
PM55479 2012-03-12 N/A UK77004 UK77003 ABEND0C4 RC00000010 OCCURS AT DSNXOGBM OFFSET BE2C DUE TO FETCHING DECIMAL LENGTH INCORRECTLY
PM55938 2012-03-04 N/A UK76820 UK76819 QUERY WITH EXISTS USES TABLE SPACE SCAN INSTEAD OF INDEX SCAN AS ACCESS PATH WITH DPSI DOESN'T GET COST REDUCTION
PM55976 2012-02-28 N/A UK76458 UK76457 INDEX ONLY INDEX CHOSEN WHEN INDEX ONLY INDEX WITH SUPERSET MATCHING COLUMNS EXISTS
PM56355 2012-03-28 N/A N/A UK77343 RANGE LIST ACCESS SCAN IS NOT CHOSEN
PM56424 2012-04-13 N/A UK77763 UK77758 IMPROVEMENT IN ATOMIC FILTER FACTOR ESTIMATE WHEN A NOT EQUAL PREDICATE EXISTS ON THE SAME COLUMN
PM56435 2012-06-15 N/A N/A UK79618 OPTIMIZER MAY OVERESTIMATE COMPOUND FILTER FACTOR
PM56542 2012-02-28 N/A N/A UK76645 UNEXPECTED INDEX PROBING DONE WHEN LITERALS ARE NOT USED
PM56785 2012-02-23 N/A N/A N/A EFFICIENT CORRELATED FORM NOT CHOSEN FOR SUBQUERY WHEN A CORRELATION PREDICATE COLUMN IS UNIQUE IN THE OUTER QUERY BLOCK (See PM57388)
PM56845 2012-03-30 N/A N/A UK77500 Y PROVIDE OPTION FOR OPTIMIZE FOR 1 ROW TO ALLOW SOME SORT ACCESS PATHS
PM57388 2012-03-26 N/A N/A UK76802 Y INCORROUT (NOT IN CORRECT SORT ORDER) ON QUERY WITH MULTIPLE TABLE JOINS AND NONCORRELATED IN SUBQUERY 12/02/09 PTF PECHANGE
PM57855 2012-03-14 N/A UK76964 N/A AN INEFFICENT ACCESS PATH MAY BE CHOSEN FOR A QUERY WITH SUBQUERIES
PM58612 2012-05-07 N/A N/A UK78548 ABEND04E RC00E70005 DSNXOMIS M909 DUE TO INCORRECT PREDICATE PROCESSING DURING HYBRID JOIN
PM58684 2012-04-11 N/A N/A UK77886 ABEND04E RC00E70005 IN DSNXRSBC :P005 WHEN EXECUTING A SQL STATEMENT WITH AN IN LIST AND AN OR PREDICATES
PM58932 2012-04-15 N/A UK77785 UK77770 POOR PERFORMING ACCESS PATH AND BAD JOIN SEQUENCE HAVING NO LOCAL PREDICATES ON 2 JOIN TABLES
PM59585 2012-04-13 N/A UK77767 UK77766 WHEN COMPETING SELECTIVE INDEXES WITH THE SAME MATCHING, DB2 MAY INCORRECTLY SELECT THE INDEX WITH LESS SCREENING
PM59833 2012-04-01 N/A UK77553 UK77552 AN INEFFICIENT ACCESS PATH MAY BE CHOSEN FOR A QUERY WITH SUBQUERIES WHEN SUBSYSTEM PARAMETER OPTXQB IS ON.
PM59964 2012-04-12 N/A N/A UK77917 ABEND0CF AT DSNXOGCX OFFSET 4A9C FOR QUERY THAT CAN PERFORM INDEX SCREEENING ON AN OR PREDICATE
PM60233 2012-04-12 N/A N/A UK77918 UNEXPECTED INDEX PROBING WHEN PAGE_RANGE ACCESS IS CONSIDERED AS POSSIBLE ACCESS PATH
PM60422 2012-05-08 N/A UK78588 UK78587 ABEND04E RC00E70005 IN DSNXRUWG :M500 FOR A POSITIONED UPDATE WHEN ITS CURSOR SELECT USING MULITPLE ROW FETCH & INLIST ACCESS
PM61011 2012-04-30 N/A UK78279 UK78278 DB2 INCORRECTLY CHOOSES TO SORT INSTEAD OF SCAN AN INDEX IN REVERSE ORDER WHEN OPTIMIZE FOR 1 ROW IS SPECIFIED
PM61426 2012-04-30 N/A N/A UK78312 FREQUENCY STATISTICS NOT USED FOR INDEX ON EXPRESSION IN DB2 10 CM9
PM61436 2012-04-24 N/A N/A UK78234 TABLE MISSING FROM ACCESS PATH AND PLAN_TABLE WHEN MORE THAN 2 TABLES ARE CROSS JOINED
PM61658 2012-06-04 N/A UK79325 UK79324 OVER-ESTIMATED CORRELATED SUBQUERY CARDINALITY MAY RESULT IN INEFFICIENT ACCESS PATH WITH GLOBAL OPTIMIZATION
PM62712 2012-08-01 N/A N/A UK80750 OPTIMIZER INCORRECTLY FAVORS RANGE LIST ACCESS PATH
PM64195 2012-09-24 Modified N/A N/A UK82056 Y INCORRECT OVERESTIMATED CARDF VALUE IN DSN_COLDIST_TABLE MAY AFFECT ACCESS PATH
PM64315 2012-07-02 N/A N/A UK79977 FILTER FACTOR OVER ESTIMATED FOR A COMPLEX OR PREDICATE RESULTING IN A POOR PERFORMING ACCESS PATH
PM64871 2012-07-06 N/A N/A UK80118 TO IMPROVE FILTER FACTOR OF IN-SUBQUERY PREDICATE
PM65757 2012-08-09 N/A UK80982 UK80981 Y ABEND04E RC00E70005 DSNXOBM P030 DURING BIND AND PRIMARY_ACCESSTYPE = 'T' (SPARSE INDEX)
PM66098 2012-08-07 N/A N/A UK80906 OPTIMIZER DOES NOT CHOOSE AN EQUAL UNIQUE INDEX RESULTING IN A POOR PERFORMING ACCESS PATH
PM66536 2012-09-04 N/A N/A UK81517 INCORRECT FILTER FACTOR ESTIMATION FOR INDEX PROBING RESULTING IN BAD PERFORMING ACCESS PATH
PM66882 2012-08-13 N/A N/A UK81045 Y PERFORMANCE DEGRADATION DURING SORT (QUICKSORT) DSNXSQSG OFFSET09D8 OFFSET0A50 (MORE SCENARIOS FOR PM64651)
PM66948 2012-07-31 N/A UK80702 UK80701 INACCURATE FILTER FACTOR FOR A JOIN PREDICATE IF HISTOGRAM STATISTICS EXISTS
PM67292 2012-08-07 N/A N/A UK80905 OPTIMIZER CHOOSES BAD RANGE LIST ACCESS OVER MULTIPLE INDEX ACCESS RESULTING IN POOR PERFORMANCE
PM68086 2012-08-31 N/A N/A UK81450 COMPOUND FILTER FACTOR OVERESTIMATED WHEN MULTIPLE SETS OF MULTI-COLUMN FREQUENCY STATISTICS EXIST
PM68139 2012-09-17 Modified N/A N/A UK81851 INACCURATE FILTER FACTOR IS PRODUCED IF THERE ARE MULTIPLE LOCAL PREDICATES ON THE SAME COLUMN AND INDEX PROBING IS USED
PM69139 2012-09-12 N/A N/A UK81765 UNDERESTIMATED TOTAL FILTER FACTOR FOR 2 RANGE PREDICATES ON THE SAME COLUMN RESULTING IN POOR PERFORMING ACCESS PATH
PM69237 2012-09-24 Modified N/A N/A UK82042 INEFFICIENT ACCESS PATHS FOR QUERIES WITH PREDICATES ON TIMESTAMP COLUMNS
PM69949 2012-09-05 N/A N/A UK81527 WHEN COMPETING SELECTIVE INDEXES, DB2 MAY INCORRECTLY SELECT A DATA PARTITIONING SECONDARY INDEX THAT SUPPORTS INDEX ONLY
PM70345 2012-09-28 Modified N/A N/A UK82227 MULTI-INDEX ACCESS NOT USED WITH A TIMESTAMP COLUMN
PM70949 2012-09-14 N/A N/A UK81821 INVALID USE OF INTERNAL SERVICEABILITY FEATURE RESULTS IN TABLESPACE SCAN ACCESS PATH
PM71904 N/A N/A OPEN POOR PERFORMANCE FOR QUERY CONTAINING A PREDICATE ON A TIMESTAMP COLUMN INSIDE AN OR
PM72026 2012-11-07 New & Closed N/A UK83313 UK83312 Y ENABLE MULTIPLE INDEX ACCESS FOR SOME PREDICATES THAT HAVE A NON CORRELATED SUBQUERY UNDER AN OR
PM72671 2012-10-09 Modified N/A N/A UK82444 INCORRECT FILTER FACTOR ESTIMATION FOR RANGE PREDICATE WITH DOUBLE-BYTE CHARACTER SET
PM73283 2012-10-18 New & Closed N/A N/A UK82761 Y INDEX PROBING WITH EMPTY STRING PREDICATE CAUSED ABEND04E DSNKCEST ERQUAL5004
PM73542 N/A N/A OPEN MULTI-INDEX ACCESS NOT USED WITH A PREDICATE COMPARING A TIMESTAMP COLUMN TO A LITERAL VALUE
PM74945 New N/A OPEN N/A INEFFICIENT INDEX USED AS THE INNER TABLE OF A NESTED LOOP JOIN OR HYBRID JOIN
PM75197 New N/A N/A OPEN INEFFICIENT ACCESS PATH FOR A READ-ONLY QUERY WITH FOR UPDATE SPECIFIED AND AN ISOLATION LEVEL OTHER THAN CS
PM75276 2012-11-12 New & Closed N/A N/A UK83436 Y PERFORMANCE DEGRADATION POSSIBLE WHEN EXCESSIVE AMOUNT OF PAGES ARE NOT ACCOUNTED FOR IN SPARSE INDEX