APAR CLOSED STATUS DB2 V8 DB2 9 DB2 10 HIPER Description PK63586 2009-08-07 N/A UK49094 N/A INCORRECT HIGH2KEY AND LOW2KEY FOR AN INDEX WITH A RANDOM AND NOT NULLABLE FIRST KEY COLUMN PK73977 2009-03-12 N/A UK44783 N/A RUNSTATS HISTOGRAM PRODUCES INCORROUT AND AN UNEVEN DISTRIBUTION OF QUANTILES PK76946 2009-04-24 UK46069 UK46070 N/A RUNSTATS GOT U049 MESSAGE WHEN THERE IS A EUROPEAN CHARACTER IN THE INDEX NAME AND SYSIN WAS PROCESSED AS UTF-8. PK77823 2009-04-28 N/A UK46153 N/A RUNSTATS PRODUCES WRONG FIRSTKEYCARDF FOR SYSINDEXES PK79298 2009-02-12 UK44010 N/A N/A RUNSTATS HIGH2KEY/LOW2KEY INCORRECT WHEN FOR BIT DATA IS BINARY ZERO PK79644 2009-03-23 UK45145 N/A N/A RUNSTATS WITH COLGROUP ABENDS 0C4-3B,DSNUSDST+21E4 PK79771 2009-03-02 N/A UK44494 N/A UNDERESTIMATED MATCHING FILTER FACTOR FOR INDEX COLUMNS WITH 0 MATCHING MULTI COLUMN FREQUENCY AND CARDINALITY STATS PK80258 2009-05-28 N/A UK47029 N/A RUNSTATS WITH HISTOGRAM GET 0C6 ABEND PK80951 2009-04-30 N/A UK46216 N/A INCORRECT FREQUENCY STATISTICS FOR SYSIBM.SYSCOLDIST CATALOG TABLE PK81549 2009-05-20 UK46769 UK46770 N/A RUNSTATS MIGHT SET FIRSTKEYCARDF > FULLKEYCARDF, WHICH IS NOT POSSIBLE. PK82275 2009-04-16 UK45842 N/A N/A Y CPU LOOP WHEN INVALIDATING A DYNAMIC CACHED STATEMENT 09/04/16 PTF PECHANGE PK83163 2009-06-04 N/A UK47180 N/A RUNSTATS WITH MULTIPLE COLGROUP FREQVAL COUNT N MAY RESULT IN INCORRECT VALUES IN SYSCOLDIST PK84057 2009-11-02 UK51657 UK51658 N/A ENHANCE THE FILTER FACTOR ESTIMATION WHEN FREQUENCY STATS ARE INCONSISTENT WITH SYSCOLUMN STATS PK84584 2009-06-29 N/A UK47894 N/A PROVIDE BETTER ALIGNMENT BETWEEN CLUSTERRATIO & SEQ. DETECTION BY IMPROVING CLUSTERRATIO ALGORITHM PK86343 2009-06-30 UK47952 UK47953 N/A RUNSTATS WITH SAMPLING CAN HAVE COLCARDF LESS THAN THE NO. OF FREQ. VALUES COLLECTED WITH FREQVAL PK87602 2009-06-22 N/A UK47656 N/A Y ABEND0C4 DSNIRFNX+593A DURING RUNSTATS ON A UTS WITH 512 PARTS PK87929 2009-06-30 UK47943 UK47944 N/A RUNSTATS RECEIVES 00E40204 PK89063 2009-08-25 N/A UK49576 N/A ABEND04E RC00C90101 IN DSNK2DM DSNKBULD ERQUAL5002 DURING RUNSTATS UTILITY EXECUTION PK90217 2009-09-25 UK50514 N/A N/A RUNSTATS MULTI stats can be wrong PK90218 2009-08-07 N/A UK49091 N/A RUNSTATS GENERATE INCORROUT STATISTICS ON DECFLOAT COLUMN PK92691 2009-08-13 N/A UK49225 N/A SYSCOLDIST INCONSISTENCIES WITH RUNSTATS PK93104 2009-09-30 N/A UK50682 N/A RUNSTATS MISSING COUNT KEYWORD IN FREQVAL AND WITH HISTOGRAM GETS ABEND PK95138 2009-10-07 N/A UK50854 N/A ABEND04E RC00C90101 DSNIDBMF:5014 DURING RUNSTATS PK98017 2009-10-29 N/A UK51593 N/A ABEND04E RC00E4D5D2 WHEN COUNT(N) IS MISSING FROM RUNSTATS TS COLGROUP(COLUMN_NAME) HISTOGRAM FREQVAL PK98364 2009-12-11 UK52816 UK52817 N/A RUNSTATS WITH COLGROUP FAILS: ABND=04E-00E40206,M=(C),C=910.UTIL-UTILINIT,M=DSNTFRCV,LOC=D 09/11/24 PK98985 2010-01-18 N/A UK53640 N/A DB2 CAN'T FIND A MULTI COLUMN FREQUENCY ENTRY IN SYSCOLDIST THAT MATCHES WITH A SET OF PREDICATE VALUES RESULTING IN POOR PERF. PM01040 2009-12-21 UK53060 UK53061 N/A RUNSTATS OF LOB TS RECEIVES RC00C200C3 ABEND IS DSNB1REL +03A8 PM05586 2010-03-29 N/A UK55676 N/A SUBOPTIMAL ACCESSPATH FOR HIGHLY FILTERING QUERY PM12950 2010-06-30 N/A UK58440 N/A ABEND04E C90101 DSNIDBMF ERQUAL5014 PM13568 2010-08-05 N/A UK59493 N/A ABEND0C4 ON SINGLE PART RUNSTATS PM14629 2011-04-20 N/A UK59480 N/A SYSCOLDIST FREQ VALUE INCORRECT PM14701 2010-06-15 N/A UK57926 N/A RC00E20003 IX ON EXPR. AND NOT PADDED PM15203 2010-08-16 UK59686 UK59695 N/A SYSCOLDIST FREQ VAL INCORRECT COL OF PART IX PM15303 2010-06-11 UK57898 UK57899 N/A ABEND04E RUNSTATS TP AFTER ALTER ADD 200 PARTS PM15911 2010-08-16 UK59716 UK59717 N/A INCORRECT NUMBER OF FREQUENCY STATS COLLECTED IN SYSCOLDIST DURING RUNSTATS WITH DPSI'S AND MULTIPLE FREQVAL NUMCOL COUNT PM21630 2010-10-12 UK61272 UK61273 N/A Y BIG NUMBERS IN SYSINDEXES FIRST & FULLKEYCARDF PM21783 2011-01-31 N/A UK64418 N/A TOTALROWS NULL FOR DEFINE NO 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) PM24052 2010-12-17 UK63291 UK63292 N/A WRONG MULTI-COLUMN FREQUENCY STATS WITH RUNSTATS TABLESPACE PART TABLE COLGROUP PM24640 2010-12-16 N/A N/A UK63225 ABEND04E RC00E20013 AT DSNSGMN +1104X DURING RUNSTATS (UTILITY MEMORY LEAK) PM24903 2010-11-18 N/A UK62293 UK62292 RUNSTATS ABENDS WHEN STPRIN01 AND UTPRINT ARE MISSING. PM25131 2011-02-11 N/A N/A UK64795 COMPANION FIX FOR PM25130 PM25185 2011-01-27 UK64320 UK64321 UK64319 INCORRECT FREQUENCY VALUE IN SYSCOLDIST PM26343 2010-11-23 N/A UK62484 UK62483 ABENDS0C4 DSNUSAH1 +X'3024' HISTOGRAM PM27249 2011-05-17 N/A UK67817 UK67816 Y HISTOGRAM PRODUCES UNEVENLY DISTRIBUTED QUANTILES PM28118 2011-01-27 UK64308 N/A N/A INCORRECT VALUE OF FIRSTKEYCARDF PM28665 2011-02-21 UK65069 UK65070 N/A DB2 V9 RUNSTATS ABENDED WITH 0C4-000000011 ON MODULE DSNUGPPP+23BA PM28723 2011-02-25 N/A N/A UK65257 ABEND0C4 LOC=DSNIDM DSNKNXT2 OFFSETE6B0 WHEN RUNNING CHECK INDEX UTILITY, RUNSTATS UTIL PM28926 2011-02-04 UK64577 UK64578 UK64576 PERFORMANCE DEGRADATION OF RUNSTATS ON SECOND AND SUBSEQUENT EXECUTIONS PM31592 2011-03-24 N/A UK66091 UK66090 INCORRECT HIGH2KEY / LOW2KEY VALUES IN SYSCOLUMNS_HIST AFTER RUNSTATS UTILITY PM32196 2011-04-06 UK66511 UK66512 UK66510 HIGH2KEY / LOW2KEY MAY BE WRONG WITH NULL LENGTH VARCHAR PM32317 2011-03-29 N/A N/A UK66232 ABEND04E RC00E4070E DSNUGPRF +X'2310' AND RC00C90001 DURING RUNSTATS USE PROFILE PM32680 2011-05-03 N/A N/A UK67343 ABEND0C4 RC00000038 DSNXOTS1 OFFSET03C4, STAR JOIN PM33359 2011-04-19 N/A N/A UK66905 CLUSTERRATIO VALUE AFFECTS (SEGSIZE 32) SEGMENTED TS OR UTS TABLESPACE NEGATIVELY. PM34553 2011-06-06 N/A UK68515 UK68514 RUNSTATS ABENDS IN DSNUSIDX. SPATIAL INDEX IS INVOLVED PM35419 2011-04-08 N/A N/A UK66683 RUNSTATS TABLESPACE WITH TABLESAMPLE KEYWORD ABENDS 04E IN DSNIBMCL ERQUAL 500B PM35747 2011-04-22 UK66936 UK66974 UK66932 DB2 SORT FOR Z/OS FAILS WITH CNK153E SEVERELY UNDERESTIMATED FILESIZE UNDER RUNSTATS WITH COLGROUP AND FREQVAL SPECIFIED. PM38775 2011-06-09 N/A UK68680 UK68679 ABENDS0C4 RC8 DSNUSDST +X'18F4' DURING RUNSTATS PM42924 2011-09-01 N/A N/A UK70844 UNNEEDED SEQUENTIAL PREFETCH REQUESTS DURING RUNSTATS TABLESAMPLE PM43173 2011-08-31 N/A N/A UK71436 MESSAGE DSNU1370I IN A JOB OUTPUT HAS A TYPO. IT HAS THE WORD FOR TWICE IN SUCCESSION PM43236 2011-09-02 UK70300 UK70324 UK70299 RUNSTATS UPDATE NONE HISTORY ACCESSPATH UPDATED SYSIBM.SYSTABSTA PM45143 2011-11-18 N/A UK74012 UK74011 Y STORAGE OVERLAY DURING RUNSTATS HISTOGRAM PM45673 2011-08-31 N/A UK71270 UK71269 RUNSTATS REPORT YES GRABGE COLUMN NAME PM47094 2011-10-19 N/A UK73059 UK73058 RUNSTATS INDEX ON EXPRESSION WITH REPORT YES DSNU619I PM50742 2011-12-14 N/A UK74816 UK74815 ABND=04E-00E40204,C-910,M=DSNTFRCV,LOC=DSNUTILA,DSNUGSPC+0820 PM51089 2011-12-16 N/A UK74912 UK74911 INCORRECT VALUE OF FIRSTKEYCARDF IN SYSIBM.SYSINDEXES AFTER COLLECTING AGGREGATION INDEX STATISTICS WITH RUNSTATS PART PM52214 2011-12-09 N/A N/A UK74649 ABEND04E RC00C90101 DSNKTRAV:501B AFTER A RC00D3003C WAS RETURN FROM BUFFER MANAGER. PM54941 2012-03-01 N/A UK75780 UK75779 RUNSTATS WITH STATCLUS=STANDARD PLACES INCORRECT CLUSTERRATIO ON SYSINDEXES IN V910 CM PM55787 2012-03-07 N/A N/A UK76274 RUNSTATS DOES NOT UPDATE COL SPACEF ON SYSTABLESPACE UNTIL RUNNING STOSPACE AGAINST STOGROUP PM56677 2012-03-28 N/A N/A UK77452 INCORRECT CARDINALITY IN SYSIBM.SYSCOLDIST AFTER RUNSTATS WITHOUT KEYCARD ON MIGRATED PARTITIONED TABLESPACE PM60552 2012-04-16 N/A UK77973 UK77972 RUNSTATS INSERTS ROWS INTO RTS (REAL TIME STATISTICS) FOR DEFINE NO OBJECT PM60558 2012-04-16 N/A UK77999 UK77998 FIRSTKEYCARDF IN SYSIBM.SYSINDEXES IS INCORRECTLY SET AFTER A RUNSTATS ON A PARTITIONED TABLESPACE AFTER AN ALTER ROTATE PM63716 2012-08-16 N/A UK79645 UK79644 Y RUNSTATS RUNNING INDFINITELY, LOOPING OR ABENDING WITH ABEND04E RC00E20213 REASON 00C9004F PM65052 2012-08-08 N/A UK79647 UK79646 ABEND0CF IN DSNUSAH1+1E10 DURING RUNSTATS HISTOGRAM ON AN EMPTY TABLESPACE PM66139 2012-08-08 N/A UK79816 UK79815 ABEND04E DSNSGMN +X'05CA DURING RUNSTATS COLGROUP ON AN EMPTY TABLE SPACE. PM67274 2012-08-16 N/A UK81136 UK81135 PERFORMANCE DEGRADATION DUE TO RUNSTATS GENERATING NON-SEQUENTIA QUANTILE VALUES. PM67895 2012-09-19 Modified N/A N/A UK81931 RUNSTATS FAILED WITH 00E40214 WHEN USES PAGE SAMPLING AND NPAGES IS NEGATIVE. PM71413 2012-09-11 N/A N/A UK81723 ABEND04E IN DSNIDM.DSNIBNRF:5002 DURING RUNSTATS INDEX HISTORY ALL PM71778 Modified N/A N/A OPEN RUNSTATS ABEND X'00E2002F' AT DSNSVSFM+0794 PM73246 2012-11-11 Closed N/A N/A UK83431 RUNSTATS FAILS WITH ABEND 04E RC00E40005 PM75275 Open N/A OPEN N/A DATAREPEATFACTOR IN SYSIBM.SYSINDEXSTATS IS INCORRECTLY SET TO ZERO BY RUNSTATS INDEX AT PART LEVEL PM75290 Open N/A OPEN N/A RUNSTATS COLGROUP ON AN EMPTY TABLESPACE SETS INCORRECT POSITIVE VALUE FOR COLCARDF IN SYSIBM.SYSCOLUMNS PM76266 Open N/A N/A OPEN RUNSTATS TABLESAMPLE SYSTEM INCORROUT WITH CARD