APAR status
INTRAN
Error description
Following is a list of DB2 V7/V8/V9 SORT PTFs for customers that are utilizing SOSRT via RDS SQL Query, Performance, or DB2 Utilities DFSORT et.al. They are encouraged to be current with these RSE and * Hiper Service fixes. . In addition, please refer to DFSORT Info APARs II14296, II14047 and II14213. . APAR# V7PTF# V8PTF# V9 PUT 2007 LISTING FIRST to LAST --------------------------------------------------------------- PK36904/ v8-UK19337 0701*AE fix w/PK31410 PK37046/ v8-UK21887 0702*INCOR ORDER SEQ W/SUBSTR X ORDERBY PK37073/ v8-UK21835 0702 006 ICE006A REORG SORT >Runstats PK37681/UK21886,UK28186 0702*INCOR 1 SMJ TAB OBY from GBY Col PK37066/ v8-UK22540 0703 04E E40005 REORG TBS > IDX PART PARTITIONING TO TABLE PARTITIONING WITH ALTER PI TO NOT CLUSTER PK38319/ v8-UK22770 0703*INCOR IDX STAR JOIN ALL Join IDX PK37859/ v8-UK22306 0703 S522 HANG RUNSTATS COLGROUP Wait ECB PK37755/ v8-UK23349 0704 INCOR MISSING ROWS PART KEY LEN PAR PK39115/ UK23642-43 0704 PERF COMPCARD EST SUBQRY INNER TAB PK42312/ UK23982-83 0704 04E E40005 DSNUGSRP+064E CHK IDX PK43391/ v8-UK24914 0704 MSG OPTHINT SQLC395 REASON = '11' PK37829/UK24600,01-02 0705 PERF ACCESS PATH SORT OBY A OPTHINT PK38641/UK24713,UK24713 0705 UNNECESSARY SORT ON OUTER TABLE PK38796/ v8-UK24141 0705 04E C90101 DSNITCUS:5002. PK38988/ UK24973-74 0705 INCOR HIDDEN EXPLAIN TAB Output PK39942/#MR0222075222 FIN PERF INCONSISTENCIES NPGTHRSH PK41396/UK24044,UK24092 0705 SQLCOE404 SEL QRY W/OBY VARCHAR PAR PK41904/ UK24432-33 0705*Multi 0C4 RC38 DSNXOD8+16CA EXPL PK42501/ v9-UK24817 0705* INCOR STAR JOIN SPARSE IDX or PK42946/ v8-UK25532 0706 PERF REORG TBS PAR IDX BUILD TASKS PK43377/ v9-UK25385 0706 04E C90216 DSNIWNRF:53D1 WKFL PK43872/UK25493 0706 A03 CHECK LOB, TERM UTIL, Sort Task PK43939/UK25845 0706 PERF ACCESS POOR SMJ diff COL length PK44194/ UK25578-79 0706 PERF PAR TASKS NOT DIST EVENLY PK44731/ v9-UK25941 0706*INCOR MISSING ROWS PART KEY LENGTH PK41724/ v8-UK26429 0707 PERF CPU ESTI MULTI-COL SMJ PK42323/ R910-Up FIN SORT NOT EVALUATING SET FUNCTION PK43911/ v9-UK26442 0707 PERF POOR ACCESS on JOINING 2+ TABS PK44208/ UK26230-31 0707 INCOR GBY LIST NULLABLE DATA PAR PK45600/ UK27152-53 0707 04E E40005 ICE046A REORG AVGROWLEN PK42818/ v9-UK28287 0708 04E E40347 DFSORT on REORG TBS PK46555/ UK27590-91 0708 VARIOUS EXPL DSN_SORT_TABLE + Issues PK47088/ UK28077-78 0708 04E E70005 DSNXREOJ:M507 EOF Join PK47960/UK27802,03-04 0708* INCOR SEL COUNT(DISTINCT Inner TAB PK48056/UK28207 0708 0C7 DSNXVCDF+0264 COL=SUBQUERY Predicate PK48977/ v9-UK27805 0708* INCOR GBY NO LOCAL PREDICATES Sort PK45067/ UK29788-89 0710 04E E40005 DSNUGSRP +059C FILSZ REBUILD PK45376/ UK29761-62 0710 U010 MSGICE046A DSNTIJNE Sort Capacity PK47212/ v9-UK30045 0710 PERF IMPROVE PAR DEGREE REBUILD IDX PK52001/ UK29864-65 0710*INCOR MORE w/MULTI ENCODING SCHEME PK52927/ v9-UK30023 0710 PERF EXTRA SORT OBY MAY w/IDX X PK53153/ UK30117-18 0710 INCOR ACCESS SORT? MINIPLAN OPTHINT PK53042/ v8-UK35140 0710 PERF EST MATCH FILTERING INNER TAB PK53712/ v8-UK30042 0710 04E E40005 RUNSTATS ICE118I ICE046A PK53136/ UK31363-64 0711 04E C90101 DSNIWIPR 500B SORTS > 4G PK54814/ UK31242-43 0711 LOOP REBUILD INDEX UTIL Prev TBS RC=08 PK45599/ UK32059-60 0712 Z/OS ADMIN ENABLEMENT STORED PROC's PK46633/ UK31520-21 0712 SWITCH DSNTEJ6V SAMPLE CALLER DSNUTILS PK46633/ UK31520-21 0712 SWITCH DSNTEJ6V SAMPLE CALLER DSNUTILS PK52419/ UK32186-87 0712 04E E72018 DSNXSTSE+17B6 C9000B WKFL PK53174/ UK31556-57 0712*INCOR ORDER BY SORT? X Host:Var PK53324/ v8-UK31618 0712 04E E40005 E40347 DSNU044I RUNSTATS PK55235/ v9-UK31472 0712 SQLC670 SEL OBY MATCH/ORDERING IDX ACC PK55929/ UK32315-16 0712 INCOR 2Few MULTI COUNT(DISTINCT 64K GRP PK55938/UK32317,18-19 0712 04E E72200 DSNXSPRM M130 RIDMAP RIDLIST . APAR# V7PTF# V8PTF# V9 PUT 2008 LISTING FIRST to LAST --------------------------------------------------------------- PK55236/ UK32636-37 0801 04E E70005 DSNXESX2 BIND PKG DEG(ANY) PK55717/ UK32828-29 0801 INCOR 2MANY Incor PAR GRP IN-LIST PK57720/ v8,UK32645 0801*INCOR AVG ROW LEN CALC RUNSTATS TBS+ ICE046A SORT CAPACITY EXCEEDED PK41899/ v9,UK33636 0802 NF REMOVE SPECIFY SORTNUM UTIL PK45916/ v8,UK33692 0802 NF REMOVE SPECIFY SORTNUM UTIL PK55397/ UK33607-08 0802 SMS COMPRESSED CONCAT INCOR FILSZ PK56911/ UK33272-73 0802 04E E70005 DSNXOLCS:M30 PAR KeyRange PK59067// v9-UK33181 0802*INCOR RESULT TAB COL VALUE LOST PAR Group By more than one table PK60219// UK33961-62 0802 INCOR CHECK INDEX TERM >SORT DELAY PK57871/ UK34237-38 0803 Multi C90101 DSNIWNRF:5009 Sort WKFL PK59451// v9-UK33816 0803 UNNECESSARY SORT w/Acc HYBRID JOIN PK60057// v9-UK34497 0803 0C4 RC38 DSNXOLCM+84C2 HYBRID SORTC . PK38867/ UK35518-19 0804 NF Z/OS V1R9.0 SYSPLEX ZIIP PK61826// UK35133-34 0804 PERF DPSI NOT CHOSEN Sort Avoidance ACCESS PATH SELECTION IF ONLY ONE PARTITION QUALIFIES PK61888// v9-UK35332 0804 PERF DISCOURAGES NLJ, R-SCAN FOR OUTER JOINS containing Materialized WKFL, SMJ Better PK62064// v9-UK35539 0804 04E E20002 DSNSVBK+08B0, 0C4 RC11 DSNXOLCS+057E EXTEND PACK STORAGE FOR PAR KEY PROCESS PK58291/ UK36130-31 0805 NF ADMINI STORED PROC's EAV VOLumes PK64696// v8,UK36031 0805 VARIOUS ABENDS OVERLAY SPARSE IDX PK64915// v8,UK36331 0805 04E E40005 REBUILD IDX UTSORTAL PK66166// UK38111-12 0805 REORG S878-10 SORTWORK SORTNUM DFSORT PK60079// UK35968-69 0805*INCOR 2Many Nulls SMJ & PAR SORTC PK60943// UK35905-06 0805 REBUILD INDEX(ALL) DSNU706I DSNURBXC AFTER ALTER TABLE ROTATE PARTITION FIRST TO LAST PK61785// v9-UK35830 0805 INCOR AVGROWLEN > DFSORT REORG TBS W/PARTITION RANGE AFTER ALTER ADDED COLUMN PK62566// UK36409-10 0805 PERF COST CORR SUBQRY IN A PREDICATE AND INDEX ONLY PLAN IS USED IN THE SUBQRY BLOCK PK62650//UK35678-79 0805 0C4 RC04 DSNXRSOR +0180 NOT IN SUBQRY PK62956//UK36318-19 0805 INCOR STAR JOIN w/DPSI Sort next key PK63748//UK35732-33 0805 INCOR TWO SIMILAR JOBS THE SAME UNION QRY RUN AT THE SAME TIME WHICH USES SORT WKFL PK56084// v9-UK36565 0806 C90101 DSNISEGR:5013 WKFL Segment PK64209// v9-UK36788 0806*INCOR ALL ORDER BY OUT OF ORDER PK64624// UK36436-37 0806 0C4 DSNURBID+03DA LOAD MULTI PAR PART PK65889// v9,UK37123 0806*INCOR DISTINCT Select List w/GBy PK66300// v9-UK37122 0806 04E E40005 REORG TBS PAR DFSORT PK64446// UK37579-80 0807 04E E70005 DSNXRLPT & E72100 DSNXSPKY MULTI-COL SMJ FOLLOWS NLJ(S) LEAD TAB COL1=LIT0 PK65046// UK37799-800 807*INCOR SMJ LITERALS, JOIN PREDICATES PK65803// UK37581-82 0807 04E E70005 DSNXEFDA:M500 NLJ SORTC PAR PK66185// v9-UK38140 0807*INCOR IDX Chosen Group By Sort PK66441// UK38159-60 0807 04E E72100 DSNXSPKY+0502 HJ SORTC PK66454// v9-UK37476 0807 04E C90101 DSNIWNRF 5008 SMJ WKFL PK66597// UK37865-86 0807 0C4 RC11 E40345 LOAD SORTKEYS 0 PEM PK67231//UK37594,95-96 0807 0C4 RC11 DSNXSMRL+1090 SORT RIDMAP PK67356// v8-UK39163 0807 PERF NLJ R-SCAN Outer Joins SMJ PK67496// v9-UK37972 0807 DSNT408I DSNIWKFL RC6C >32K WKFL PK67771//v9-UK37917 0807 E40005 E40347 REORG ICE039A INLINE STATS . PK66960// UK38831-31 0808*0C4 D96001 DSNIDBGC+1784 INSERT Sort PK67339// UK38170-71 0808 PERF SMJ INNER TABLE VIEW or TABLEX PK70479//UK40084-84 0808 0C4 RC3B DSNXOCSK+3188 OUTER Join & SMJ PK63695//v9-UK38677 0808 INCOR SQLC670 DSNXOSOB SELECT ORDER BY PK65056// UK39503 0809*INCOR HYBRID JOIN on IN or EXISTS SUBQRY PK67351// UK39580-81 0809 Multi 04E 0C4 DSNIxxx Pair-Wise Joins PK68760// UK39303-04 0809 REORG TBS E40005 E40800 DFSORT PK69609//UK38985-86 0809 REORG TBS E40005 ICE006I AVGROWLEN DFSORT PK69656//v9-UK39188 0809 PERF DOCID XML & RID SORT IMPROVEMENTS PK70001// UK39566,68 0809 INCOR REORG RESTARTED UNLOAD UTSORTAL PK70345//UK39374-75 0809 TERM INCOR SHADOW DSN NOT DELETED SORTBUILD PK70366// v9-UK39641 0809*INCOR 2FEW SEL * OBY Reverse IDX Scan PK70494// UK39794-95 0809 0C4 DSNXSORI+04F2 ANCIENT SPL PK70631// UK39676-77 0809 INCOR NRF SQLC012 ON OPEN OLD PKG PK71121// v9-UK39796 0809 SQLPERF DISTINCT NO SORT SORT >WKFL PK67238// v9-UK39849 0810*INCOR Too Many SUBQRY, SORTC PAR PK67731// v9-UK39831 0810 PERF Poor IDX CORR SUBQRY DISTINCT PK70954// v9-UK40216 0810*INCOR 2FEW CASEX GROUP BY CLAUSE PK71193// UK40416-17 0810 INCOR NULL SMJ, DISTINCT Predicate PK71531// v9-UK40060 0810 MULTI ABENDS WKFL MIG V9 FALLBACK PK62733//v8-UK39631 0810 PERF CORR SUBQRY COST INNER TABLE NLJ USES SAME IDX AS THE SUBQUERY, SMJ Better . PK68222// UK41414-15 0811*INCOR CORR SUBQRY>UPPER QRYBLK SMJ PK71493// v9-UK41459 0811*0C4 RC11 DSNXPSEN +07F5 INVALID PIPE TYPE on DPSI IDX & PAR SORT KEYS PK72418// v9-UK41365 0811*INCOR NLJ SMJ w/GBY or OBY DESCENDING PK73295// v9-UK41057 0811*INCOR ORDER w/GBY ASC & OBY DESC PK73512// UK41558-59 0811*LOAD E40323 F30420 DB2 CRASH Window PK75718// v9-UK42238 0812*Abends SMCOVERLAY WKFLs DIFF Lengths PK73718// v9-UK42300 0812 PERF Poor NLJ w/SORTC PK74904// UK41967-68 0812 INCOR FILSZ LOAD SMS EXTENDED DSN PK75288// UK42441-42 0812*INCOR REVERSE DESC IDX SCAN W/RID PK65772// UK42083-94 0812 INCOR DSNTIJOS CCSID EXPLAIN DSN TABs PK71608// NRQ 0812 FILSZ=0 E40005 REORG UTSORTAL=NO RUNSTATS DFSORT INFO APARs II14296, II14047 and II14213 PK71715// v8-UK41363 0812*INCOR 2Few SEL * OBY REVERSE IDX SCAN PK71733// UK41940-41 0812 REORG ALLOC PAR FRAGMENTED SORT WORK PK72000// v9-UK42066 0812*INCOR PAR SORT & SMJ PK72360// UK41756-57 0812* SQLC301 DSNXRIHB hostvar OBy Case . APAR# V8PTF# V9 PUT 2009 Listing Lastest First --------------------------------------------------------------- PK69029//v9-UK43205 0901 MSGDSNT408I DSNT501I 6C WKFL LRG QRY PK69830//UK42190-91 0901*INCOR ORDER FieldProc COL OBY SUBSTR PK71463//v9-UK42448 0901 PERF HYBRID JOIN OR LIST PREFETCH UNDERESTIMATED # OF RIDS & TOTAL IDX FILTERIN PK75647//UK43070-71 09/01 IKJ56246I UTSORTAL=YES LOAD REPLACE & DYNAUTO = IGNWKDD DYNAMIC ALLOCATION FILE IN USE PK77451//v9-UK43159 0901 0C4-11 DSNIGWAC +202E Pairwise Join PK74357//v9-UK42795 0901 0C4 DSNXOGP +69DE SORT Key >32K PK74408//v9-UK42591 0901 INCORR SMJ, JOIN COL VARBINARY PK75291//UK42829-30 0901 INCOR AVGRLEL EXTERNAL FORMAT During PK76697//UK42860-61 0901 LOAD ICE046A TBS HOLD MANY IDXs PK72830//v9-UK42813 0901*INCOR PAY QRY w/GBY or DISTINCT pe< PK78415//UK43193-94 0901 04E C90101 DSNKISPL 5003 RESTORE SYSTEM PK77774/UK43598-608 0902 INCOR AVGROWLEN > DFSORT REORG TBS PK77384//UK43606-07 0902 INCOR MULTI-COL SMJ Nullable PREDI PK77472//UK43716-17 0902 0C4 RC04 DSNUGSTB X'E54' ENFM0127 PK78121//UK43923-24 0902*INCOR TAB UDF CALLED ONLY WHEN IT'S THE INNER TABLE IN SMJ PK79584//v8-UK45176 0902*INCOR ORDER, GBy & ORDER BY COUNT PK80454//v9-UK44893 0902 SQLC670 HYBRID JOIN w/SORT INNER TAB AND THE COMPOSITE SIZE EXCEEDS 32K . PK74325//UK44080-81 0903 04E E72088 DSNXSORM+29C0 WKFL FETCH PK79136//v9-UK44703 0903 INCOR EXCESS PAGING REBUILD IDX SORT PK78787//UK44821-22 0903 Multi-Abends SMJ or Star Join & PAR PK80204//v9-UK44827 0903*INCOR ORDER SEQ SEL DISTINCT W/OBY PK81133//UK44993-94 0903 REBUILD IDX UTSORTAL=YES PASSES FILSZ=E0 TO DFSORT FAILS w/ICE046A 04E E40005 . PK80947//UK45425-26 0904 REORG TERMINATES UNLOAD PHASE WHEN SYSIBM.SYSTABLESPACESTATS TOTALROWS ARE NEGATIVE -2 PK81579//UK44975-76 0904*INCOR CORR SUBQRY TRANSFORMED SINGLE JOIN PREDICATE BTWN THE TRANSFORMED & OUTER TABLES PK79832//v9-UK45641 0904 PERF Cost of NOT DISCOURAGING NLJ with Workfile doing TBS-SCAN when INNER JOINs exist PK79920//v8-UK45554 0904 R810 POOR PERF ACCESS PATH w/LIST PREFETCH, JOIN PREDICATES UNDERESTIMATE #RIDS 2SORT PK81576//v9-UK46375 0905 SQLC670 DSNXOSOB V9 MIG V8 Works PK75932//v9-UK46164 0905 04E E20002 DSNSVSVB+06C4 Cancel CUB PK81663//v8-UK46017 0905 INCOR 2FEW PAR GROUP Multi-SMJ PK84152//v9-UK46364 0905*INCOR 2FEW GROUPBY EXPRESSION IDX PK81663//v8-UK46017 0905*INCOR 2FEW PAR GROUP, MULTICOL SMJ PK82720//UK46525,27 0905 E40347 CHECK & REBUILD INDEX DFSORT ICE046A on Catalog TBS DSNDB06.SYSDBASE PK83210//UK46444-45 0905 E40005 REORG DFSORT ICE046A Invalid AVGRLEN on COMPRESSED TBS W/PARTITIONS EMPTY PK84578//v9-UK46265 0905*INCOR SUBQRY when SORT AVOIDED FOR SMJ, ORDER BY, OR GROUP BY IN the SUBQRY PK77228//UK46734-35 0906 INCOR MISC FIXES Z/OS INSTALL . PK85550//UK47595-96 09nn*INCOR 2Many PAR SORT OBy Set Funct PK84412//v9-UK47681 09nn REORG ELAPSE TIME INCREASE, per ALGORITHM IN THE PARALLEL SORT TASK PK84794//v9-UK46740 09nn PERF ACCESS PATH SUBQRY SELECT LIST INCLUDES A DECIMAL COLUMN AND OPTXQB IS ON PK84943//v9-UK46979 09nn SUB-OPTIMAL ACCESS PATH NON-READ ONLY CURSOR THAT HAS A NON-CORRELATED SUBQRY . PK75290// OPEN PERF OBD SHARING LOGIC, SORT WKFL TABs (MSGDSNT408I MSGDSNT501I RC6C TYPE00000D02) PK87657// OPEN PERF UNNECESSARY SORT on IDX OBY OR GBY PK87586// OPEN ICE046A OR E40005 LOAD REPLACE SORT PK88168// OPEN 04E C90101 DSNISRID:5013 Multi RIDLISTS PK88970// OPEN NF LOAD UTILITY SORT EST ENHANCEMENT PK88972// OPEN NF LOAD UTILITY SORT EST Multi-Tab PK88974// OPEN NF UNLOAD UTILITY SORT EST ENHANCEMENT . . . . ..... .....
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14502
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-29
Closed date
Last modified date
2009-06-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
29 June 2009