Upgrade DB2810, Subset HDB88100601B

  Preventive Service Planning

Upgrade DB2810, Subset HDB88100601B

Service Recommendation Summary Installation Information
Documentation Changes General Information
Service Recommendations Cross Product Dependencies
Informational/Documentation PTF/APAR Reference Lists


Upgrade DB2810, Subset HDB88100601B:

This subset contains installation information for DB2 BASE/TSO
Version 8, Release 1, Modification 0.

   * THIS SUBSET IS AN OVERFLOW SUBSET, PLEASE REFER TO SUBSET    *
   * HDB88100601A FOR PREVIOUS HIPER APARS & PTFS. 05/14/2009     *
*   NOTICE; THIS SUBSET HAS REACHED THE MAXIMUM RETRIEVAL LIMIT IN    *
*   RETAIN AS OF 08/11/2011.                                          *
*   ALL THE REMAINING HYPER APARS, PTFS AND FUTURE UPDATES ARE        *
*   CONTAINED IN OVERFLOW SUBSET HDB88100601C                         *


Change Summary

DATE LAST CHANGED SECTION 1. YY/MM/DD INSTALLATION INFORMATION NO ENTRIES 2. YY/MM/DD DOCUMENTATION CHANGES NO ENTRIES 3. YY/MM/DD GENERAL INFORMATION NO ENTRIES 4. 11/08/10 SERVICE RECOMMENDATIONS 5. YY/MM/DD CROSS PRODUCT DEPENDENCIES NO ENTRIES


Service Recommendation Summary

DATE APAR PTF VOLID COMMENTS 322 11/08/10 PM35799 UK70133 1000 HIPER ABEND0C4 IN DSNB1OFA+0BEA 321 11/08/10 PM42066 UK70085 1000 HIPER INCORROUT (LESS ROWS 320 11/08/05 PM37446 UK70046 1000 HIPER DB2 CATALOG MAY BE 319 11/08/05 PM42245 UK69882 1000 HIPER INCORROUT WHEN OPTIMIZER 318 11/08/04 PM37297 UK69826 1000 HIPER ABEND04E DSNIDBNG 317 11/08/04 PM38121 UK69719 1000 HIPER INCORROUT(NO ROWS 316 11/08/01 PM36512 UK69739 1107 HIPER ABEND0C7 DSNXRTIM 315 11/07/14 PM32423 UK69249 1107 HIPER WHEN USING TABLE UDFS WITH 314 11/06/29 PM38184 UK68707 1106 HIPER ABEND04E RC00D10330 AT 313 11/06/27 PM40595 UK68620 1106 HIPER ABND=04E-00D92023 ABEND04E 312 11/06/23 PM22732 UK63055 1012 HIPER BROKEN PAGE AFTER MVS 311 11/06/22 PM28618 UK68462 1106 HIPER AN INVALID SQLCODE -180 IS 310 11/06/22 PM38068 UK68456 1106 HIPER ABND=0C4-11 309 11/06/13 PM34969 UK68197 1106 HIPER V10/V9 CO-EXIT 308 11/06/13 PM38120 UK68148 1106 HIPER RC00E4010A COPY UTILITY 307 11/06/06 PM34593 UK67871 1106 HIPER DB2 SUBSYSTEM TERMINATION 306 11/06/03 PM35394 UK67829 1106 HIPER SQLINCORROUT NO ROW FOUND 305 11/06/02 PM20766 UK67724 1105 HIPER Serviceability 304 11/05/30 PM33791 UK67632 1105 HIPER LOAD CHAR->GRAPHIC W/CCSID 303 11/05/23 PM35062 UK67468 1105 HIPER ABEND04E RC00E20033 302 11/05/19 PM31524 UK67329 1105 HIPER DURING INSERT OF NULL 301 11/05/19 PM32398 UK67394 1105 HIPER RC00E20027 300 11/05/18 PM31732 UK67316 1105 HIPER ABEND0C4 0000003B LOC 299 11/05/18 PM33955 UK67290 1105 HIPER IncorrOut or ABEND04E 298 11/05/11 PM34554 UK67070 1105 HIPER CHECK DATA TABLESPACE 297 11/04/25 PM30567 UK66531 1104 HIPER LONG RUNNING DB2 RESTART 296 11/04/22 PM33480 UK66507 1104 HIPER VARIOUS ABEND0C4 ABENDS 295 11/04/18 PM31396 UK66341 1104 HIPER INCORROUT (LESS ROW FOUND) 294 11/04/14 PM30773 UK66181 1104 HIPER ROW NOT FOUND CONDITION 293 11/04/08 PM30995 UK65980 1104 HIPER ABEND0C4 RC00000038 RC38 292 11/04/04 PM26389 UK65805 1103 HIPER ABEND04E RC00C90101 291 11/04/04 PM31305 UK65589 1103 HIPER MSGDSNP011I RC00D70014 AND 290 11/03/25 PM25451 UK65585 1103 HIPER INCORROUT NO ROW FOUND 289 11/03/21 PM28413 UK65238 1103 HIPER OLD BUFFER POOL IS USED 288 11/03/21 PM28825 UK65401 1103 HIPER ABEND04E RC00C20305 AT LOC 287 11/03/14 PM27493 UK65161 1103 HIPER ABEND0C4 IN DSNB1GET+02D4 286 11/03/03 PM24660 UK64853 1103 HIPER WHEN SPECIFYING -STA 285 11/03/03 PM26087 UK63987 1102 HIPER DB2 GOT ABEND04E 284 11/03/02 PM25247 UK64818 1102 HIPER INCORROUT (NO ROW FOUND) 283 11/03/02 PM27286 UK64799 1102 HIPER ABEND0C4 IN DSNSVBK+09A0 282 11/03/02 PM31197 UK64813 1102 HIPER 04E-00D31010 281 11/02/25 PM23025 UK64670 1102 HIPER INCORROUT OR POOR 280 11/02/21 PM21785 UK64532 1102 HIPER ABEND04E RC00C90101 279 11/02/18 PM15044 UK59901 1009 HIPER ABEND04E 00E20006 278 11/02/18 PM23401 UK64485 1102 HIPER ABEND04E RC00E70005 277 11/02/16 PM23169 UK64410 1102 HIPER ABEND04E RC00C90101 276 11/02/16 PM25870 UK64377 1102 HIPER PERFORMANCE DEGRADATION ON 275 11/02/11 PM24273 UK64186 1102 HIPER INCORROUT (NO ROW FOUND) 274 11/02/10 PM26888 UK64179 1102 HIPER ABEND0C4 RC4 AT DSNXGINL 273 11/02/09 PM28310 UK64168 1102 HIPER ABEND 04E RC00C200B0 LOC 272 11/02/09 PM28968 UK64160 1102 HIPER CASTOUT ABEND 04E 00E20006 271 11/02/03 PM27253 UK63993 1102 HIPER INCORROUT (WRONG VALUE 270 11/01/31 PM25966 UK63956 1101 HIPER ABEND 04E - 00C90101 IN 269 11/01/28 PM25906 UK63873 1101 HIPER ABEND04E 00C90101 268 11/01/26 PM28586 UK63766 1101 HIPER DATA IN QW0125PC IS 267 11/01/21 PM22534 UK63681 1101 HIPER ABEND0C4-38 DSNXOSL + 1CCE 266 11/01/21 PM26957 UK63685 1101 HIPER UNDER GLOBAL TRANSACTION, 265 11/01/14 PM21858 UK63550 1101 HIPER DB2 GOT ABEND04E 264 11/01/12 PM25187 UK63515 1101 HIPER INCORROUT (WRONG VALUE 263 10/12/31 PM26751 UK63146 1012 HIPER INCORRECT OUTPUT CAN BE 262 10/12/29 PM21099 UK63024 1012 HIPER DEFECT 129802 SQLCODE -270 261 10/12/23 PM23356 UK62846 1012 HIPER ABEND04E ABEND0C4 DUE TO 260 10/12/17 PM22748 UK62693 1012 HIPER INCONSISTENT BEHAVIOR 259 10/12/16 PM24729 UK62657 1012 HIPER DATA BROKEN IF QUIESCE 258 10/12/10 PM08604 UK62505 1012 HIPER INCORRECT OUTPUT MAY OCCUR 257 10/12/09 PM19359 UK62460 1012 HIPER ABEND 04E RC00C90101 256 10/12/01 PM23990 UK62071 1011 HIPER EXCESSIVE DB2 ABEND04E 255 10/12/01 PM24930 UK62114 1011 HIPER MISSING INDEX ENTRY IS 254 10/11/24 PM22854 UK61978 1011 HIPER ABEND0C4 RC00000004 FROM 253 10/11/22 PM20917 UK61870 1011 HIPER INCORRECT OUTPUT WITH FULL 252 10/11/22 PM23791 UK61922 1011 HIPER ABEND0C4 IN DSNB1CMS + 251 10/11/15 PM22255 UK61699 1011 HIPER SQL QUERY RECEIVED 250 10/11/15 PM22768 UK61777 1011 HIPER ACCESS PATH REGRESSION 249 10/11/11 PM16611 UK61648 1011 HIPER ABEND04E RC00E20016 IN 248 10/11/08 PM20811 UK61539 1011 HIPER SELECT COUNT(*) TO GET 247 10/11/08 PM21042 UK61590 1011 HIPER MANY 0C4 ABENDS BECAUSE 246 10/11/04 PM20429 UK61442 1011 HIPER INCORROUT (LESS ROW FOUND) 245 10/11/03 PM21465 UK61436 1011 HIPER ABEND04F 00E50702 AFTER 244 10/11/03 PM21683 UK61376 1011 HIPER ABEND04E 00E20025 U=SYSOPR 243 10/11/03 PM23587 UK61433 1011 HIPER PHB LATCH NOT RELEASED 242 10/10/29 PM13814 UK60423 1010 HIPER DSNKUNR2:500F DURING 241 10/10/29 PM20114 UK61276 1010 HIPER DGTT CANCEL RESULTS IN 240 10/10/29 PM21630 UK61272 1010 HIPER BIG NUMBERS IN 239 10/10/29 PM22712 UK60423 1010 HIPER AE PM13814 FIX COMPLETION 238 10/10/29 PM23051 UK61108 1010 HIPER ABEND0C4 IN DSNIARPL+3BF4 237 10/10/28 PM18271 UK61235 1010 HIPER INCORROUT (WRONG VALUE) ON 236 10/10/22 PM21663 UK61111 1010 HIPER PROBLEM WITH LPL RECOVERY 235 10/10/14 PM21054 UK60827 1010 HIPER ABEND0C4 RC38 OR RC11 FROM 234 10/10/07 PM19241 UK60522 1010 HIPER INCORROUT NRF AFTER ALTER 233 10/10/01 PM19796 UK60459 1009 HIPER ABEND04E 00C90101 WITH 232 10/09/29 PM20394 UK60412 1009 HIPER VARCHAR DATA GETS 231 10/09/27 PM17813 UK60343 1009 HIPER RETROFIT V9 ENHANCEMENT IN 230 10/09/23 PM17437 UK60309 1009 HIPER LESS ROWS THAN EXPECTED 229 10/09/20 PM18445 UK60182 1009 HIPER DB2 GOT ABEND0C4 PIC11 IN 228 10/09/13 PM11823 UK60082 1009 HIPER AGL STORAGE POOL NOT 227 10/09/09 PM16156 UK59788 1009 HIPER LOAD DELIMITED FAILS WITH 226 10/09/06 PM16609 UK59816 1009 HIPER ABEND04E IN DSNIFLWD 225 10/09/06 PM20250 UK59814 1009 HIPER DB2 GROUP RESTART WILL NOT 224 10/09/03 PM17916 UK59740 1009 HIPER DB2 ABEND WITH 223 10/09/01 PM15502 UK59688 1008 HIPER ABEND0C4 RECOVERY LOOP 222 10/09/01 PM18072 UK59569 1008 HIPER COPY UTILITY SKIPS COPYING 221 10/08/27 PM16879 UK59567 1008 HIPER ABEND04E RC00C90101 220 10/08/24 PM15572 UK59420 1008 HIPER ABEND04E RSN00E20003 CT 219 10/08/23 PM01474 UK54416 1003 HIPER DB2 RESTART FAILS 04E 218 10/08/19 PM17794 UK59408 1008 HIPER CLIENT SENDING LOB DATA 217 10/08/18 PM13375 UK59359 1008 HIPER INCORROUT INCORRECT OUTPUT 216 10/08/11 PM11062 UK59107 1008 HIPER SQLCODE -206 SHOULD BE 215 10/08/04 PK98114 UK58900 1008 HIPER DB2 SUBSYSTEM TERMINATION 214 10/08/04 PM07464 UK58742 1008 HIPER SQLCODE100 OR +100 213 10/08/04 PM14102 UK58902 1008 HIPER RC00F30411 WHEN ALLIED 212 10/08/02 PM17827 UK58879 1007 HIPER ABEND04E RC00E2000E FROM 211 10/07/30 PM14949 UK58790 1007 HIPER ABEND04E RC00E70005 IN 210 10/07/28 PM06743 UK58737 1007 HIPER INCORRECT OUTPUT (MORE 209 10/07/28 PM14381 UK58747 1007 HIPER SQLCODE904 MSGDSNT501I 208 10/07/26 PM12617 UK58695 1007 HIPER ABEND0C4 IN DSNLISKM WHEN 207 10/07/26 PM12906 UK58591 1007 HIPER INCORROUT USING MAX 206 10/07/26 PM13629 UK58690 1007 HIPER ABEND0C4-00000011 IN 205 10/07/12 PK80760 UK58206 1007 HIPER DEFECT 134796. LOBS USED 204 10/07/12 PM12495 UK58286 1007 HIPER INCORRECT OUTPUT WITH 203 10/07/12 PM14301 UK58132 1007 HIPER ABEND04E 00C90101 DSNICTBU 202 10/07/08 PM13658 UK58105 1007 HIPER ABEND04E RC00F30801 FROM 201 10/07/08 PM15060 UK58064 1007 HIPER POSSIBLE DATA LOSS WHEN IN 200 10/07/05 PM12779 UK58029 1007 HIPER ABEND04E RC00E20002 IN 199 10/07/02 PM13732 UK57924 1006 HIPER CORRUPTED INDEX AFTER LOCK 198 10/06/23 PM08414 UK57689 1006 HIPER IF CCSID CONVERSION AND 197 10/06/23 PM10994 UK57683 1006 HIPER ABEND04E RC00E20006 196 10/06/23 PM11485 UK57656 1006 HIPER DB2 ABEND04E 00C90101 FROM 195 10/06/23 PM13108 UK57658 1006 HIPER ABEND04E RC00E20006 ON A 194 10/06/17 PM05664 UK57322 1006 HIPER POOR PERFORMANCE OF XML 193 10/06/17 PM08112 UK57514 1006 HIPER DB2 LOAD DELIMITED FORMAT 192 10/06/17 PM09961 UK57516 1006 HIPER REORG PART RANGE REBALANCE 191 10/06/14 PM05657 UK57313 1006 HIPER 04E-00E20005 ABEND WHEN 190 10/06/14 PM09542 UK57307 1006 HIPER ABND=0C4 189 10/06/14 PM13798 UK57318 1006 HIPER AFTER AGENT GETS HIT A 188 10/06/10 PK97922 UK51937 0911 HIPER ABEND0C4 RC00000004 FROM 187 10/06/08 PM13452 UK57135 1006 HIPER INCORROUT (TOO FEW ROWS) 186 10/06/04 PM05717 UK56880 1006 HIPER INCORROUT WHEN A QUERY 185 10/05/31 PM11441 UK56911 1005 HIPER LONG RUNNING BACKOUT 184 10/05/31 PM11446 UK56909 1005 HIPER DSNI021I INCORRECTLY 183 10/05/31 PM12294 UK56913 1005 HIPER DB2 RESTART FAILURE WITH 182 10/05/26 PM05736 UK56800 1005 HIPER CAN'T RECOVER 181 10/05/24 PM10650 UK56753 1005 HIPER DSNIIDIS:5002 WHEN QUERY 180 10/05/17 PM09544 UK56404 1005 HIPER ABEND04E RC00C90101 FROM 179 10/05/12 PM09909 UK56334 1005 HIPER PERFORMANCE DEGRADATION, 178 10/05/10 PM01867 UK55766 1005 HIPER DB2 V8 LOAD FAILED WITH 177 10/05/07 PM08098 UK56285 1005 HIPER DB2 CRASHES AFTER 176 10/05/07 PM08638 UK56261 1005 HIPER ABEND0C4 IN DSNSTACK 175 10/05/07 PM11360 UK56289 1005 HIPER INCORROUT (TOO MANY ROWS) 174 10/05/05 PM06992 UK56122 1005 HIPER STORAGE LEAK CAUSED BY 173 10/04/23 PM05879 UK55764 1004 HIPER ABEND04E RC00E30001 172 10/04/22 PM04569 UK55819 1004 HIPER ABEND04E RC00E70005 IN 171 10/04/22 PM08970 UK55840 1004 HIPER INCORROUT (NO ROWS FOUND) 170 10/04/19 PK76676 UK47686 0907 HIPER MISS CLASSIFICATION ON 169 10/04/19 PM01529 UK55769 1004 HIPER ABEND04E RC00E72018 AT 168 10/04/19 PM09277 UK55762 1004 HIPER SQLCODE310 FROM DSNXRIHS 167 10/04/16 PM07129 UK55742 1004 HIPER RC00C900F7 AFTER LOAD 166 10/04/15 PM06118 UK55700 1004 HIPER ABEND04E RC00C90101 165 10/04/15 PM10548 UK55697 1004 HIPER RECOVERY FOR ABEND0C4 164 10/04/12 PM05402 UK55458 1004 HIPER INCORROUT (LESS ROWS 163 10/04/08 PM08725 UK55487 1004 HIPER RETROFIT PM06933 TO V8 162 10/04/08 PM08726 UK55488 1004 HIPER RETROFIT PM07357 TO V8 161 10/03/31 PM07460 UK55184 1003 HIPER ABEND04E RC00C20221 IN 160 10/03/29 PM04441 UK55108 1003 HIPER RECOVER - FAIL WITH 159 10/03/29 PM07258 UK55106 1003 HIPER INCONSISTENT DATA OR 158 10/03/29 PM07734 UK55039 1003 HIPER D134804. AN INCORRECT 157 10/03/29 PM07735 UK55042 1003 HIPER ABEND0C7 DSNXVCDF +2FC FOR 156 10/03/25 PK85279 UK54960 1003 HIPER ABEND04E RC00C90101 IN 155 10/03/22 PM07106 UK54933 1003 HIPER INCORROUT VIEW AND LEFT 154 10/03/15 PM03834 UK54694 1003 HIPER INCORROUT (LESS ROW FOUND) 153 10/03/12 PM03397 UK54578 1003 HIPER INCORRECT OUTPUT NRF WITH 152 10/03/08 PK91699 UK54451 1003 HIPER LOAD DATA LOG NO UTILITY 151 10/03/08 PM03655 UK54510 1003 HIPER ABEND=04E-00C90101, 150 10/03/05 PM01604 UK54421 1003 HIPER ABEND04E RC00E20004 149 10/03/05 PM03163 UK54438 1003 HIPER ABEND04E RC00E20015 148 10/03/04 PM03869 UK54384 1003 HIPER ECSA SHORTAGE MSGDXR175E 147 10/03/03 PK26951 UK17114 0608 HIPER TOO FEW ROWS RETURNED ON 146 10/03/03 PM02648 UK54358 1003 HIPER ABEND 00C90101 IN DSNOLADS 145 10/03/01 PM04371 UK54316 1002 HIPER PSEUDO CLOSE INTERRUPTED 144 10/02/26 PK93254 UK54257 1002 HIPER ABEND 0C4 IN DSNIDBMS + 143 10/02/25 PM04673 UK54245 1002 HIPER INCORROUT: BINARY ZEROES 142 10/02/24 PK92795 UK54178 1002 HIPER ABEND0C4 RC00000004 AT 141 10/02/24 PM04035 UK54478 1002 HIPER INCORRECT SQLCODE538 140 10/02/22 PK90476 UK54112 1002 HIPER DB2 SUBSYSTEM TERMINATION 139 10/02/17 PK97007 UK54011 1002 HIPER AN INCORRECT OUTPUT WITH 138 10/02/17 PM00661 UK54038 1002 HIPER INCORROUT WITH A VIEW ON A 137 10/02/12 PK91135 UK52099 1002 HIPER WEBSPHERE APPLICATION 136 10/02/12 PM03247 UK53872 1002 HIPER INCORRECT OUTPUT WITH 135 10/02/09 PK97744 UK53738 1002 HIPER ABEND04E RC00E70005 134 10/02/09 PM02696 UK53810 1002 HIPER ABND04E RC00C200C3 133 10/02/08 PK99133 UK53710 1002 HIPER TOO MANY ROWS THAT DON'T 132 10/02/05 PM02631 UK53682 1002 HIPER ABEND04E RC00C90101 IN 131 10/02/04 PK99092 UK53641 1002 HIPER INCORROUT (NO ROW FOUND) 130 10/02/03 PM02674 UK53563 1002 HIPER ABEND04E RC00C90101 IN 129 10/01/28 PM02366 UK53374 1001 HIPER DATA IN WRONG PART AND 128 10/01/27 PM01154 UK53464 1001 HIPER ABND04E-00C90101 127 10/01/25 PM00604 UK53423 1001 HIPER DB2DSHR 910 NFM CRASH WITH 126 10/01/25 PM02042 UK53411 1001 HIPER ABEND0C4 AT 125 10/01/25 PM04012 UK53421 1001 HIPER ABEND04E RC00C90101 124 10/01/22 PM00229 UK53364 1001 HIPER INCORROUT WHEN SET 123 10/01/21 PM00934 UK52456 1001 HIPER REPAIR DBD TEST INDICATES 122 10/01/21 PM01252 UK53329 1001 HIPER 04E 00C90101 ABEND IN 121 10/01/20 PK93631 UK53278 1001 HIPER LOOP AFTER I/O ERRORS ON 120 10/01/20 PK97088 UK53300 1001 HIPER REORG WITH SORTDATA NO AND 119 10/01/20 PM01199 UK53321 1001 HIPER ABEND04E RC00C90101 IN 118 10/01/20 PM01434 UK53306 1001 HIPER INCORROUT ON A QUERY WITH 117 10/01/18 PK89926 UK49949 0909 HIPER CUR BLOCK NOT FREED WHICH 116 09/12/31 PM00860 UK52863 0912 HIPER AB04E DSNXXXXX . DSNSVBK 115 09/12/28 PK98592 UK52810 0912 HIPER INCORROUT NO ROW FOUND NRF 114 09/12/16 PK97013 UK52318 0912 HIPER INCORROUT OF QUERY WITH 113 09/12/16 PM01819 UK52393 0912 HIPER INCREASE IN E/CSA AND 112 09/12/11 PK97008 UK52253 0912 HIPER INCORROUT (MORE ROW FOUND) 111 09/12/11 PK98422 UK52261 0912 HIPER DSNU713I (MSGDSNU713I) 110 09/12/11 PK99468 UK52279 0912 HIPER SQLCODE919 FROM DSNXERT 109 09/12/11 PM01227 UK52304 0912 HIPER 0C4-11 LOAD PARTITION 108 09/12/09 PK94570 UK52198 0912 HIPER ABND=0C4-00000004 107 09/12/09 PK97914 UK52194 0912 HIPER ABEND04E-00C200BD IN 106 09/12/09 PK99747 UK52192 0912 HIPER INCOMPATIBLE RETAINED 105 09/12/02 PK94548 UK51903 0911 HIPER INCORROUT NO ROW FOUND NRF 104 09/12/02 PK96530 UK51743 0911 HIPER QUERY RECEIVES LESS ROWS 103 09/11/27 PK97679 UK51843 0911 HIPER ABEND04E RC00E50003 FROM 102 09/11/26 PK84589 UK51795 0911 HIPER INCORROUT ON QUERY WITH 101 09/11/23 PK91770 UK51710 0911 HIPER COLUMN TRUNCATED WHEN 100 09/11/20 PK98270 UK51708 0911 HIPER 00C90101 DSNODAL1:5003 DUE 99 09/11/17 PK94571 UK51663 0911 HIPER DATA SHARING - ABEND0C4 IN 98 09/11/16 PK89057 UK51514 0911 HIPER INCORRECT OUTPUT AFTER 97 09/11/16 PK97897 UK51547 0911 HIPER ABEND04E RC00E70005 IN 96 09/11/13 PK96508 UK51462 0911 HIPER SELECT WITH A SET FUNCTION 95 09/11/12 PK92642 UK51406 0911 HIPER ABEND04E RC00E70005 94 09/11/09 PK77767 UK51213 0911 HIPER BIND WHILE IN ENFM CAUSING 93 09/11/09 PK93345 UK51274 0911 HIPER ABND=04E-00C90101 WITH 92 09/11/05 PK96623 UK51204 0911 HIPER UNLOAD DELIMITED WITH 91 09/11/02 PK91597 UK51135 0910 HIPER ABEND0C4 RC11 DSNXGRDS 90 09/10/29 PK97705 UK50988 0910 HIPER DB2 SUBSYSTEM TERMINATION 89 09/10/28 PK95958 UK50975 0910 HIPER DB2 MAY HANG AFTER A 88 09/10/22 PK93237 UK50795 0910 HIPER INCORROUT WHEN RUNNING 87 09/10/22 PK96278 UK50817 0910 HIPER DB2 COPROCESSOR PROBLEM 86 09/10/20 PK93422 UK50704 0910 HIPER LOOP IN DB2 ISSUING A PAGE 85 09/10/16 PK90875 UK50614 0910 HIPER 84 09/10/13 PK91403 UK50447 0910 HIPER LOAD UTILITY INLINE COPY 83 09/10/13 PK96494 UK50567 0910 HIPER ABEND0C4 RC04 IN DSNJPOPN 82 09/10/12 PK56334 UK36073 0805 HIPER ABEND04E RC00C90101 81 09/10/12 PK85482 UK50461 0910 HIPER SQLCODE407 WHEN RUNNING AN 80 09/10/12 PK90413 UK50369 0910 HIPER INCORROUT WITH INTEGER 79 09/10/12 PK92801 UK50372 0910 HIPER VARIOUS STORAGE-RELATED 78 09/10/12 PK94876 UK50357 0910 HIPER INCORRECT SQLCODE100 NRF 77 09/10/08 PK76769 UK43266 0902 HIPER DB2 TERMINATED WITH 76 09/10/02 PK93683 UK50168 0909 HIPER AFTER SYSTEM RESET AN 75 09/09/28 PK90182 UK49937 0909 HIPER INCORROUT OUTER JOIN AND 74 09/09/28 PK92184 UK49965 0909 HIPER INCORROUT (MORE ROWS) FOR 73 09/09/23 PK85042 UK49760 0909 HIPER ABEND0C7 IN LMOD DSNIDM 72 09/09/17 PK83248 UK49721 0909 HIPER ABEND04E-00E70005 DSNXI14 71 09/09/16 PK92961 UK49718 0909 HIPER 04E-00D94002 DSNRUA02 IF 70 09/09/14 PK89364 UK49619 0909 HIPER ABEND0C6 IN DSNUSTBL+4E7A 69 09/09/14 PK90120 UK49599 0909 HIPER DATA LOSS OF ENTIRE PART 68 09/09/14 PK92718 UK49494 0909 HIPER RC00C90101 DSNICUMW 67 09/09/11 PK90935 UK49580 0909 HIPER ABEND04E RC00E20016 IN 66 09/09/11 PK93042 UK49692 0909 HIPER INCORROUT (LESS ROW 65 09/09/10 PK88917 UK49539 0909 HIPER STORED PROCEDURE USING 64 09/09/10 PK90521 UK49455 0909 HIPER INCORROUT FEWER ROWS FOR 63 09/09/07 PK88834 UK49428 0909 HIPER GLOBAL TRANSACTION 62 09/09/04 PK88224 UK49337 0909 HIPER EDM POOL FULL ABEND04E 61 09/08/28 PK87570 UK49164 0908 HIPER ABEND04E RC00E70005 60 09/08/27 PK85002 UK49145 0908 HIPER DB2 ABEND WITH 00E50048 OR 59 09/08/26 PK80244 UK49125 0908 HIPER ABEND04E RC00C90101 58 09/08/26 PK91344 UK49122 0908 HIPER WHEN RUNNING THE LOAD 57 09/08/19 PK91277 UK48960 0908 HIPER LOOP IN DSNB1SWS TRYING TO 56 09/08/17 PK87842 UK48717 0908 HIPER 55 09/08/17 PK87935 UK48804 0908 HIPER INCORRECT OUTPUT OF SELECT 54 09/08/17 PK88978 UK48931 0908 HIPER RETAINED LOCKS ( 53 09/08/13 PK87559 UK48724 0908 HIPER MIGRATION JOB DSNTIJEN 52 09/08/13 PK88282 UK48770 0908 HIPER 00C90101 IN DSNIARPL 51 09/08/12 PK89202 UK48714 0908 HIPER ORDER BY MAY NOT PRODUCE 50 09/08/10 PK86619 UK48380 0908 HIPER VARIOUS ABENDS DUE TO 49 09/08/07 PK87130 UK48546 0908 HIPER ABEND04E RC00C90101 48 09/08/05 PK82197 UK45485 0904 HIPER ABEND0C6 IN DSNICMT2 + 47 09/08/05 PK86168 UK48505 0908 HIPER INCORROUT (LESS ROW FOUND) 46 09/07/29 PK81874 UK48294 0907 HIPER SYSTEM CRASH CAUSED BY 45 09/07/29 PK88394 UK48296 0907 HIPER BROKEN DATA AFTER 44 09/07/29 PK89454 UK48300 0907 HIPER ABEND0C4-00000004 IN 43 09/07/23 PK85808 UK48154 0907 HIPER QUERY USING DPSI INDEX 42 09/07/23 PK88508 UK48110 0907 HIPER INCORRECT OUTPUT FROM 41 09/07/23 PK88963 UK48171 0907 HIPER ABEND40D-10 OR ABEND878 40 09/07/23 PK90540 UK48503 0907 HIPER INCORROUT IN V9 WHEN 39 09/07/22 PK88299 UK48066 0907 HIPER SQLCODE204 DUE TO CURRENT 38 09/07/15 PK71208 UK47885 0907 HIPER QUERY USING INDEX ACCESS 37 09/07/15 PK73452 UK47862 0907 HIPER ABEND04E RC00E70005 AT 36 09/07/15 PK84394 UK47902 0907 HIPER INCORROUT (NO ROW FOUND) 35 09/07/13 PK88278 UK47835 0907 HIPER ABEND04E RC00E50097 34 09/07/10 PK77603 UK45359 0904 HIPER ABEND=04E-00C90101 AT 33 09/07/10 PK86403 UK47717 0907 HIPER DB2 CRASHED AFTER BELOW 32 09/07/09 PK81214 UK47644 0907 HIPER INCORROUT WHEN USING 31 09/07/09 PK85550 UK47595 0907 HIPER INCORROUT (TOO MANY ROWS) 30 09/07/09 PK85890 UK47584 0907 HIPER ABEND04E 00C90101 DSNOLDEL 29 09/07/09 PK87666 UK47651 0907 HIPER INCORROUT (NRF) WHEN 28 09/07/06 PK83005 UK47538 0907 HIPER ABEND04E RC00C90101 IN 27 09/07/02 PK81706 UK47468 0906 HIPER INCORRECT OUTPUT IN A LOOP 26 09/06/29 PK85499 UK47320 0906 HIPER INCORRECT OUTPUT NRF WITH 25 09/06/29 PK86537 UK47392 0906 HIPER ABEND0C7 DSNXVCDF+02E4 24 09/06/25 PK85985 UK47286 0906 HIPER LOAD RESUME YES ON A 23 09/06/24 PK85539 UK47270 0906 HIPER INSERT LOOP FOR 22 09/06/22 PK80210 UK47178 0906 HIPER ABEND04E RC00E20017 AT 21 09/06/17 PK85188 UK47033 0906 HIPER INCORRECT OUTPUT MAY OCCUR 20 09/06/15 PK85049 UK46973 0906 HIPER DSNIDBGC:5017 IN ALL 19 09/06/12 PK82886 UK46901 0906 HIPER PAUSE ELEMENTS SSD REMAIN 18 09/06/09 PK82254 UK46842 0906 HIPER INCORROUT (WRONG VALUE 17 09/06/03 PK85271 UK46662 0906 HIPER REORG ERROR ALLOCATING 16 09/06/01 PK81110 UK46623 0905 HIPER ABND=04E-00C200D8 15 09/06/01 PK83374 UK46619 0905 HIPER POOR INSERT PERFORMANCE 14 09/06/01 PK83952 UK46611 0905 HIPER INCORRECT OUTPUT FOR THE 13 09/05/29 PK82166 UK46098 0905 HIPER ABEND073-RC8 S073-8 12 09/05/25 PK77382 UK43892 0902 HIPER INCORROUT WRONG ORDER WHEN 11 09/05/25 PK78126 UK45840 0905 HIPER INCORROUT (WRONG VALUE 10 09/05/25 PK78877 UK43831 0902 HIPER BYTE 255-257 DISAPPEARS IN 9 09/05/25 PK79220 UK44391 0903 HIPER FETCHING FROM CLOB USING 8 09/05/25 PK81394 UK46347 0905 HIPER PRODUCTION CRASH WHEN 7 09/05/25 PK81406 UK46339 0905 HIPER SQLCODE545 ISSUED 6 09/05/25 PK82169 UK46342 0905 HIPER INCORRECT VALUE FOR 5 09/05/25 PK82220 UK46327 0905 HIPER UNLOAD DOES NOT HONOR 4 09/05/25 PK83419 UK46329 0905 HIPER LOAD MIEXED DATA 3 09/05/22 PK81413 UK46312 0905 HIPER INCORROUT MAY OCCUR FOR A 2 09/05/22 PK83492 UK46333 0905 HIPER ABEND04E RC00E20005 1 09/05/21 PK80001 UK46293 0905 HIPER DBET NOTIFIED MEMBERS WERE


Installation Information

This section contains changes to the product's Program Directory. 1. YY/MM/DD NO ENTRIES


Documentation Changes

This section outlines major errors in the product's published documentation. 1. YY/MM/DD NO ENTRIES


General Information

This section contains general information, i.e. SYSGEN hints/tips. 1. YY/MM/DD NO ENTRIES


Service Recommendations

322 11/08/10 PROBLEM: (PM35799) ABEND0C4 IN DSNB1OFA+0BEA DURING RESTORE SYSTEM UTILITY USERS AFFECTED: All users of RESTORE SYSTEM Utility. RECOMMENDATION: INSTALL UK70133 ON VOLID 1000 (HDB8810) 321 11/08/10 PROBLEM: (PM42066) INCORROUT (LESS ROWS RETURNED) WHEN RUNNING WITH PARAMDEG > 1 USERS AFFECTED: All DB2 10, DB2 9 for z/OS, and DB2 for z/OS 8 users of parallel multi-column sort-merge join. RECOMMENDATION: INSTALL UK70085 ON VOLID 1000 (HDB8810) 320 11/08/05 PROBLEM: (PM37446) DB2 CATALOG MAY BE CORRUPTED. USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS and DB2 10 for z/OS Utility Users RECOMMENDATION: INSTALL UK70046 ON VOLID 1000 (HDB8810) 319 11/08/05 PROBLEM: (PM42245) INCORROUT WHEN OPTIMIZER CHOOSES SORT MERGE JOIN FOR MERGING QUERY BLOCKS WITH SAME JOIN PREDICATE GENERATED USERS AFFECTED: All DB2 8, DB2 9 and DB2 10 for z/OS users who execute SQL with a subquery that will be transformed to a join. RECOMMENDATION: INSTALL UK69882 ON VOLID 1000 (HDB8810) 318 11/08/04 PROBLEM: (PM37297) ABEND04E DSNIDBNG ERQUAL5006 DURING SETXCF REBUILD OF SCA, WHEN THERE IS A VERY LARGE PARTITIONED OBJECT IN LPL OR GRECP USERS AFFECTED: All DB2 for z/OS data sharing users who issue the z/OS SETXCF REBUILD command on the SCA structure, e.g.: SETXCF START,REBUILD,STRNM=DSNCAT_SCA RECOMMENDATION: INSTALL UK69826 ON VOLID 1000 (HDB8810) 317 11/08/04 PROBLEM: (PM38121) INCORROUT(NO ROWS RETURNED) WHEN FULL OUTER JOIN UNDER EXISTS PREDICATE AND THE OUTER TABLE HAS NO ROWS RETURNED USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS, and DB2 10 for z/OS users of queries that contain a FULL OUTER JOIN under an EXISTS predicate. RECOMMENDATION: INSTALL UK69719 ON VOLID 1000 (HDB8810) 316 11/08/01 PROBLEM: (PM36512) ABEND0C7 DSNXRTIM OFFSET5400 5400 WITH PARALLELISM ENABLED USERS AFFECTED: All DB2 for z/OS V8, DB2 9 and DB2 10 for z/OS users who do multiple outer joins in a SELECT RECOMMENDATION: INSTALL UK69739 ON VOLID 1107 (HDB8810) 315 11/07/14 PROBLEM: (PM32423) WHEN USING TABLE UDFS WITH IBM SMART ANALYTICS OPTIMIZER (ISAO), SQLSTATE CAN CONTAIN GARBAGE USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS and DB2 10 for z/OS users of table UDFs. RECOMMENDATION: INSTALL UK69249 ON VOLID 1107 (HDB8810) 314 11/06/29 PROBLEM: (PM38184) ABEND04E RC00D10330 AT DSNJL002 DSNJR001 OFFSET0B76 AFTER A PRIOR ABEND RC00D10345 USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK68707 ON VOLID 1106 (HDB8810) 313 11/06/27 PROBLEM: (PM40595) ABND=04E-00D92023 ABEND04E RC00D92023 ,M=(N),C=910.RMC RMFTLCUR M=DSNRPLCS,LOC=DSNRLLM1.DSNRPLCS OFFSET1296 AT DB2 START UP USERS AFFECTED: All DB2 users of Global Transactions. RECOMMENDATION: INSTALL UK68620 ON VOLID 1106 (HDB8810) 312 11/06/23 PROBLEM: (PM22732) BROKEN PAGE AFTER MVS CANCEL DURING A ROLLBACK USERS AFFECTED: All DB2 for z/OS users who enter z/OS, JES2 or JES3 CANCEL commands against jobs that are active in DB2. RECOMMENDATION: INSTALL UK63055 ON VOLID 1012 (HDB8810) 311 11/06/22 PROBLEM: (PM28618) AN INVALID SQLCODE -180 IS ISSUED FOR A SQL STATEMENT CONTAINING A CAST TO TIME WITHIN A GROUP BY CLAUSE USERS AFFECTED: All DB2 for z/OS V8 users of complex SQL statements having a CAST to DATE or TIME in a GROUP BY or FETCH FIRST N ROWS clause. RECOMMENDATION: INSTALL UK68462 ON VOLID 1106 (HDB8810) 310 11/06/22 PROBLEM: (PM38068) ABND=0C4-11 LOC=DSNLILLM.DSNLCBCS+05F8 USERS AFFECTED: All Distributed Data Facility (DDF) users. Specifically those using SNA connections to access remote systems. RECOMMENDATION: INSTALL UK68456 ON VOLID 1106 (HDB8810) 309 11/06/13 PROBLEM: (PM34969) V10/V9 CO-EXIT 04E-00E50001, LOC=DSNJL002.DSNJB002+0AEA USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK68197 ON VOLID 1106 (HDB8810) 308 11/06/13 PROBLEM: (PM38120) RC00E4010A COPY UTILITY WITH FLASHCOPY CONSISTENT DURING CONSISTENCY PROCESSING USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS, and DB2 10 for z/OS users of RECOVER utility or DB2 10 COPY utility with the FLASHCOPY option. RECOMMENDATION: INSTALL UK68148 ON VOLID 1106 (HDB8810) 307 11/06/06 PROBLEM: (PM34593) DB2 SUBSYSTEM TERMINATION REQUESTED REASON=00F30801 RC00F30801 AFTER A LOAD UTILITY JOB SUFFERED ABENDDC2 S0DC2 4A001620 USERS AFFECTED: All DB2 z/OS v9 and v10 users of LOAD and REORG utilities on compressed table spaces. RECOMMENDATION: INSTALL UK67871 ON VOLID 1106 (HDB8810) 306 11/06/03 PROBLEM: (PM35394) SQLINCORROUT NO ROW FOUND WITH PARAMETER MARKER USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS and DB2 10 for z/OS users who use SQL statement that contains nested table expression and host variable. RECOMMENDATION: INSTALL UK67829 ON VOLID 1106 (HDB8810) 305 11/06/02 PROBLEM: (PM20766) Serviceability enhancements USERS AFFECTED: All DB2 8 for z/OS users of DESCRIBE are affected. RECOMMENDATION: INSTALL UK67724 ON VOLID 1105 (HDB8810) 304 11/05/30 PROBLEM: (PM33791) LOAD CHAR->GRAPHIC W/CCSID CHANGES IS MISSING FOR THE DELIMITED NULL, ABENDS ABND=0C4-00000038,LOC=DSNUTILA.DSNURWBG+2804 USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS, and DB2 10 for z/OS utility users of LOAD FORMAT DELIMITED into a UNICODE table containing a GRAPHIC or VARGRAPHIC column RECOMMENDATION: INSTALL UK67632 ON VOLID 1105 (HDB8810) 303 11/05/23 PROBLEM: (PM35062) ABEND04E RC00E20033 00E20033 FROM DSNSCTL WHEN REAL STORAGE HIT ZPARM VALUE SPRMRSMX POSSIBLE LOGREC ENTRY WITH ABENDDC2 USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK67468 ON VOLID 1105 (HDB8810) 302 11/05/19 PROBLEM: (PM31524) DURING INSERT OF NULL VALUE AS LITERAL INTO A COLUMN WITH FIELD PROCEDURE, GARBAGE DATA MAY BE INSERTED INTO DB2. USERS AFFECTED: All DB2 for z/OS V8, DB2 9 for z/OS and DB2 10 for z/OS users using INSERT null value into a column with FIELD PROCEDURE RECOMMENDATION: INSTALL UK67329 ON VOLID 1105 (HDB8810) 301 11/05/19 PROBLEM: (PM32398) RC00E20027 DSNLXREL.DSNSVBK +0A3E OR SQLCODE330 WHEN DB2/ZOS QUERIES TO DB2 ON AS/400 USERS AFFECTED: All Distributed Data Facility (DDF) users. Specifically those using DB2 for z/OS to access data at a DB2 for i server system. RECOMMENDATION: INSTALL UK67394 ON VOLID 1105 (HDB8810) 300 11/05/18 PROBLEM: (PM31732) ABEND0C4 0000003B LOC DSNBBM DSNB5PCO OFFSET3ABE USERS AFFECTED: All DB2 users in a data-sharing environment. RECOMMENDATION: INSTALL UK67316 ON VOLID 1105 (HDB8810) 299 11/05/18 PROBLEM: (PM33955) IncorrOut or ABEND04E RC00E70005 DSNXOADJ:M444 ON QUERY WITH CTE / UNION ALL AND MULTIPLE OUTER JOIN WITH UK63515 APPLIED USERS AFFECTED: All DB2 for z/OS V8, DB2 9 and DB2 10 for z/OS users who have PM25187 applied (UK63515 for V8, UK63516 for V9 and UK63514 for V10) and use SQL statement containing multiple Table Expressions and OUTER JOINs. RECOMMENDATION: INSTALL UK67290 ON VOLID 1105 (HDB8810) 298 11/05/11 PROBLEM: (PM34554) CHECK DATA TABLESPACE ABND=0C4-00000011 LOC=DSNUT810.DSNUREKY+038A USERS AFFECTED: All DB2 for z/OS V8 users of CHECK DATA on a table with LOB column. RECOMMENDATION: INSTALL UK67070 ON VOLID 1105 (HDB8810) 297 11/04/25 PROBLEM: (PM30567) LONG RUNNING DB2 RESTART CAUSED BY THE UNNECESSARY UNIT OF RECOVERY (UR) CREATED BY FAST LOG APPLY USERS AFFECTED: All DB2 for z/OS V8 and V9 users using indexes. RECOMMENDATION: INSTALL UK66531 ON VOLID 1104 (HDB8810) 296 11/04/22 PROBLEM: (PM33480) VARIOUS ABEND0C4 ABENDS EXECUTING AFTER UPDATE TRIGGER WITH MANY COLUMNS IN THE TABLE. DB2OVRLAY/K USERS AFFECTED: All DB2 for z/OS users of AFTER TRIGGERS with a large number of transition variables. RECOMMENDATION: INSTALL UK66507 ON VOLID 1104 (HDB8810) 295 11/04/18 PROBLEM: (PM31396) INCORROUT (LESS ROW FOUND) FOR PREDICATE IS NOT DISTINCT WITH USERS AFFECTED: All DB2 V8, V9 and V10 users when running query containing IS NOT DISTINCT FROM predicate and using UNIQUE NOT NULL index. RECOMMENDATION: INSTALL UK66341 ON VOLID 1104 (HDB8810) 294 11/04/14 PROBLEM: (PM30773) ROW NOT FOUND CONDITION WHEN PRESENT CORRECTLY IN INDEX USERS AFFECTED: All DB2 for z/OS users with SKIP UNCOMMITTED INSERTS subsystem parameter (DSN6SPRM SKIPUNCI) turned on RECOMMENDATION: INSTALL UK66181 ON VOLID 1104 (HDB8810) 293 11/04/08 PROBLEM: (PM30995) ABEND0C4 RC00000038 RC38 DSNGDLGA +1760 OFFSET1760 WITH PTF UK62847 APPLIED CAUSES A STORAGE USERS AFFECTED: DB2 users who ALTER INDEX and have UK62846/UK62847 applied RECOMMENDATION: INSTALL UK65980 ON VOLID 1104 (HDB8810) 292 11/04/04 PROBLEM: (PM26389) ABEND04E RC00C90101 DSNIDBLK:5194ON -START DB OR -DISPLAY DB AGAINST DATABASE DSNDB06 AFTER -STOP DB(DSNDN06) SPACE(*) USERS AFFECTED: All DB2 V8 and DB2 V9 users RECOMMENDATION: INSTALL UK65805 ON VOLID 1103 (HDB8810) 291 11/04/04 PROBLEM: (PM31305) MSGDSNP011I RC00D70014 AND ABEND0C6 RC00341114 ICYPGAD AND SUBSEQUENT DB2 SUBSYSTEM TERMINATION WITH RC00E80100 USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK65589 ON VOLID 1103 (HDB8810) 290 11/03/25 PROBLEM: (PM25451) INCORROUT NO ROW FOUND WHEN QUERY WITH IN LIST AND RUN IN PARALLELISM USERS AFFECTED: All DB2 for z/OS parallelism users. RECOMMENDATION: INSTALL UK65585 ON VOLID 1103 (HDB8810) 289 11/03/21 PROBLEM: (PM28413) OLD BUFFER POOL IS USED AFTER STOP/ALTER/START COMMAND USERS AFFECTED: All DB2 for z/OS data sharing users who run -STOP DATABASE command and DDL ALTER TABLESPACE BUFFERPOOL or ALTER INDEX BUFFERPOOL RECOMMENDATION: INSTALL UK65238 ON VOLID 1103 (HDB8810) 288 11/03/21 PROBLEM: (PM28825) ABEND04E RC00C20305 AT LOC DSNBBM DSNB1DDN OFFSET0A1E USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK65401 ON VOLID 1103 (HDB8810) 287 11/03/14 PROBLEM: (PM27493) ABEND0C4 IN DSNB1GET+02D4 DURING RESTORE SYSTEM LOG APPLY. USERS AFFECTED: All users of DB2 RESTORE SYSTEM RECOMMENDATION: INSTALL UK65161 ON VOLID 1103 (HDB8810) 286 11/03/03 PROBLEM: (PM24660) WHEN SPECIFYING -STA DB(DB_NAME) SP(IX1,IX1) WITH DUPLICATE NAMES FOR LPL/GRECP RECOVERY, DB2 CRASHED WITH DSNILGSL 5007 USERS AFFECTED: All users of DB2 for Z/OS using -START DATABASE command RECOMMENDATION: INSTALL UK64853 ON VOLID 1103 (HDB8810) 285 11/03/03 PROBLEM: (PM26087) DB2 GOT ABEND04E RC00C90093 DURING ONLINE REORG CONCURRENTLY WITH INSERTS AND IRLM CRASHED. USERS AFFECTED: All DB2 for z/OS V8, DB2 9 and DB2 10 for z/OS users. RECOMMENDATION: INSTALL UK63987 ON VOLID 1102 (HDB8810) 284 11/03/02 PROBLEM: (PM25247) INCORROUT (NO ROW FOUND) WHEN PREDICATE IS USING PADDED INDEX ON EXPRESSION AND THE KEY COLUMN IS A VARCHAR USERS AFFECTED: z/OS 8 and DB2 9 for z/OS users of query running in parallel. RECOMMENDATION: INSTALL UK64818 ON VOLID 1102 (HDB8810) 283 11/03/02 PROBLEM: (PM27286) ABEND0C4 IN DSNSVBK+09A0 DURING LPL RECOVERY. USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK64799 ON VOLID 1102 (HDB8810) 282 11/03/02 PROBLEM: (PM31197) 04E-00D31010 DSNLCCNR:0003 USERS AFFECTED: All Distributed Data Facility (DDF) users. RECOMMENDATION: INSTALL UK64813 ON VOLID 1102 (HDB8810) 281 11/02/25 PROBLEM: (PM23025) INCORROUT OR POOR PERFORMANCE DUE TO INCORRECT SELECTION OF KEYS FOR MULTI-COLUMN SORT MERGE JOIN WITH SORTC_JOIN='N' USERS AFFECTED: For all DB2 for z/OS users who have queries eligible for Merge Scan Join (MSJ) without sort on outer composite. RECOMMENDATION: INSTALL UK64670 ON VOLID 1102 (HDB8810) 280 11/02/21 PROBLEM: (PM21785) ABEND04E RC00C90101 DSNIBCTD ERQUAL5007 DURING EXPLAIN STMTCACHE ALL WHEN RESOURCE UNAVAILABLE CONDITION 00C90096 OCCURS USERS AFFECTED: All users of DB2 for z/OS V8 who use EXPLAIN STMTCACHE RECOMMENDATION: INSTALL UK64532 ON VOLID 1102 (HDB8810) 279 11/02/18 PROBLEM: (PM15044) ABEND04E 00E20006 LOC=DSNIWKFD DSNSVBK OFFSET098E CUB ALREADY FREED WHEN DELETE TEMPORARY FILE - SMCOVERLAY USERS AFFECTED: All DB2 V8 for z/OS users of workfiles or created global temporary tables (CGTTs) RECOMMENDATION: INSTALL UK59901 ON VOLID 1009 (HDB8810) 278 11/02/18 PROBLEM: (PM23401) ABEND04E RC00E70005 DSNXRRP AT M100 FOR SQLPL PROCEDURE WHICH CONTAINS INSERT VIA SELECT STATEMENT USERS AFFECTED: All DB2 for z/OS V8, DB2 9 and DB2 10 for z/OS users who use UNION/UNION ALL in views. RECOMMENDATION: INSTALL UK64485 ON VOLID 1102 (HDB8810) 277 11/02/16 PROBLEM: (PM23169) ABEND04E RC00C90101 DSNIRTSX:5050 WHEN EXTERNALIZING THE REAL TIME STATISTICS (RTS) VRACE5050. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS and DB2 10 for z/OS users with Real-Time Statistics enabled RECOMMENDATION: INSTALL UK64410 ON VOLID 1102 (HDB8810) 276 11/02/16 PROBLEM: (PM25870) PERFORMANCE DEGRADATION ON PAIR-WISE JOIN ELAPSE TIME, FORWARD FIT IN DB2 10 FOR Z/OS FOR AE FIX PM24364 USERS AFFECTED: 1. All DB2 10 for z/OS users of pair-wise join queries. 2. All DB2 10, DB2 9 for z/OS and DB2 for z/OS 8 users of sysplex parallelism. 3. All DB2 10 for z/OS users of straw model parallelism. RECOMMENDATION: INSTALL UK64377 ON VOLID 1102 (HDB8810) 275 11/02/11 PROBLEM: (PM24273) INCORROUT (NO ROW FOUND) ON COMPLEX QUERY WITH IN-SUBQUERY USERS AFFECTED: RECOMMENDATION: INSTALL UK64186 ON VOLID 1102 (HDB8810) 274 11/02/10 PROBLEM: (PM26888) ABEND0C4 RC4 AT DSNXGINL +1CA2 OFFSET1CA2 DURING REBIND PACKAGE PROCESSING USERS AFFECTED: ALL DB2 8 for z/OS, DB2 9 for z/OS and DB2 10 for z/OS users of a SQL statement containing a huge (more than 65534) continuous 'OR' predicate list with literal constants on the same column. RECOMMENDATION: INSTALL UK64179 ON VOLID 1102 (HDB8810) 273 11/02/09 PROBLEM: (PM28310) ABEND 04E RC00C200B0 LOC DSNIDM DSNB1REL OFFSET0E1A USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK64168 ON VOLID 1102 (HDB8810) 272 11/02/09 PROBLEM: (PM28968) CASTOUT ABEND 04E 00E20006 IN DSNB5PCO DSNSVBK OFFSET0952 AFTER CF CRASH USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK64160 ON VOLID 1102 (HDB8810) 271 11/02/03 PROBLEM: (PM27253) INCORROUT (WRONG VALUE RETURNED) ON QUERY WITH OUTER JOIN TABLE EXPRESSION AND SIDEWAY REFERENCE AND PARALLELISM USERS AFFECTED: All DB2 10, DB2 9 for z/OS, and DB2 for z/OS 8 users of the SIDEWAY REFERENCE PREDICATE running in PARALLELISM. RECOMMENDATION: INSTALL UK63993 ON VOLID 1102 (HDB8810) 270 11/01/31 PROBLEM: (PM25966) ABEND 04E - 00C90101 IN DSNIECUR ERQUAL5019 DURING RESTART USERS AFFECTED: All Users of DB2. RECOMMENDATION: INSTALL UK63956 ON VOLID 1101 (HDB8810) 269 11/01/28 PROBLEM: (PM25906) ABEND04E 00C90101 DSNIPSFI:5007 AND/OR INCORRECT OUTPUT WHEN USING UDF. USERS AFFECTED: All DB2 for z/OS 8, DB2 9, DB2 10 for z/OS users of join predicate containing UDF with ALLOW PARALLEL attribute and paralleism plan being used when query in executed. RECOMMENDATION: INSTALL UK63873 ON VOLID 1101 (HDB8810) 268 11/01/26 PROBLEM: (PM28586) DATA IN QW0125PC IS INCORRECT USERS AFFECTED: All DB2 for z/OS v8, DB2 9 for z/OS, and DB2 10 for z/OS users of the DB2 Trace who enable IFCID 125 to trace for multiple index access path selection. RECOMMENDATION: INSTALL UK63766 ON VOLID 1101 (HDB8810) 267 11/01/21 PROBLEM: (PM22534) ABEND0C4-38 DSNXOSL + 1CCE WITH QUERY WHILE STAR JOIN IS ENABLED USERS AFFECTED: For DB2 for z/OS users who use star join. RECOMMENDATION: INSTALL UK63681 ON VOLID 1101 (HDB8810) 266 11/01/21 PROBLEM: (PM26957) UNDER GLOBAL TRANSACTION, UNFIX PAGE FAILURE ABENDDC2 RC55005023 DUE TO THE PAGE NOT CURRENTLY FIXED CAUSED DB2 DOWN. USERS AFFECTED: Users of global transactions in DB2. RECOMMENDATION: INSTALL UK63685 ON VOLID 1101 (HDB8810) 265 11/01/14 PROBLEM: (PM21858) DB2 GOT ABEND04E RC00C90101 AT DSNISMCP:5001 AFTER ALTER TABLE ADD BECAUSE DATA ROW WAS INSERTED INTO SYSTEM PAGE. USERS AFFECTED: All DB2 z users of non-segmented and non-UTS table spaces. RECOMMENDATION: INSTALL UK63550 ON VOLID 1101 (HDB8810) 264 11/01/12 PROBLEM: (PM25187) INCORROUT (WRONG VALUE RETURNED) OR VARIOUS ABEND04E ON QUERY WITH CTE AND UNION AND OUTER JOIN USERS AFFECTED: All DB2 for z/OS V8, DB2 9 and DB2 10 for z/OS users of a query that contains common table expression, UNION ALL, and OUTER JOIN. RECOMMENDATION: INSTALL UK63515 ON VOLID 1101 (HDB8810) 263 10/12/31 PROBLEM: (PM26751) INCORRECT OUTPUT CAN BE RETURNED FOR VARIABLE LENGTH FIELDS IF THEY ARE USED AS PART OF MIN/MAX ALONG WITH MULTIPLE DISTINCTS USERS AFFECTED: All DB2 for z/OS v8, DB2 9 for z/OS, and DB2 10 for z/OS users of queries that contain multiple DISTINCTs. RECOMMENDATION: INSTALL UK63146 ON VOLID 1012 (HDB8810) 262 10/12/29 PROBLEM: (PM21099) DEFECT 129802 SQLCODE -270 NOT ISSUED FOR QUALIFIED UPDATE SQL AGAINST TABLE WITH BEFORE UPDATE TRIGGER USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of BEFORE UPDATE TRIGGERS. RECOMMENDATION: INSTALL UK63024 ON VOLID 1012 (HDB8810) 261 10/12/23 PROBLEM: (PM23356) ABEND04E ABEND0C4 DUE TO DBD OVERLAY AFTER ALTER INDEX IS ROLLED BACK. USERS AFFECTED: Users who ALTER INDEX RECOMMENDATION: INSTALL UK62846 ON VOLID 1012 (HDB8810) 260 10/12/17 PROBLEM: (PM22748) INCONSISTENT BEHAVIOR BETWEEN C APPLICATION AND SQL PROCEDURE FOR FETCH RELATIVE 0 USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of scrollable cursors. RECOMMENDATION: INSTALL UK62693 ON VOLID 1012 (HDB8810) 259 10/12/16 PROBLEM: (PM24729) DATA BROKEN IF QUIESCE UTILITY IS CANCELLED AND UPDATE IS DONE BEFORE CASTOUT TRIGGERED BY THE QUIESCE ISSUES GBP PURGE. USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK62657 ON VOLID 1012 (HDB8810) 258 10/12/10 PROBLEM: (PM08604) INCORRECT OUTPUT MAY OCCUR WHEN IN-LIST INDEX SCAN RUNS IN PARALLELISM. USERS AFFECTED: Users using a query which uses IN-list index scan with parallelism RECOMMENDATION: INSTALL UK62505 ON VOLID 1012 (HDB8810) 257 10/12/09 PROBLEM: (PM19359) ABEND 04E RC00C90101 DSNIWKFD ERQUAL500A WITH MSGDSNV086E RC00D94001 (DB2 CRASH) DURING ABORT PROCESSING USERS AFFECTED: All DB2 for z/OS R810 V810 workfile users. RECOMMENDATION: INSTALL UK62460 ON VOLID 1012 (HDB8810) 256 10/12/01 PROBLEM: (PM23990) EXCESSIVE DB2 ABEND04E DUMPS WERE SEEN IN A QREP ENVIRONMENT WHICH RESULTED IN AN MVS OUTAGE WITH ABENDS878 RC10 USERS AFFECTED: All IFCID 306 users with compressed table spaces. RECOMMENDATION: INSTALL UK62071 ON VOLID 1011 (HDB8810) 255 10/12/01 PROBLEM: (PM24930) MISSING INDEX ENTRY IS CAUSED BECAUSE INDEX MGR DOES NOT REFRESH THE HELD POSITION IN INDEX PAGE DURING PAGE SPLIT PROCESSING. USERS AFFECTED: All DB2 users using indexes. RECOMMENDATION: INSTALL UK62114 ON VOLID 1011 (HDB8810) 254 10/11/24 PROBLEM: (PM22854) ABEND0C4 RC00000004 FROM DSNSVSFB OFFSET050A BECAUSE PHBVDMYG IS X'00' USERS AFFECTED: All DB2 V8 HDB8810 users. RECOMMENDATION: INSTALL UK61978 ON VOLID 1011 (HDB8810) 253 10/11/22 PROBLEM: (PM20917) INCORRECT OUTPUT WITH FULL OUTER JOIN AND THE NULL PADDING TABLE IS TABLE EXPRESSION WITH VARYING LENGTH DATA AND PARALLEL HYBRID USERS AFFECTED: All DB2 for z/OS 8 and DB2 9 for z/OS parallelism users executing an outer join query which uses HYBRID JOIN method with a VARCHAR data type join column running on parallel. RECOMMENDATION: INSTALL UK61870 ON VOLID 1011 (HDB8810) 252 10/11/22 PROBLEM: (PM23791) ABEND0C4 IN DSNB1CMS + 14B4 AT UK46415 USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK61922 ON VOLID 1011 (HDB8810) 251 10/11/15 PROBLEM: (PM22255) SQL QUERY RECEIVED INCORROUT WHEN RAN AFTER AN UPDATE STATEMENT, WHICH CREATED CROSS PARTITION POINTER AND WAS NOT COMMITTED. USERS AFFECTED: All DB2 users using indexes. RECOMMENDATION: INSTALL UK61699 ON VOLID 1011 (HDB8810) 250 10/11/15 PROBLEM: (PM22768) ACCESS PATH REGRESSION OCCURS BECAUSE PREDICATES ARE MARKED AS NOT SARGEABLE. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users who have PM07464 applied (UK58742 for V8; UK58743 for V9) and have performance regression for an SQL statement containing a Boolean term non-correlated subquery predicate. RECOMMENDATION: INSTALL UK61777 ON VOLID 1011 (HDB8810) 249 10/11/11 PROBLEM: (PM16611) ABEND04E RC00E20016 IN DSNSVSTK +0656 WHEN REPEATEDLY LOOPING OVER SAME SQL UPDATE STMT WITH BIND OPTION RELEASE(DEALLOCATE) USERS AFFECTED: DB2 users of bind option RELEASE(DEALLOCATE) with searched SQL UPDATE or DELETE statement RECOMMENDATION: INSTALL UK61648 ON VOLID 1011 (HDB8810) 248 10/11/08 PROBLEM: (PM20811) SELECT COUNT(*) TO GET DIFFERENT COUNT NUMBER USERS AFFECTED: All DB2 for z/OS 8 and DB2 9 for z/OS parallelism users executing UA/UN/EA/EX/ IA/IS query. RECOMMENDATION: INSTALL UK61539 ON VOLID 1011 (HDB8810) 247 10/11/08 PROBLEM: (PM21042) MANY 0C4 ABENDS BECAUSE PB0IDINT IN PB0 WAS OVERLAID USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK61590 ON VOLID 1011 (HDB8810) 246 10/11/04 PROBLEM: (PM20429) INCORROUT (LESS ROW FOUND) ON QUERY WITH PARALLEL SORT MERGE JOIN TO TABLE WITH PARTITION USERS AFFECTED: All DB2 for z/OS parallelism users. RECOMMENDATION: INSTALL UK61442 ON VOLID 1011 (HDB8810) 245 10/11/03 PROBLEM: (PM21465) ABEND04F 00E50702 AFTER DBAT IS CANCELED. USERS AFFECTED: All Distributed Data Facility (DDF) users. RECOMMENDATION: INSTALL UK61436 ON VOLID 1011 (HDB8810) 244 10/11/03 PROBLEM: (PM21683) ABEND04E 00E20025 U=SYSOPR M=(N) C=810.DMC M=DSNTFRCV LOC=DSNIDBHK.DSNSVBK+09D0 USERS AFFECTED: All DB2 data-sharing users for z/OS V8 with PK91699 / UK54451 applied and DB2 9 for z/OS with PK91699 / UK54452 applied. RECOMMENDATION: INSTALL UK61376 ON VOLID 1011 (HDB8810) 243 10/11/03 PROBLEM: (PM23587) PHB LATCH NOT RELEASED FOLLOWING ABEND04E RC00E20016 USERS AFFECTED: All users of DB2 R810 R910 RECOMMENDATION: INSTALL UK61433 ON VOLID 1011 (HDB8810) 242 10/10/29 PROBLEM: (PM13814) DSNKUNR2:500F DURING POSTPONED ABORT USERS AFFECTED: All DB2 data sharing users using indexes. RECOMMENDATION: INSTALL UK60423 ON VOLID 1010 (HDB8810) 241 10/10/29 PROBLEM: (PM20114) DGTT CANCEL RESULTS IN ABENDS0C4 RC00000011 DSNGDCMT OFFSET181C USERS AFFECTED: DB2 users who use declared global temporary table. RECOMMENDATION: INSTALL UK61276 ON VOLID 1010 (HDB8810) 240 10/10/29 PROBLEM: (PM21630) BIG NUMBERS IN SYSINDEXES.FIRST&FULL KEYCARDF AFTER RUNSTATS USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users with RUNSTATS PART or gathering inline stats at the part level. RECOMMENDATION: INSTALL UK61272 ON VOLID 1010 (HDB8810) 239 10/10/29 PROBLEM: (PM22712) AE PM13814 FIX COMPLETION USERS AFFECTED: All DB2 data sharing users using indexes. RECOMMENDATION: INSTALL UK60423 ON VOLID 1010 (HDB8810) 238 10/10/29 PROBLEM: (PM23051) ABEND0C4 IN DSNIARPL+3BF4 DURING DB2 RESTART. USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK61108 ON VOLID 1010 (HDB8810) 237 10/10/28 PROBLEM: (PM18271) INCORROUT (WRONG VALUE) ON REMOTE MULTI-ENCODING SCHEME QUERY WITH CTE/TABLE-EXPR AND UNION/UNION ALL USERS AFFECTED: All DB2 R810 or R910 users of multiple CCSID and datetime type. RECOMMENDATION: INSTALL UK61235 ON VOLID 1010 (HDB8810) 236 10/10/22 PROBLEM: (PM21663) PROBLEM WITH LPL RECOVERY PROCESS TO HANDLE LOG READ ERRORS. USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK61111 ON VOLID 1010 (HDB8810) 235 10/10/14 PROBLEM: (PM21054) ABEND0C4 RC38 OR RC11 FROM DSN3AUGC, DSNLCDP2, DSNLQACT OR DSNVMON. ABEND04E RC00D35011 FROM DSNLZS00 ALSO POSSIBLE USERS AFFECTED: All Distributed Data Facility (DDF) users. RECOMMENDATION: INSTALL UK60827 ON VOLID 1010 (HDB8810) 234 10/10/07 PROBLEM: (PM19241) INCORROUT NRF AFTER ALTER AND REBUILD INDEX AND ORDER BY DESC USERS AFFECTED: Users who add a column to a DPSI, making it a partitioning index. RECOMMENDATION: INSTALL UK60522 ON VOLID 1010 (HDB8810) 233 10/10/01 PROBLEM: (PM19796) ABEND04E 00C90101 WITH DSNKUNR2 ERQUAL5007 USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK60459 ON VOLID 1009 (HDB8810) 232 10/09/29 PROBLEM: (PM20394) VARCHAR DATA GETS TRUNCATED WHEN MRI IS USED BY REMOTE REQUESTER USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of Multi-Row Insert (MRI) in a distributed environment when zOS is a requester. RECOMMENDATION: INSTALL UK60412 ON VOLID 1009 (HDB8810) 231 10/09/27 PROBLEM: (PM17813) RETROFIT V9 ENHANCEMENT IN INSERTING EMPTY SEGMENTED TABLESPACE TO V8. THIS IS THE PRECONDITIONING APAR. USERS AFFECTED: All DB2 users using segmented Table Space. RECOMMENDATION: INSTALL UK60343 ON VOLID 1009 (HDB8810) 230 10/09/23 PROBLEM: (PM17437) LESS ROWS THAN EXPECTED RETURNED FOR A QUERY AGAINST A VIEW THAT CONTAINS A UNION ALL OR A QUERY WITH A UNION ALL IN A SUBQUERY USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries that contain a UNION ALL clause in its subquery. RECOMMENDATION: INSTALL UK60309 ON VOLID 1009 (HDB8810) 229 10/09/20 PROBLEM: (PM18445) DB2 GOT ABEND0C4 PIC11 IN DSNIOST2+BD10 WITH PE APAR PM14301. ANOTHER SYMPTOM IS ABEND04E RC00C90101 DSNKTRAV:5038. USERS AFFECTED: All DB2 users have UK58132/UK58133 applied. RECOMMENDATION: INSTALL UK60182 ON VOLID 1009 (HDB8810) 228 10/09/13 PROBLEM: (PM11823) AGL STORAGE POOL NOT CONTRACTED AFTER FREEING THE STORAGE BY DSNXOCN USERS AFFECTED: All users of DB2 for z/OS V8 who are experiencing excessive storage usage during prepare of queries RECOMMENDATION: INSTALL UK60082 ON VOLID 1009 (HDB8810) 227 10/09/09 PROBLEM: (PM16156) LOAD DELIMITED FAILS WITH ABEND04E RC00E40323 WHEN DECIMAL=COMMA IN DSNHDECP USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of LOAD DELIMITED RECOMMENDATION: INSTALL UK59788 ON VOLID 1009 (HDB8810) 226 10/09/06 PROBLEM: (PM16609) ABEND04E IN DSNIFLWD RC00C90101 ERQUAL5004 DURING RECOVER UTILITY LOG APPLY USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK59816 ON VOLID 1009 (HDB8810) 225 10/09/06 PROBLEM: (PM20250) DB2 GROUP RESTART WILL NOT BE TRIGGERED IF DB2 CRASHED DURING CSR IN PREVIOUS RESTART USERS AFFECTED: All data sharing users of DB2. RECOMMENDATION: INSTALL UK59814 ON VOLID 1009 (HDB8810) 224 10/09/03 PROBLEM: (PM17916) DB2 ABEND WITH 04E-00E50705 BECAUSE LATCH IS NOT RELEASED USERS AFFECTED: All users of DB2 RECOMMENDATION: INSTALL UK59740 ON VOLID 1009 (HDB8810) 223 10/09/01 PROBLEM: (PM15502) ABEND0C4 RECOVERY LOOP WITH DSN3RRSF AFTER AN ABEND04E RSN00F30095 IN DSN3RRSI USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK59688 ON VOLID 1008 (HDB8810) 222 10/09/01 PROBLEM: (PM18072) COPY UTILITY SKIPS COPYING A DATA PAGE USERS AFFECTED: ALL DB2 FOR z/OS V8 AND DB2 9 FOR z/OS USERS OF COPY UTILITY RECOMMENDATION: INSTALL UK59569 ON VOLID 1008 (HDB8810) 221 10/08/27 PROBLEM: (PM16879) ABEND04E RC00C90101 DSNIDBCP:5003 USERS AFFECTED: ALL DB2 FOR z/OS V8 AND DB2 9 FOR z/OS USERS OF COPY UTILITY ON PARTITIONED TABLE SPACES RECOMMENDATION: INSTALL UK59567 ON VOLID 1008 (HDB8810) 220 10/08/24 PROBLEM: (PM15572) ABEND04E RSN00E20003 CT STORAGE POOL LEAK DURING DB2 STARTUP USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK59420 ON VOLID 1008 (HDB8810) 219 10/08/23 PROBLEM: (PM01474) DB2 RESTART FAILS 04E 00C90101 DSNILGCL ERQUAL5009 DURING LPL / GRECP PROCESSING INDEXES USERS AFFECTED: All DB2 users of indexes RECOMMENDATION: INSTALL UK54416 ON VOLID 1003 (HDB8810) 218 10/08/19 PROBLEM: (PM17794) CLIENT SENDING LOB DATA GOT CORRUPTED THROUGH DRDA WHEN DATA_ENCRYPT SPECIFIED USERS AFFECTED: All Distributed Data Facility (DDF) users. Specifically those using LOBs or XML. RECOMMENDATION: INSTALL UK59408 ON VOLID 1008 (HDB8810) 217 10/08/18 PROBLEM: (PM13375) INCORROUT INCORRECT OUTPUT WITH RECURSIVE CTE & UNION ALL USERS AFFECTED: All DB2 users who use recursive SQL RECOMMENDATION: INSTALL UK59359 ON VOLID 1008 (HDB8810) 216 10/08/11 PROBLEM: (PM11062) SQLCODE -206 SHOULD BE ISSUED FOR THE TRIGGER STATEMENT IF THE CORRELATION NAME IS NOT USED IN THE WHEN CLAUSE TABLE SUBJECT. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of triggers with a search condition and transition variables or transition tables. RECOMMENDATION: INSTALL UK59107 ON VOLID 1008 (HDB8810) 215 10/08/04 PROBLEM: (PK98114) DB2 SUBSYSTEM TERMINATION WITH ABEND30D RC00F30411 AFTER STORED PROCEDURE ADDRESS SPACE WENT TO END OF MEMORY ( EOM ) USERS AFFECTED: DB2 users of stored procedures and User Defined Functions (UDFs) running in WLM address space. RECOMMENDATION: INSTALL UK58900 ON VOLID 1008 (HDB8810) 214 10/08/04 PROBLEM: (PM07464) SQLCODE100 OR +100 RETURNED FOR STATIC SELECT INTO QUERY THAT HAS A WHERE PREDICATE WITH TWO SUBQUERIES THAT ARE OR'D TOGETHER USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users who have a SELECT INTO SQL statement containing a subquery predicate that is connected to a residual predicate with an OR operator. RECOMMENDATION: INSTALL UK58742 ON VOLID 1008 (HDB8810) 213 10/08/04 PROBLEM: (PM14102) RC00F30411 WHEN ALLIED ADDRESS SPACE THAT CALLED STORED PROCEDURE WENT INTO EOM AND SP IS IN A LOOP USERS AFFECTED: DB2 users of stored procedures and User Defined Functions (UDFs). RECOMMENDATION: INSTALL UK58902 ON VOLID 1008 (HDB8810) 212 10/08/02 PROBLEM: (PM17827) ABEND04E RC00E2000E FROM DSNVGACE DSNSFBK OFFSET11B6 CAUSED DB2 TO CRASH WITH RC00E50705 USERS AFFECTED: All CICS users of DB2. RECOMMENDATION: INSTALL UK58879 ON VOLID 1007 (HDB8810) 211 10/07/30 PROBLEM: (PM14949) ABEND04E RC00E70005 IN DSNXGDT2 :M201 WHEN PREPARING A SQL STATEMENT WITH A PREDICATE WITH A PARAMETER MARKER USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries that reference a VIEW or table expression that contain a UNION ALL. RECOMMENDATION: INSTALL UK58790 ON VOLID 1007 (HDB8810) 210 10/07/28 PROBLEM: (PM06743) INCORRECT OUTPUT (MORE ROWS) CAN OCCUR WHEN A UNION ALL SUBQUERY IS USED IN A BASIC PREDICATE AND THE UA SUBQUERY RETURNS NO ROWS USERS AFFECTED: All DB2 9 for z/OS users of UNION ALL and all DB2 for z/OS V8 and DB2 9 for z/OS users of field procedures. RECOMMENDATION: INSTALL UK58737 ON VOLID 1007 (HDB8810) 209 10/07/28 PROBLEM: (PM14381) SQLCODE904 MSGDSNT501I DSNOTCSO RC00C900D1 WHEN USING LOB LOCATOR HOST VARIABLE AND THE SELECT LIST USES CAST FUNCTION USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of LOBs. RECOMMENDATION: INSTALL UK58747 ON VOLID 1007 (HDB8810) 208 10/07/26 PROBLEM: (PM12617) ABEND0C4 IN DSNLISKM WHEN A JOB IS RUNNING AS AN APPLICATION REQUESTER AND IT HAS RECEIVED A PREVIOUS ABEND. USERS AFFECTED: All Distributed Data Facility (DDF) users using SNA to communicate between DB2 for z/OS subsystems as a DRDA requester. RECOMMENDATION: INSTALL UK58695 ON VOLID 1007 (HDB8810) 207 10/07/26 PROBLEM: (PM12906) INCORROUT USING MAX FUNCTION VIA DRDA USERS AFFECTED: All DB2 for z/OS V8 users of SQL statements that contain the MAX() or MIN() function. RECOMMENDATION: INSTALL UK58591 ON VOLID 1007 (HDB8810) 206 10/07/26 PROBLEM: (PM13629) ABEND0C4-00000011 IN DSNIDM.DSNIARPL+1830 DURING RECOVERY OF POSTPONE ABORT UR. USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK58690 ON VOLID 1007 (HDB8810) 205 10/07/12 PROBLEM: (PK80760) DEFECT 134796. LOBS USED IN A LIKE PREDICATE OR IN THE POSSTR FUNCTION USERS AFFECTED: All DB2 for z/OS V8 users of LOBs. RECOMMENDATION: INSTALL UK58206 ON VOLID 1007 (HDB8810) 204 10/07/12 PROBLEM: (PM12495) INCORRECT OUTPUT WITH UPPER AND UNICODE/EBCDIC CHAR USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries involving multiple CCSIDs in a predicate. RECOMMENDATION: INSTALL UK58286 ON VOLID 1007 (HDB8810) 203 10/07/12 PROBLEM: (PM14301) ABEND04E 00C90101 DSNICTBU 5001 ON AN IFI READS THREAD USERS AFFECTED: All DB2 users with compressed tablespaces and use IFCID 306 interface. RECOMMENDATION: INSTALL UK58132 ON VOLID 1007 (HDB8810) 202 10/07/08 PROBLEM: (PM13658) ABEND04E RC00F30801 FROM DSNAPRHX WITH CLASS 32 LATCH HELD LC32 CLASS32 USERS AFFECTED: All DB2 V8 and 9 (for z/OS) users. RECOMMENDATION: INSTALL UK58105 ON VOLID 1007 (HDB8810) 201 10/07/08 PROBLEM: (PM15060) POSSIBLE DATA LOSS WHEN IN THE SAME BATCH JOB RUNNING A COPY AND REORG UTILITY AFTER EACH OTHER ON THE SAME MULTI-PIECE PAGESET USERS AFFECTED: DB2 data sharing users RECOMMENDATION: INSTALL UK58064 ON VOLID 1007 (HDB8810) 200 10/07/05 PROBLEM: (PM12779) ABEND04E RC00E20002 IN DSNXEFB .DSNSVSVB +06CC WHEN BINDING AN APPLICATION WITH AN EXTERNAL SQL PROCEDURE CALL STATEMENT USERS AFFECTED: All DB2 v8 users that issue a CALL statement which was defined with NO COLLID attribute. RECOMMENDATION: INSTALL UK58029 ON VOLID 1007 (HDB8810) 199 10/07/02 PROBLEM: (PM13732) CORRUPTED INDEX AFTER LOCK ESCALATION FOLLOWED BY ROLLBACK USERS AFFECTED: All DB2 users running applications bound with isolation level repeatable read (RR). RECOMMENDATION: INSTALL UK57924 ON VOLID 1006 (HDB8810) 198 10/06/23 PROBLEM: (PM08414) IF CCSID CONVERSION AND CHAR / VARCHAR TRUNCATION OCCUR, WRONG SOURCE DATA POINTER RESULTS IN INCORRECT OUTPUT USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of character CCSID conversions. RECOMMENDATION: INSTALL UK57689 ON VOLID 1006 (HDB8810) 197 10/06/23 PROBLEM: (PM10994) ABEND04E RC00E20006 DSNSVBK +X'98E' AFTER A PRIOR ABEND33E. DB2 TRIED TO FREE DMTB STORAGE THAT HAD ALREADY BEEN FREED. USERS AFFECTED: All DB2 for z/OS users running SQL Trigger operations. RECOMMENDATION: INSTALL UK57683 ON VOLID 1006 (HDB8810) 196 10/06/23 PROBLEM: (PM11485) DB2 ABEND04E 00C90101 FROM LOC=DSNIDM DSNILKDR 5003 USERS AFFECTED: All DB2 users RECOMMENDATION: INSTALL UK57656 ON VOLID 1006 (HDB8810) 195 10/06/23 PROBLEM: (PM13108) ABEND04E RC00E20006 ON A FREE REQUEST FROM DSNB5PCO AFTER ABEND04E RC00C20220 IN DSNB5BPL USERS AFFECTED: DB2 data sharing users RECOMMENDATION: INSTALL UK57658 ON VOLID 1006 (HDB8810) 194 10/06/17 PROBLEM: (PM05664) POOR PERFORMANCE OF XML QUREY DUE TO DB2 DOESN'T PUSHDOWN JOIN PREDICATE INTO XMLTABLE USERS AFFECTED: DB2 9 users that use the XMLTABLE function. RECOMMENDATION: INSTALL UK57322 ON VOLID 1006 (HDB8810) 193 10/06/17 PROBLEM: (PM08112) DB2 LOAD DELIMITED FORMAT USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of LOAD FORMAT DELIMITED RECOMMENDATION: INSTALL UK57514 ON VOLID 1006 (HDB8810) 192 10/06/17 PROBLEM: (PM09961) REORG PART RANGE REBALANCE ASSIGNING DUP LIMITKEYS/LEAVING LAST PART EMPTY USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of REORG REBALANCE PART m:n of a table-controlled partitioned table space RECOMMENDATION: INSTALL UK57516 ON VOLID 1006 (HDB8810) 191 10/06/14 PROBLEM: (PM05657) 04E-00E20005 ABEND WHEN IFI READS FOR IFCID 317. USERS AFFECTED: All DB2 for z/OS v8 and DB2 9 (for z/OS) users of READS request for IFCID 317. RECOMMENDATION: INSTALL UK57313 ON VOLID 1006 (HDB8810) 190 10/06/14 PROBLEM: (PM09542) ABND=0C4 LOC=DSNIDM.DSNIDBGC+ 18A2 DURING DB2 RESTART USERS AFFECTED: All DB2 data sharing users of objects with more than 200 partitions (including NPIs with more than 200 logical partitions) RECOMMENDATION: INSTALL UK57307 ON VOLID 1006 (HDB8810) 189 10/06/14 PROBLEM: (PM13798) AFTER AGENT GETS HIT A CALLRTM 04E 00E50013 ABEND IN DSNSVBK, DB2 GETS 04E-00E50003 ABEND. USERS AFFECTED: All DB2 V8 ( HDB8810 ) and V9 ( HDB9910 ) users. RECOMMENDATION: INSTALL UK57318 ON VOLID 1006 (HDB8810) 188 10/06/10 PROBLEM: (PK97922) ABEND0C4 RC00000004 FROM DSNVSRX WHILE RECOVERING INDOUBT THREAD FOR CICS USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK51937 ON VOLID 0911 (HDB8810) 187 10/06/08 PROBLEM: (PM13452) INCORROUT (TOO FEW ROWS) FOUND WHEN A COMPARE AGAINST A VARCHAR IS AN EMPTY STRING, AND PAGE_RANGE=Y AND TABLESPACE SCAN HAPPEN USERS AFFECTED: All users of DB2 with queries comparing a varchar column to an empty string, and the varchar column is part of the partitioning key RECOMMENDATION: INSTALL UK57135 ON VOLID 1006 (HDB8810) 186 10/06/04 PROBLEM: (PM05717) INCORROUT WHEN A QUERY CONTAINS SUBQUERY PREDICATE RUNNING ON I/O PARALLELISM USERS AFFECTED: All DB2 for z/OS 8 and DB2 9 for z/OS I/O parallelism users. RECOMMENDATION: INSTALL UK56880 ON VOLID 1006 (HDB8810) 185 10/05/31 PROBLEM: (PM11441) LONG RUNNING BACKOUT RECOVERY DURING LPL GRECP USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK56911 ON VOLID 1005 (HDB8810) 184 10/05/31 PROBLEM: (PM11446) DSNI021I INCORRECTLY ISSUED WHEN GRECP LPL WAS ABNORMALLY TERMINATED USERS AFFECTED: All users of DB2 RECOMMENDATION: INSTALL UK56909 ON VOLID 1005 (HDB8810) 183 10/05/31 PROBLEM: (PM12294) DB2 RESTART FAILURE WITH ABEND 04E 00C90101 IN DSNIERST WITH ERQUAL53BF USERS AFFECTED: All user of DB2. RECOMMENDATION: INSTALL UK56913 ON VOLID 1005 (HDB8810) 182 10/05/26 PROBLEM: (PM05736) CAN'T RECOVER CATALOG/DIRECTORY TO A RBA POINT IF WE HAVE TWO INDEXES ON SYSCOPY (STOGROUP-INDEX AND VCAT-INDEX) USERS AFFECTED: ALL DB2 FOR z/OS V8 AND DB2 9 FOR z/OS USERS WITH USER-DEFINED INDEXES OVER SYSIBM.SYSCOPY WHICH ARE DB2 STOGROUP MANAGED. RECOMMENDATION: INSTALL UK56800 ON VOLID 1005 (HDB8810) 181 10/05/24 PROBLEM: (PM10650) DSNIIDIS:5002 WHEN QUERY AFTER REBUILD INDEX USERS AFFECTED: All users of DB2 with indexes on alter added varying length columns. RECOMMENDATION: INSTALL UK56753 ON VOLID 1005 (HDB8810) 180 10/05/17 PROBLEM: (PM09544) ABEND04E RC00C90101 FROM DSNGEGSK ERQUAL5001 DURING ALLOCATION USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK56404 ON VOLID 1005 (HDB8810) 179 10/05/12 PROBLEM: (PM09909) PERFORMANCE DEGRADATION, INCREASED HIGH SYNCH I/O, DB2 DASD I/O CONNECT TIMES IN A DATA SHARING ENVIRONMEN USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK56334 ON VOLID 1005 (HDB8810) 178 10/05/10 PROBLEM: (PM01867) DB2 V8 LOAD FAILED WITH ABEND04E RC00E40323 WHEN DECIMAL=COMMA IN DSNHDECP. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of UNLOAD and LOAD of DECIMAL, FLOAT, and DECFLOAT column(s) RECOMMENDATION: INSTALL UK55766 ON VOLID 1005 (HDB8810) 177 10/05/07 PROBLEM: (PM08098) DB2 CRASHES AFTER RC00E20029 DSNB1CPP DSNSVBK USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK56285 ON VOLID 1005 (HDB8810) 176 10/05/07 PROBLEM: (PM08638) ABEND0C4 IN DSNSTACK OFFSET 005A AT UK18810 ** SMCOVERLAY ** USERS AFFECTED: All DB2 Editproc and Validproc user-exit users. RECOMMENDATION: INSTALL UK56261 ON VOLID 1005 (HDB8810) 175 10/05/07 PROBLEM: (PM11360) INCORROUT (TOO MANY ROWS) FOR UNION/UNION ALL QUERY CONTAINING A SUBQUERY TRANSFORMED TO A JOIN USERS AFFECTED: All DB2 for z/OS v8 and v9 users executing queries with UNION or UNION ALL. RECOMMENDATION: INSTALL UK56289 ON VOLID 1005 (HDB8810) 174 10/05/05 PROBLEM: (PM06992) STORAGE LEAK CAUSED BY PIPE MGR / DSNXPCRT +0D93 AFTER SOFT CANCEL RC00E50013 ON CHILD TASK WITH PARALLELISM ENABLED USERS AFFECTED: All DB2 for z/OS 8 and DB2 9 for z/OS SYSPLEX parallelism users. RECOMMENDATION: INSTALL UK56122 ON VOLID 1005 (HDB8810) 173 10/04/23 PROBLEM: (PM05879) ABEND04E RC00E30001 DSNTLDU +06A4 HUNG BATCH JOB ABEND04E RC00E30001 DSNTTRUN +3C3A USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK55764 ON VOLID 1004 (HDB8810) 172 10/04/22 PROBLEM: (PM04569) ABEND04E RC00E70005 IN DSNXORLI :P010 OR SQLINCORR WHEN RUNNING A SQL STATEMENT CONTAINING NESTED OUTER JOIN WITH PARALLELISM USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS parallelism users. RECOMMENDATION: INSTALL UK55819 ON VOLID 1004 (HDB8810) 171 10/04/22 PROBLEM: (PM08970) INCORROUT (NO ROWS FOUND) WHEN IN MEMORY WORKFILE IS USED USERS AFFECTED: All DB2 for z/OS v8 and DB2 9 for z/OS users of joins using sparse index access. RECOMMENDATION: INSTALL UK55840 ON VOLID 1004 (HDB8810) 170 10/04/19 PROBLEM: (PK76676) MISS CLASSIFICATION ON INDEPENDENT ENCLAVE THAT ARE CREATED FOR ZIIP OFFLOAD THAT ARE SUBSYSTEM TYPE DB2 USERS AFFECTED: DB2 V8 users that exploit CP query parallelism while in remote stored procedures and UDFs. RECOMMENDATION: INSTALL UK47686 ON VOLID 0907 (HDB8810) 169 10/04/19 PROBLEM: (PM01529) ABEND04E RC00E72018 AT DSNXSINE+135A(OFFSET135A) WHEN THE RESULT TABLE HAS NULL PADDING USERS AFFECTED: ALL DB2 V8 and V9 users who do multiple outer joins in a SELECT. RECOMMENDATION: INSTALL UK55769 ON VOLID 1004 (HDB8810) 168 10/04/19 PROBLEM: (PM09277) SQLCODE310 FROM DSNXRIHS WHEN RUNNING A MULTI-ROW INSERT IN A DISTRIBUTED ENVIRONMENT USERS AFFECTED: All Distributed Data Facility (DDF) users. Specifically where DB2 is accessed as a server where LOB data is inserted. RECOMMENDATION: INSTALL UK55762 ON VOLID 1004 (HDB8810) 167 10/04/16 PROBLEM: (PM07129) RC00C900F7 AFTER LOAD RESUME ON EMPTY COMPRESSED TABLESPACE USERS AFFECTED: All DB2 for z/OS V8 and DB 9 for z/OS utility users of LOAD on a COMPRESS YES table space RECOMMENDATION: INSTALL UK55742 ON VOLID 1004 (HDB8810) 166 10/04/15 PROBLEM: (PM06118) ABEND04E RC00C90101 DSNIBHRE ERQUAL500D , LOG APPLY RANGE WRONG USERS AFFECTED: All user of DB2. RECOMMENDATION: INSTALL UK55700 ON VOLID 1004 (HDB8810) 165 10/04/15 PROBLEM: (PM10548) RECOVERY FOR ABEND0C4 RC00000011 RLMC-DSNJW117 M=DSNJW008 CAUSED STORAGE OVERLAY(SMCOVERLAY) IN PSA USERS AFFECTED: All users of DB2 Version 8.1. RECOMMENDATION: INSTALL UK55697 ON VOLID 1004 (HDB8810) 164 10/04/12 PROBLEM: (PM05402) INCORROUT (LESS ROWS RETURNED) WHEN NULLABLE UNICODE DBCS COLUMN EXISTS IN THE CORRELATED SUBQUERY USERS AFFECTED: ALL DB2 for z/OS V8 Users. RECOMMENDATION: INSTALL UK55458 ON VOLID 1004 (HDB8810) 163 10/04/08 PROBLEM: (PM08725) RETROFIT PM06933 TO V8 USERS AFFECTED: All DB2 for z/OS Version 8 users of group restart when GRECP state is involved (e.g. MSGDSNB322I is displayed at some point) RECOMMENDATION: INSTALL UK55487 ON VOLID 1004 (HDB8810) 162 10/04/08 PROBLEM: (PM08726) RETROFIT PM07357 TO V8 USERS AFFECTED: All DB2 users doing group restart and performing GRECP/LPL recovery. RECOMMENDATION: INSTALL UK55488 ON VOLID 1004 (HDB8810) 161 10/03/31 PROBLEM: (PM07460) ABEND04E RC00C20221 IN DSNB5GGP CAUSES DB2 TERMINATION USERS AFFECTED: DB2 data sharing users RECOMMENDATION: INSTALL UK55184 ON VOLID 1003 (HDB8810) 160 10/03/29 PROBLEM: (PM04441) RECOVER - FAIL WITH ABEND0C4 PIC11 DSNUCALA+363E USERS AFFECTED: ALL DB2 FOR z/OS V8 AND DB2 9 FOR z/OS USERS OF RECOVER UTILITY RECOMMENDATION: INSTALL UK55108 ON VOLID 1003 (HDB8810) 159 10/03/29 PROBLEM: (PM07258) INCONSISTENT DATA OR BROKEN PAGE AFTER A FAILED RECOVER LOGONLY WAS RESTARTED OR WAS -TERMED AND RERUN USERS AFFECTED: ALL DB2 FOR z/OS V8 AND DB2 9 FOR z/OS USERS OF RECOVER UTILITY WITH LOGONLY RECOMMENDATION: INSTALL UK55106 ON VOLID 1003 (HDB8810) 158 10/03/29 PROBLEM: (PM07734) D134804. AN INCORRECT RESULT SET CAN BE RETURNED FROM COUNT(*) WITH PRE-ORDERING ON THE DISTINCT COLUMN. FEWER ROWS. USERS AFFECTED: All DB2 for z/OS v8 and DB2 9 for z/OS users of DB2 sort. RECOMMENDATION: INSTALL UK55039 ON VOLID 1003 (HDB8810) 157 10/03/29 PROBLEM: (PM07735) ABEND0C7 DSNXVCDF +2FC FOR V8, OFFSET +2A6 FOR V9, OR INCORROUT MULTIPLE DISTINCT STDDEV OR VARIANCE DECIMAL COL, PRECISION 17+ USERS AFFECTED: All DB2 for z/OS v8 and DB2 9 for z/OS users of DB2 sort with Multiple Distinct. RECOMMENDATION: INSTALL UK55042 ON VOLID 1003 (HDB8810) 156 10/03/25 PROBLEM: (PK85279) ABEND04E RC00C90101 IN DSNILGCL WITH ERQUAL5001 USERS AFFECTED: All DB2 for z/OS users of Real Time Statistics. RECOMMENDATION: INSTALL UK54960 ON VOLID 1003 (HDB8810) 155 10/03/22 PROBLEM: (PM07106) INCORROUT VIEW AND LEFT OUTER JOINS INVALID NULL OR ABND0C7 DSNXROHB+26E4 WITH FULL OUTER JOIN OR RC00C90101 DSNIZMOS 5016 USERS AFFECTED: All DB2 R810 users who uses outer join and a view that contains UNION ALL RECOMMENDATION: INSTALL UK54933 ON VOLID 1003 (HDB8810) 154 10/03/15 PROBLEM: (PM03834) INCORROUT (LESS ROW FOUND) ON QUERY WITH CORRELATED SUBQUERY WITH PARALLELISM USERS AFFECTED: ALL DB2 R810 AND R910 PARALLEL USERS. RECOMMENDATION: INSTALL UK54694 ON VOLID 1003 (HDB8810) 153 10/03/12 PROBLEM: (PM03397) INCORRECT OUTPUT NRF WITH KANJI PERCENT % OR UNDERSCORE _ IN LIKE SQLLIKE PREDICATE PATTERN-EXPRESSION, WHEN INDEX PRESENT USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries containing like predicates on mixed data. RECOMMENDATION: INSTALL UK54578 ON VOLID 1003 (HDB8810) 152 10/03/08 PROBLEM: (PK91699) LOAD DATA LOG NO UTILITY FAILED ABEND04E 00C90101 DSNIDBDF 5222 USERS AFFECTED: All DB2 data-sharing users. RECOMMENDATION: INSTALL UK54451 ON VOLID 1003 (HDB8810) 151 10/03/08 PROBLEM: (PM03655) ABEND=04E-00C90101, LOC=DSNIDM.DSNIDBCN:5001 WITH PTF UK44358 OR UK52192 USERS AFFECTED: DB2 users with UK44358 or UK52192 applied. RECOMMENDATION: INSTALL UK54510 ON VOLID 1003 (HDB8810) 150 10/03/05 PROBLEM: (PM01604) ABEND04E RC00E20004 DSNSVBK +05F8 CALLER IS DSNXEPR ON REBIND PACKAGE OR PLAN USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK54421 ON VOLID 1003 (HDB8810) 149 10/03/05 PROBLEM: (PM03163) ABEND04E RC00E20015 DSNSVSTK +0112 STORAGE SHORTAGE ABEND04E RC00E20003 RC00E20004 DSNXEAAL DSNSVBK +061A USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK54438 ON VOLID 1003 (HDB8810) 148 10/03/04 PROBLEM: (PM03869) ECSA SHORTAGE MSGDXR175E SP241 USERS AFFECTED: All DB2 UDB for z/OS V8 and V9 users. RECOMMENDATION: INSTALL UK54384 ON VOLID 1003 (HDB8810) 147 10/03/03 PROBLEM: (PK26951) TOO FEW ROWS RETURNED ON QUERY WITH MATCHING INDEX SCAN USERS AFFECTED: Users of queries that involve JOINs and index scan. RECOMMENDATION: INSTALL UK17114 ON VOLID 0608 (HDB8810) 146 10/03/03 PROBLEM: (PM02648) ABEND 00C90101 IN DSNOLADS ERQUAL501D DURING FORWARD RECOVERY. USERS AFFECTED: All DB2 z/OS user of LOB table space. RECOMMENDATION: INSTALL UK54358 ON VOLID 1003 (HDB8810) 145 10/03/01 PROBLEM: (PM04371) PSEUDO CLOSE INTERRUPTED BY CANCEL OR ABEND CAN RESULT IN MISSING SYSLGRNX RECORDS. POSSIBLE DATA LOSS WITH LOG APPLY. USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK54316 ON VOLID 1002 (HDB8810) 144 10/02/26 PROBLEM: (PK93254) ABEND 0C4 IN DSNIDBMS + 1D16. USERS AFFECTED: All DB2 users of group restart. RECOMMENDATION: INSTALL UK54257 ON VOLID 1002 (HDB8810) 143 10/02/25 PROBLEM: (PM04673) INCORROUT: BINARY ZEROES OR NULLS INSTEAD OF BLANKS AS PAD CHAR FOR FIXED CHAR OUTPUT PARM OF AN EXTERNAL USERS AFFECTED: Users of external SQL procedures containing fixed-length CHAR output parameters on DB2 UDB for z/OS Version 8 or DB2 Version 9.1 for z/OS after PK91710 (PTFs UK50995 and UK50996) is applied. RECOMMENDATION: INSTALL UK54245 ON VOLID 1002 (HDB8810) 142 10/02/24 PROBLEM: (PK92795) ABEND0C4 RC00000004 AT DSNXGRDS DSNXRCTC +091E USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of triggers with table locators. RECOMMENDATION: INSTALL UK54178 ON VOLID 1002 (HDB8810) 141 10/02/24 PROBLEM: (PM04035) INCORRECT SQLCODE538 DSNXICKK WITH ALTER REFERENTIAL CONSTRAINT WITH FIELDPROC FIELD PROCEDURE USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of field procedures. RECOMMENDATION: INSTALL UK54478 ON VOLID 1002 (HDB8810) 140 10/02/22 PROBLEM: (PK90476) DB2 SUBSYSTEM TERMINATION WITH RC00F3040A 00F3040A WHEN RRSAF APPLICATION PROGRAM IS TERMINATED BY THE CANCEL COMMAND USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK54112 ON VOLID 1002 (HDB8810) 139 10/02/17 PROBLEM: (PK97007) AN INCORRECT OUTPUT WITH NO ROW FOUND FOR A SQL WITH INPUT HOST VARIABLE AND LEFT OUTER JOINS WITH TRANSITIVE CLOSURE PREDICATES USERS AFFECTED: the data type promotion hierarchy or whose data length is longer than the data length of the left side column. RECOMMENDATION: INSTALL UK54011 ON VOLID 1002 (HDB8810) 138 10/02/17 PROBLEM: (PM00661) INCORROUT WITH A VIEW ON A SELECT DISTINCT USING FIELDPROC USERS AFFECTED: All R810 and R910 DB2 users using IN predicate which contains a CASE expression. The CASE expression references to a column which is defined with field procedure. RECOMMENDATION: INSTALL UK54038 ON VOLID 1002 (HDB8810) 137 10/02/12 PROBLEM: (PK91135) WEBSPHERE APPLICATION HANG, MANY THREADS WERE WAITING FOR PAGE LATCH, DB2 HAS TO BE FORCED. USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK52099 ON VOLID 1002 (HDB8810) 136 10/02/12 PROBLEM: (PM03247) INCORRECT OUTPUT WITH PARALLELISM DEGREE ANY WITH IN-LIST AND DYNAMIC CACHE STATEMENT ENABLED. USERS AFFECTED: All DB2 z/OS R810 and R910 parallelism users WITH dynamic statement cache CACHEDYN = YES. RECOMMENDATION: INSTALL UK53872 ON VOLID 1002 (HDB8810) 135 10/02/09 PROBLEM: (PK97744) ABEND04E RC00E70005 DSNXOLTI M630 ISSUED FOR NUMERIC LITERALS 09/11/10 PTF PEREMOVE USERS AFFECTED: All DB2 Users who have zparm PREDPRUNE set ON. RECOMMENDATION: INSTALL UK53738 ON VOLID 1002 (HDB8810) 134 10/02/09 PROBLEM: (PM02696) ABND04E RC00C200C3 DSNB1REL+0372 RC00C200B0 DSNB1REL+0318 ABND0C4 RC00000038 DSNB1RTR+0482 WITH PARALLELISM USERS AFFECTED: ALL DB2 R810 AND R910 PARALLELISM USERS. RECOMMENDATION: INSTALL UK53810 ON VOLID 1002 (HDB8810) 133 10/02/08 PROBLEM: (PK99133) TOO MANY ROWS THAT DON'T MATCH THE PREDICATE ARE RETURNED USERS AFFECTED: All DB2 Users who use outer join, case expressions and either views or table expressions. RECOMMENDATION: INSTALL UK53710 ON VOLID 1002 (HDB8810) 132 10/02/05 PROBLEM: (PM02631) ABEND04E RC00C90101 IN DSNIDBDF ERQUAL5321 DURING REBULD INDEX USERS AFFECTED: All DB2 users of Utilities in data sharing when target object exceeds 200 partitions RECOMMENDATION: INSTALL UK53682 ON VOLID 1002 (HDB8810) 131 10/02/04 PROBLEM: (PK99092) INCORROUT (NO ROW FOUND) ON QUERY WITH MULTIPLE ENCODING JOIN AND TRANSITIVE CLOSURE FOR OUTER JOIN ON PREDICATE USERS AFFECTED: All DB2 users who use queries involve multiple encoding schemes, and materialized views or table expressions. RECOMMENDATION: INSTALL UK53641 ON VOLID 1002 (HDB8810) 130 10/02/03 PROBLEM: (PM02674) ABEND04E RC00C90101 IN DSNKINSL ERQUAL5004 USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK53563 ON VOLID 1002 (HDB8810) 129 10/01/28 PROBLEM: (PM02366) DATA IN WRONG PART AND LIMIT KEY WAS CORRUPTED AFTER REORG REBALANCE WITH SORTDATA NO. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of REORG REBALANCE SORTDATA NO RECOMMENDATION: INSTALL UK53374 ON VOLID 1001 (HDB8810) 128 10/01/27 PROBLEM: (PM01154) ABND04E-00C90101 DSNIADR:500B WHEN EXECUTING A SPECIFIC QUERY WITH RID() FUNCTION USERS AFFECTED: All users of DB2 using direct row access in DB2 UDB for z/OS V8 or DB2 V9 for z/OS or using RID function in DB2 V9 for z/OS RECOMMENDATION: INSTALL UK53464 ON VOLID 1001 (HDB8810) 127 10/01/25 PROBLEM: (PM00604) DB2DSHR 910 NFM CRASH WITH ABEND04E RC00E20006 SMCOVERLAY USERS AFFECTED: DB2 users with heavy workload that leads to re-use of the EDM pool. RECOMMENDATION: INSTALL UK53423 ON VOLID 1001 (HDB8810) 126 10/01/25 PROBLEM: (PM02042) ABEND0C4 AT DSNXGRDS.DSNXOGP +7BEA FOR A QUERY CONTAINING A FULL OUTER JOIN AND A SIDEWAY REFERENCE IN THE SAME QUERY BLOCK USERS AFFECTED: All R810 and R910 users of FULL OUTER JOIN RECOMMENDATION: INSTALL UK53411 ON VOLID 1001 (HDB8810) 125 10/01/25 PROBLEM: (PM04012) ABEND04E RC00C90101 DSNGEFLC:5001 USERS AFFECTED: DB2 users who canceled a thread while loading a package with PK87130/UK48546 applied. RECOMMENDATION: INSTALL UK53421 ON VOLID 1001 (HDB8810) 124 10/01/22 PROBLEM: (PM00229) INCORROUT WHEN SET FUNCTION INPUT IS USING FIELDPROC AND RUNNING IN PARALLEL USERS AFFECTED: All DB2 z/OS R810 and R910 FIELDPROC parallelism users. RECOMMENDATION: INSTALL UK53364 ON VOLID 1001 (HDB8810) 123 10/01/21 PROBLEM: (PM00934) REPAIR DBD TEST INDICATES DIFFERENCE OF OBDRX2IE BETWEEN CATALOG AND DIRECTORY AFTER GETTING SQLCODE 20272 IN CREATE INDEX. USERS AFFECTED: All DB2 V8 Users who have an identity column or ROWID column in a partitioning key. RECOMMENDATION: INSTALL UK52456 ON VOLID 1001 (HDB8810) 122 10/01/21 PROBLEM: (PM01252) 04E 00C90101 ABEND IN DSNTFRCV,LOC=DSNIDM DSNIDBDF 5320 USERS AFFECTED: All DB2 users RECOMMENDATION: INSTALL UK53329 ON VOLID 1001 (HDB8810) 121 10/01/20 PROBLEM: (PK93631) LOOP AFTER I/O ERRORS ON WORKFILE. USERS AFFECTED: All DB2 users of workfiles or created global temporary tables (CGTT) RECOMMENDATION: INSTALL UK53278 ON VOLID 1001 (HDB8810) 120 10/01/20 PROBLEM: (PK97088) REORG WITH SORTDATA NO AND DPSIS USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of REORG SORTDATA NO. RECOMMENDATION: INSTALL UK53300 ON VOLID 1001 (HDB8810) 119 10/01/20 PROBLEM: (PM01199) ABEND04E RC00C90101 IN DSNIRNXT:500F DURING QUERY OR ABEND04E RC00C9021A IN DSNIRFNX:500A DURING REORG TABLESPACE USERS AFFECTED: DB2 data sharing users RECOMMENDATION: INSTALL UK53321 ON VOLID 1001 (HDB8810) 118 10/01/20 PROBLEM: (PM01434) INCORROUT ON A QUERY WITH LEFT OUTER JOIN AS PART OF AN IN SUBQUERY WITH SORT MERGE JOIN ACCESS PATH USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of outer join RECOMMENDATION: INSTALL UK53306 ON VOLID 1001 (HDB8810) 117 10/01/18 PROBLEM: (PK89926) CUR BLOCK NOT FREED WHICH CAUSES STORAGE LEAK USERS AFFECTED: All DB2 for z/OS v8 or DB2 9 (for z/OS) users of dynamically prepared cursors declared WITH HOLD or users of static cursors declared with the FOR UPDATE clause and bound with REOPT(VARS). RECOMMENDATION: INSTALL UK49949 ON VOLID 0909 (HDB8810) 116 09/12/31 PROBLEM: (PM00860) AB04E DSNXXXXX . DSNSVBK +0994 AFTER ALLOCATE CURSOR ACCESS OF WITH HOLD STORED PROC RESULT SETS FOR REPEATED INVOCATIONS USERS AFFECTED: All DB2 users of ALLOCATE CURSOR to access stored procedure WITH HOLD result sets, followed by COMMIT then ROLLBACK RECOMMENDATION: INSTALL UK52863 ON VOLID 0912 (HDB8810) 115 09/12/28 PROBLEM: (PK98592) INCORROUT NO ROW FOUND NRF WITH CGTT WITH SELECT FROM INSERT OF SUBSELECT. THIS WILL BE THE ENABLING APAR. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of created Global Temporary Tables. RECOMMENDATION: INSTALL UK52810 ON VOLID 0912 (HDB8810) 114 09/12/16 PROBLEM: (PK97013) INCORROUT OF QUERY WITH PARALLELISM WHEN UNION LEG OUTMOST SELECT LIST CONTAINS ONLY LIT CONSTANT AND AGGREGATE FUNCTION USERS AFFECTED: All DB2 z/OS R810 and R910 parallelism users. RECOMMENDATION: INSTALL UK52318 ON VOLID 0912 (HDB8810) 113 09/12/16 PROBLEM: (PM01819) INCREASE IN E/CSA AND E/SQA USAGE WHEN RUNNING MANY CONCURRENT DATA RECOVER OPERATIONS IN DATA SHARING MODE. USERS AFFECTED: All data sharing users of DB2. RECOMMENDATION: INSTALL UK52393 ON VOLID 0912 (HDB8810) 112 09/12/11 PROBLEM: (PK97008) INCORROUT (MORE ROW FOUND) ON QUERY WITH LEFT OUTER JOIN AND NOT EXIST SUBQUERY USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of outer join RECOMMENDATION: INSTALL UK52253 ON VOLID 0912 (HDB8810) 111 09/12/11 PROBLEM: (PK98422) DSNU713I (MSGDSNU713I) AFTER RESTART ON A DISASTER RECOVERY (DR) SYSTEM WHEN A CONNECT TO THE GROUP BUFFERPOOL (GBP) FAILS. USERS AFFECTED: All DB2 data sharing users. RECOMMENDATION: INSTALL UK52261 ON VOLID 0912 (HDB8810) 110 09/12/11 PROBLEM: (PK99468) SQLCODE919 FROM DSNXERT WHEN CALLING STORED PROCEDURE DSNUTILU USERS AFFECTED: RECOMMENDATION: INSTALL UK52279 ON VOLID 0912 (HDB8810) 109 09/12/11 PROBLEM: (PM01227) 0C4-11 LOAD PARTITION PARALLELISM WITH DELIMITED INPUT USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of LOAD FORMAT DELIMITED with multiple INTO TABLE PART INDDN statements resulting in parallel load tasks RECOMMENDATION: INSTALL UK52304 ON VOLID 0912 (HDB8810) 108 09/12/09 PROBLEM: (PK94570) ABND=0C4-00000004 LOC=DSNBBM .DSNB1CMS+14B4 USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK52198 ON VOLID 0912 (HDB8810) 107 09/12/09 PROBLEM: (PK97914) ABEND04E-00C200BD IN DSNB1REL WHICH MAY CAUSE DB2 SUBSYSTEM TERMINATION. USERS AFFECTED: All DB2 users RECOMMENDATION: INSTALL UK52194 ON VOLID 0912 (HDB8810) 106 09/12/09 PROBLEM: (PK99747) INCOMPATIBLE RETAINED LOCKS DETECTED DURING GROUP RESTART. USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK52192 ON VOLID 0912 (HDB8810) 105 09/12/02 PROBLEM: (PK94548) INCORROUT NO ROW FOUND NRF WITH CGTT WITH SELECT FROM INSERT OF SUBSELECT. THIS WILL BE THE PRE-CONDITIONING APAR. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of created Global Temporary Tables. RECOMMENDATION: INSTALL UK51903 ON VOLID 0911 (HDB8810) 104 09/12/02 PROBLEM: (PK96530) QUERY RECEIVES LESS ROWS FOUND WHEN CONSTANTS IN AN INLIST ARE OUT OF ORDER AND PARALLELISM_MODE=C DEGENERATES AT RUNTIME USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of inlist predicate with parallel access plan RECOMMENDATION: INSTALL UK51743 ON VOLID 0911 (HDB8810) 103 09/11/27 PROBLEM: (PK97679) ABEND04E RC00E50003 FROM DSNVXLT0 WHILE STORED PROCEDURE ADDRESS SPACE WENT INTO EOM USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK51843 ON VOLID 0911 (HDB8810) 102 09/11/26 PROBLEM: (PK84589) INCORROUT ON QUERY WITH UNION, EXCEPT, AND NON-BOOLEAN TERM PREDICATE USERS AFFECTED: All DB2 R810 and R910 users using view or table expressions with UNION/UNION ALL and each leg of the UNION contains predicates on the same columns. RECOMMENDATION: INSTALL UK51795 ON VOLID 0911 (HDB8810) 101 09/11/23 PROBLEM: (PK91770) COLUMN TRUNCATED WHEN SELECT DISTINCT IN A VIEW WITH A FIELDPROC USERS AFFECTED: All R810 and R910 users using view based on tables defined with field procedure RECOMMENDATION: INSTALL UK51710 ON VOLID 0911 (HDB8810) 100 09/11/20 PROBLEM: (PK98270) 00C90101 DSNODAL1:5003 DUE TO PAGE REGRESSION IN LOB SPACEMAP PAGES USERS AFFECTED: DB2 data-sharing users using copy shrlevel change. RECOMMENDATION: INSTALL UK51708 ON VOLID 0911 (HDB8810) 99 09/11/17 PROBLEM: (PK94571) DATA SHARING - ABEND0C4 IN DSNVEUS1 DURING RESTART USERS AFFECTED: DB2 users with PK88282 (UK48770 or UK48771) applied. RECOMMENDATION: INSTALL UK51663 ON VOLID 0911 (HDB8810) 98 09/11/16 PROBLEM: (PK89057) INCORRECT OUTPUT AFTER INSERTING VARBINARY DATA ON A REMOTE DB2 SERVER USERS AFFECTED: All DB2 for z/OS V8 users of Multi-Row Fetch (MRF) and DB2 9 for z/OS users of MRF and Multi-Row Insert (MRI). RECOMMENDATION: INSTALL UK51514 ON VOLID 0911 (HDB8810) 97 09/11/16 PROBLEM: (PK97897) ABEND04E RC00E70005 IN DSNXRUID :M230 WHEN RUNNING A NON-CURSOR UPDATE WITH A MIGRATED OLD PACKAGE BOUND I USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of positioned and searched UPDATEs that are contained in packages bound before V6 with PK66334 applied (ptf UK45684 or ptf UK45685). RECOMMENDATION: INSTALL UK51547 ON VOLID 0911 (HDB8810) 96 09/11/13 PROBLEM: (PK96508) SELECT WITH A SET FUNCTION FROM INSERT USING FINAL TABLE PRODUCES AN INCORRECT RESULT SET. USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of SELECT from INSERT with the INSERT containing the VALUES clause. RECOMMENDATION: INSTALL UK51462 ON VOLID 0911 (HDB8810) 95 09/11/12 PROBLEM: (PK92642) ABEND04E RC00E70005 DSNXI14 :P043 DURING REVOKE PROCESSING USERS AFFECTED: Users of the SQL REVOKE statement. RECOMMENDATION: INSTALL UK51406 ON VOLID 0911 (HDB8810) 94 09/11/09 PROBLEM: (PK77767) BIND WHILE IN ENFM CAUSING 04E RC00C90105 ERQUAL0C28 AND WEPR STATUS ON SPT01 USERS AFFECTED: All DB2 users that BIND packages when the DB2 system is being migrated to NFM mode. RECOMMENDATION: INSTALL UK51213 ON VOLID 0911 (HDB8810) 93 09/11/09 PROBLEM: (PK93345) ABND=04E-00C90101 WITH DSNOALLO:500E USERS AFFECTED: ALL DB2 FOR z/OS V8 USERS OF RECOVER UTILITY ON LOB TABLE SPACES RECOMMENDATION: INSTALL UK51274 ON VOLID 0911 (HDB8810) 92 09/11/05 PROBLEM: (PK96623) UNLOAD DELIMITED WITH LARGE LOB DATA CAN CAUSE A STORAGE OVERLAY USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS UNLOAD DELIMITED or NOPAD utility users with LOB or XML columns RECOMMENDATION: INSTALL UK51204 ON VOLID 0911 (HDB8810) 91 09/11/02 PROBLEM: (PK91597) ABEND0C4 RC11 DSNXGRDS DSNXERT 9182 USERS AFFECTED: All DB2 users of SET CURRENT PACKAGE PATH on DB2 for z/OS v8 or DB2 9 (for z/OS). RECOMMENDATION: INSTALL UK51135 ON VOLID 0910 (HDB8810) 90 09/10/29 PROBLEM: (PK97705) DB2 SUBSYSTEM TERMINATION WITH ABEND30D RC00F30411 BECAUSE OF HANG IN DSNJR001 AFTER ALLIED ADDRESS SPACE EOM USERS AFFECTED: All users of DB2. RECOMMENDATION: INSTALL UK50988 ON VOLID 0910 (HDB8810) 89 09/10/28 PROBLEM: (PK95958) DB2 MAY HANG AFTER A CANCEL OF TERMINATE IDENTIFY PROCESSING USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK50975 ON VOLID 0910 (HDB8810) 88 09/10/22 PROBLEM: (PK93237) INCORROUT WHEN RUNNING QUERY WITH PREDICATES NOT BETWEEN USERS AFFECTED: All DB2 R810 and R910 users when running query with NOT BETWEEN predicate. RECOMMENDATION: INSTALL UK50795 ON VOLID 0910 (HDB8810) 87 09/10/22 PROBLEM: (PK96278) DB2 COPROCESSOR PROBLEM USERS AFFECTED: Users of DB2 coprocessor for DB2 UDB for z/OS and OS/390 810 910 RECOMMENDATION: INSTALL UK50817 ON VOLID 0910 (HDB8810) 86 09/10/20 PROBLEM: (PK93422) LOOP IN DB2 ISSUING A PAGE P-LOCK FROM CSECT DSNB1LTS WHILE RUNNING AS A NON-PREMPTABLE SRB. USERS AFFECTED: DB2 data sharing users with PK67826 (UK37867 or UK37868) applied. RECOMMENDATION: INSTALL UK50704 ON VOLID 0910 (HDB8810) 85 09/10/16 PROBLEM: (PK90875) ABEND=0C4-00000011,LOC=DSNXAUTH.DSNXASPC+04D8 WHEN USING 1 BYTE COLLECTION ID USERS AFFECTED: DB2 users with PK28195/UK26167 (DB2 V8) or PK47008/UK29665 (DB2 V9) applied. RECOMMENDATION: INSTALL UK50614 ON VOLID 0910 (HDB8810) 84 09/10/13 PROBLEM: (PK91403) LOAD UTILITY INLINE COPY IS NOT EXECUTED AFTER WHEN CLAUSE USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of LOAD INTO TABLE specifying COPYDDN after a WHEN keyword RECOMMENDATION: INSTALL UK50447 ON VOLID 0910 (HDB8810) 83 09/10/13 PROBLEM: (PK96494) ABEND0C4 RC04 IN DSNJPOPN +076E VSAM READ ERROR ON BSDS DATA SET USERS AFFECTED: All data sharing users of DB2. RECOMMENDATION: INSTALL UK50567 ON VOLID 0910 (HDB8810) 82 09/10/12 PROBLEM: (PK56334) ABEND04E RC00C90101 DSNISREC:500A ON -STA DB COMMAND USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users who execute the REORG utility. RECOMMENDATION: INSTALL UK36073 ON VOLID 0805 (HDB8810) 81 09/10/12 PROBLEM: (PK85482) SQLCODE407 WHEN RUNNING AN UPDATE WHERE A VIEW AND INLIST PRECESSING IS INVOLVED USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of left or right outer join RECOMMENDATION: INSTALL UK50461 ON VOLID 0910 (HDB8810) 80 09/10/12 PROBLEM: (PK90413) INCORROUT WITH INTEGER COLUMN WHEN USING OUTER JOIN A VIEW USERS AFFECTED: All DB2 V810 users who use outer join. RECOMMENDATION: INSTALL UK50369 ON VOLID 0910 (HDB8810) 79 09/10/12 PROBLEM: (PK92801) VARIOUS STORAGE-RELATED ABENDS COULD OCCUR ON A QUERY USING AN MQT (MATERIALIZED QUERY TABLE) USERS AFFECTED: All DB2 for z/OS V8 users who use materialized query tables (MQTs). RECOMMENDATION: INSTALL UK50372 ON VOLID 0910 (HDB8810) 78 09/10/12 PROBLEM: (PK94876) INCORRECT SQLCODE100 NRF NO ROW FOUND WITH UPDATE SQLUPDATE STATEMENT FOR CONCURRENT UPDATE OPERATIONS. EVALUNC IS ON. USERS AFFECTED: All DB2 users using EVALUNC system parameter and RID list access. RECOMMENDATION: INSTALL UK50357 ON VOLID 0910 (HDB8810) 77 09/10/08 PROBLEM: (PK76769) DB2 TERMINATED WITH RC00E50702 WITH PRIOR 00E20016 FROM PLOCK ENGINE USERS AFFECTED: All DB2 V8 or higher users. RECOMMENDATION: INSTALL UK43266 ON VOLID 0902 (HDB8810) 76 09/10/02 PROBLEM: (PK93683) AFTER SYSTEM RESET AN LPAR, DB2 TRIED TO RESTART BUT ALL DB2S HUNG. RR P-LOCK & PB-PBA LATCH DEADLOCK USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK50168 ON VOLID 0909 (HDB8810) 75 09/09/28 PROBLEM: (PK90182) INCORROUT OUTER JOIN AND CORRELATED SUBQ PRED. CORRELATED COL HAS DIFFERENT DATA TYPE/LENGTH/NULL THEN OTHER SIDE PREDICATE USERS AFFECTED: ALL DB2 R810 AND R910 USERS USING OUTER JOIN AND CORRELATED SUBQUERY PREDICATE. RECOMMENDATION: INSTALL UK49937 ON VOLID 0909 (HDB8810) 74 09/09/28 PROBLEM: (PK92184) INCORROUT (MORE ROWS) FOR FULL OUTER JOIN WITH PARALLELISM WHEN NUMBER OF PARTITIONING KEYS DIFFERS FROM NUMBER OF SORT KEYS USERS AFFECTED: All DB2 for z/OS parallelism users who use full outer join. RECOMMENDATION: INSTALL UK49965 ON VOLID 0909 (HDB8810) 73 09/09/23 PROBLEM: (PK85042) ABEND0C7 IN LMOD DSNIDM CSECT DSNIMOFR DURING REORG. USERS AFFECTED: Users who alter a decimal column created prior to V8 RECOMMENDATION: INSTALL UK49760 ON VOLID 0909 (HDB8810) 72 09/09/17 PROBLEM: (PK83248) ABEND04E-00E70005 DSNXI14 ON DDL STATEMENT. USERS AFFECTED: All DB2 users of CREATE TABLE and ALTER TABLE statements involving distinct type columns. RECOMMENDATION: INSTALL UK49721 ON VOLID 0909 (HDB8810) 71 09/09/16 PROBLEM: (PK92961) 04E-00D94002 DSNRUA02 IF GLOBAL TRANSACTION CONNECTION IS ABORTED EVEN THOUGH STATE OF TRANSACTION IS COMMITTED USERS AFFECTED: All Distributed Data Facility (DDF) users. RECOMMENDATION: INSTALL UK49718 ON VOLID 0909 (HDB8810) 70 09/09/14 PROBLEM: (PK89364) ABEND0C6 IN DSNUSTBL+4E7A BECAUSE THE COMPRESSION DICTIONARY WAS DROPPED DURING A RESTARTED LOAD UTILITY JOB TO TS PARTITIONED. USERS AFFECTED: All DB2 for z/OS V8 utility users of LOAD RESUME YES on a COMPRESS YES partitioned table space RECOMMENDATION: INSTALL UK49619 ON VOLID 0909 (HDB8810) 69 09/09/14 PROBLEM: (PK90120) DATA LOSS OF ENTIRE PART REORG PART (N:M) AFTER ALTER ROTATION USERS AFFECTED: All DB2 for z/OS V8 utility users of REORG PART(m:n) using SORTDATA after an ALTER ROTATE PART FIRST TO LAST RECOMMENDATION: INSTALL UK49599 ON VOLID 0909 (HDB8810) 68 09/09/14 PROBLEM: (PK92718) RC00C90101 DSNICUMW ERQUAL5399 USERS AFFECTED: Users of DB2 V91 for zOS column versioning RECOMMENDATION: INSTALL UK49494 ON VOLID 0909 (HDB8810) 67 09/09/11 PROBLEM: (PK90935) ABEND04E RC00E20016 IN DSNSLD1 .DSNSVSTK+05B8 USERS AFFECTED: All users of DB2 for z/OS who collect SYSIBM.SYSCOLSTATS statistics for their partitioned tablespaces. Those who have PK62804 (UK38708 on V8; UK38709 on V9) applied are more susceptible to the problem. RECOMMENDATION: INSTALL UK49580 ON VOLID 0909 (HDB8810) 66 09/09/11 PROBLEM: (PK93042) INCORROUT (LESS ROW RETURNED) WHEN USING PAGE RANGE SCREENING USERS AFFECTED: DB2 for z/OS users who run queries on partitioned tables RECOMMENDATION: INSTALL UK49692 ON VOLID 0909 (HDB8810) 65 09/09/10 PROBLEM: (PK88917) STORED PROCEDURE USING HUGE AMOUNTS OF VIRTUAL STORAGE IN DBM1 DUE TO LEAK OF SP RESULT SET BLOCKS RSL USERS AFFECTED: All DB2 users of remote stored procedures on DB2 for z/OS v8 or DB2 9 (for z/OS) that open result set cursors declared WITH HOLD. RECOMMENDATION: INSTALL UK49539 ON VOLID 0909 (HDB8810) 64 09/09/10 PROBLEM: (PK90521) INCORROUT FEWER ROWS FOR QUERIES WITH PARTITIONED TABLE WITH > OR >= RANGE PREDICATE AND DPSI INDEX AND P USERS AFFECTED: All V8 DB2 for z/OS users that have PK64504/UK38122 applied, and with queries involving partitioned tables, EQUAL or IN-list predicates with host variables or parameter markers, and a DPSI index. RECOMMENDATION: INSTALL UK49455 ON VOLID 0909 (HDB8810) 63 09/09/07 PROBLEM: (PK88834) GLOBAL TRANSACTION PROTOCOL IS NOT ENFORCED BY CLIENT USERS AFFECTED: All DB2 users that have threads with associated XIDs (global transactions). RECOMMENDATION: INSTALL UK49428 ON VOLID 0909 (HDB8810) 62 09/09/04 PROBLEM: (PK88224) EDM POOL FULL ABEND04E RC00C90089 OR FILLING UP WITH PT PAGES WHEN CALLING NESTED STORED PROCEDURES USERS AFFECTED: All DB2 users of stored procedures on on DB2 for z/OS v8 NFM or DB2 9 (for z/OS). RECOMMENDATION: INSTALL UK49337 ON VOLID 0909 (HDB8810) 61 09/08/28 PROBLEM: (PK87570) ABEND04E RC00E70005 DSNXVTRS:M420 ON CREATE OF A UNICODE TABLE. CALLER IS DSNXICDM. USERS AFFECTED: All V8 DB2 users of CREATE TABLE, DECLARE GLOBAL TEMPORARY TABLE and ALTER TABLE ADD COLUMN creating a VARCHAR or VARGRAPHIC column with a default value. RECOMMENDATION: INSTALL UK49164 ON VOLID 0908 (HDB8810) 60 09/08/27 PROBLEM: (PK85002) DB2 ABEND WITH 00E50048 OR 00D92023 REASON CODE - CAN ALSO BE OTHER ABENDS USERS AFFECTED: All DB2 users of global transactions on DB2 for z/OS v8 NFM or DB2 9 (for z/OS). RECOMMENDATION: INSTALL UK49145 ON VOLID 0908 (HDB8810) 59 09/08/26 PROBLEM: (PK80244) ABEND04E RC00C90101 DSNISTWF VRACE5001 USERS AFFECTED: All DB2 V8 for z/OS users of workfile database RECOMMENDATION: INSTALL UK49125 ON VOLID 0908 (HDB8810) 58 09/08/26 PROBLEM: (PK91344) WHEN RUNNING THE LOAD UTILITY WITH "VARCHAR BIT" FOR SOME COLUMNS THE DATA ARE CONVERTED. USERS AFFECTED: All DB2 for z/OS V8 utility users of LOAD with VARCHAR BIT input data and target column is VARCHAR RECOMMENDATION: INSTALL UK49122 ON VOLID 0908 (HDB8810) 57 09/08/19 PROBLEM: (PK91277) LOOP IN DSNB1SWS TRYING TO ACQUIRE A RETAINED LOCK USERS AFFECTED: DB2 data sharing users with the RETLWAIT ZPARM set to a non-zero value. RECOMMENDATION: INSTALL UK48960 ON VOLID 0908 (HDB8810) 56 09/08/17 PROBLEM: (PK87842) ABND=04E-00E20029,LOC=DSNLCDG2.DSNSVBK +0A54 USERS AFFECTED: All Distributed Data Facility (DDF) users. Specifically, those using DB2 for z/OS as a server and have enabled Database System Monitor on the client to monitor remote statements. RECOMMENDATION: INSTALL UK48717 ON VOLID 0908 (HDB8810) 55 09/08/17 PROBLEM: (PK87935) INCORRECT OUTPUT OF SELECT AFTER UPDATE OF PARTITIONED INDEX WITHOUT COMMIT WHEN PAGE RANGE IS ENABLED USERS AFFECTED: All DB2 users . RECOMMENDATION: INSTALL UK48804 ON VOLID 0908 (HDB8810) 54 09/08/17 PROBLEM: (PK88978) RETAINED LOCKS ( RC00C20254 ) AFTER START DB2 (LIGHT) USERS AFFECTED: All DB2 Data sharing users. RECOMMENDATION: INSTALL UK48931 ON VOLID 0908 (HDB8810) 53 09/08/13 PROBLEM: (PK87559) MIGRATION JOB DSNTIJEN STEP ENFM1105 INCORROUT TO RTS TABLES CAUSES BAD CONVERSION USERS AFFECTED: All DB2 V8 for z/OS or DB2 9 for z/OS users of Cross Loader with different CCSIDs on the source and target and UK46235 or UK46236 applied. RECOMMENDATION: INSTALL UK48724 ON VOLID 0908 (HDB8810) 52 09/08/13 PROBLEM: (PK88282) 00C90101 IN DSNIARPL ERQUAL5008 DURING DB2 RESTART USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK48770 ON VOLID 0908 (HDB8810) 51 09/08/12 PROBLEM: (PK89202) ORDER BY MAY NOT PRODUCE THE CORRECT ORDER WHEN THE QUERY CONTAINS THE RANK FUNCTION USERS AFFECTED: DB2 V9 for z/OS users who execute queries containing a RANK function or an ORDER BY clause; and DB2 for z/OS (V8 and V9) users of EXPLAIN who have DSN_QUERY_TABLE or DSN_VIEWREF_TABLE defined. RECOMMENDATION: INSTALL UK48714 ON VOLID 0908 (HDB8810) 50 09/08/10 PROBLEM: (PK86619) VARIOUS ABENDS DUE TO STORAGE OVERLAY WHEN QUERY CONTAINS GROUP BY W/ HAVING WHICH INCLUDES CORR SUBQ & SET FN PRED IN PARALLEL USERS AFFECTED: All DB2 for z/OS parallelism users. RECOMMENDATION: INSTALL UK48380 ON VOLID 0908 (HDB8810) 49 09/08/07 PROBLEM: (PK87130) ABEND04E RC00C90101 DSNGEPLC ERQUAL500A OR ABEND0C4 DSNGEFLC: 500E OR ABEND0C4 DSNGEFSP+0190 DURING READ/BIND/FREE OF PACKAGE USERS AFFECTED: All DB2 users in data sharing environment. RECOMMENDATION: INSTALL UK48546 ON VOLID 0908 (HDB8810) 48 09/08/05 PROBLEM: (PK82197) ABEND0C6 IN DSNICMT2 + 6924 ON CS INSTRUCTION BECAUSE R7 IS INVALID. USERS AFFECTED: Users of DB2 for zOS V8 and V9 with PK49158 or PK72242 applied. RECOMMENDATION: INSTALL UK45485 ON VOLID 0904 (HDB8810) 47 09/08/05 PROBLEM: (PK86168) INCORROUT (LESS ROW FOUND) ON QUERY WITH OUTER JOIN AND SUBQUERY WITH PARALLELISM USERS AFFECTED: ALL DB2 R810 AND R910 PARALLELISM USERS. RECOMMENDATION: INSTALL UK48505 ON VOLID 0908 (HDB8810) 46 09/07/29 PROBLEM: (PK81874) SYSTEM CRASH CAUSED BY STORAGE OVERLAY AFTER A PADDED INDEX DATA SET WAS COPIED TO A NOT PADDED INDEX USING DSN1COPY UTILITY USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK48294 ON VOLID 0907 (HDB8810) 45 09/07/29 PROBLEM: (PK88394) BROKEN DATA AFTER RECOVERING INDOUBT USERS AFFECTED: DB2 Data-sharing users with PTF UK37812 or UK37813 applied. RECOMMENDATION: INSTALL UK48296 ON VOLID 0907 (HDB8810) 44 09/07/29 PROBLEM: (PK89454) ABEND0C4-00000004 IN DSNWAACT USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK48300 ON VOLID 0907 (HDB8810) 43 09/07/23 PROBLEM: (PK85808) QUERY USING DPSI INDEX ACCESS RECEIVES INCORROUT WHEN INDEX IS DEFINED ON VARCHAR COLUMNS AND INDEX IS NOT PADDED. USERS AFFECTED: All DB2 users using data-partitioned secondary indexes (DPSI) RECOMMENDATION: INSTALL UK48154 ON VOLID 0907 (HDB8810) 42 09/07/23 PROBLEM: (PK88508) INCORRECT OUTPUT FROM LOWER (LCASE) BUILT-IN FUNCTION ON DBCS EBCDIC DATA USERS AFFECTED: All users of LOWER built-in function with EBCDIC DBCS input argument. RECOMMENDATION: INSTALL UK48110 ON VOLID 0907 (HDB8810) 41 09/07/23 PROBLEM: (PK88963) ABEND40D-10 OR ABEND878 BECAUSE A HUGE NUMBER OF UTILITY MESSAGE IN STORAGE USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of the LOAD utility. RECOMMENDATION: INSTALL UK48171 ON VOLID 0907 (HDB8810) 40 09/07/23 PROBLEM: (PK90540) INCORROUT IN V9 WHEN OPTHINT CONTAINS SORT MERGE JOIN (METHOD=2) ACCESS PLAN USERS AFFECTED: All users of DB2 Optimization Hints. RECOMMENDATION: INSTALL UK48503 ON VOLID 0907 (HDB8810) 39 09/07/22 PROBLEM: (PK88299) SQLCODE204 DUE TO CURRENT SCHEMA BEING CHANGED TO DEFAULT SCHEMA (AUTHID) WHEN NUM OF SET SCHEMA ISSUED > 65535 / FFFFX USERS AFFECTED: All DB2 for z/OS V8 users of SQL statement SET CURRENT SCHEMA and DB2 connections that are long-running RECOMMENDATION: INSTALL UK48066 ON VOLID 0907 (HDB8810) 38 09/07/15 PROBLEM: (PK71208) QUERY USING INDEX ACCESS RECEIVES INCORROUT WHEN THERE IS AN ALTER ADDED COLUMN IN INDEX WITH DESCENDING ORDERING AND DEFAULT USERS AFFECTED: All DB2 users using indexes. RECOMMENDATION: INSTALL UK47885 ON VOLID 0907 (HDB8810) 37 09/07/15 PROBLEM: (PK73452) ABEND04E RC00E70005 AT DSNXIAB2: P068 WHEN ALTER TABLE WITH DROP FOREIGN KEY USERS AFFECTED: All DB2 users of constraints. RECOMMENDATION: INSTALL UK47862 ON VOLID 0907 (HDB8810) 36 09/07/15 PROBLEM: (PK84394) INCORROUT (NO ROW FOUND) DURING THE SECOND (AND LATER) CALL ON PROCEDURE TO RUN QUERY WITH VARCHAR HOSTVAR AND INDEX ACCESS USERS AFFECTED: All DB2 users using indexes. RECOMMENDATION: INSTALL UK47902 ON VOLID 0907 (HDB8810) 35 09/07/13 PROBLEM: (PK88278) ABEND04E RC00E50097 DSNB1IOR +202A USERS AFFECTED: DB2 users. RECOMMENDATION: INSTALL UK47835 ON VOLID 0907 (HDB8810) 34 09/07/10 PROBLEM: (PK77603) ABEND=04E-00C90101 AT DSNISMRS ERQUAL5003 DURING SPACE SEARCH USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK45359 ON VOLID 0904 (HDB8810) 33 09/07/10 PROBLEM: (PK86403) DB2 CRASHED AFTER BELOW THE LINE STORAGE IS DEPLETED WHEN THE LOAD LOB JOB WAS RUNNING. ACEE BLOCKS FILL UP THE STORAGE. USERS AFFECTED: All DB2 V8 for z/OS users of LOAD with LOB file reference variables RECOMMENDATION: INSTALL UK47717 ON VOLID 0907 (HDB8810) 32 09/07/09 PROBLEM: (PK81214) INCORROUT WHEN USING RECURSIVE SQL, X'00' IS PART OF THE RESULT USERS AFFECTED: All DB2 V8 and V9 users who use recursive common table expression which contains outer join. RECOMMENDATION: INSTALL UK47644 ON VOLID 0907 (HDB8810) 31 09/07/09 PROBLEM: (PK85550) INCORROUT (TOO MANY ROWS) FOR A QUERY USING PARALLEL SORT TO SATISFY AN ORDER BY ON A SET FUNCTION RESULT USERS AFFECTED: All DB2 for z/OS parallelism users. RECOMMENDATION: INSTALL UK47595 ON VOLID 0907 (HDB8810) 30 09/07/09 PROBLEM: (PK85890) ABEND04E 00C90101 DSNOLDEL :5005 AFTER EXTENT FAILURE IN LOB TABLESPACE. ANOTHER SYMPTOM ABEND04E 00C90D01 DSNOTCSO :53AC. USERS AFFECTED: All users of DB2 LOB Table Space RECOMMENDATION: INSTALL UK47584 ON VOLID 0907 (HDB8810) 29 09/07/09 PROBLEM: (PK87666) INCORROUT (NRF) WHEN PREDICATE INVOLVING COALESCE FUNCTION WHICH CONTAINS A SUBQUERY OR SCALAR FULL SELECT USERS AFFECTED: All DB2 R810 users of scalar fullselect in predicate. RECOMMENDATION: INSTALL UK47651 ON VOLID 0907 (HDB8810) 28 09/07/06 PROBLEM: (PK83005) ABEND04E RC00C90101 IN DSNITLPE : 501E WHEN INSERT RECORD INTO GLOBAL TEMPORARY TABLE AFTER A SELECT FROM INSERT STATEMENT USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries that insert records into a created Global Temporary Table after a select from insert statement. RECOMMENDATION: INSTALL UK47538 ON VOLID 0907 (HDB8810) 27 09/07/02 PROBLEM: (PK81706) INCORRECT OUTPUT IN A LOOP OF QUERIES AFTER SQLCODE 100 (SQLCODE100) USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of SQL statements that contain a non-correlated subquery on the predicate where the select list data of the subquery used in the predicate evaluation is not nullable. RECOMMENDATION: INSTALL UK47468 ON VOLID 0906 (HDB8810) 26 09/06/29 PROBLEM: (PK85499) INCORRECT OUTPUT NRF WITH SQL USING SCALAR UDF AND HOSTVARS. USERS AFFECTED: All DB2 R810 and R910 users of sql scalar user defined function and table expression or view. RECOMMENDATION: INSTALL UK47320 ON VOLID 0906 (HDB8810) 25 09/06/29 PROBLEM: (PK86537) ABEND0C7 DSNXVCDF+02E4 OCCURS FOR A COMPLEX INSERT STATEMENT WHEN RUN WITH PARALLELISM. USERS AFFECTED: All DB2 z/OS R810 and R910 parallelism users. RECOMMENDATION: INSTALL UK47392 ON VOLID 0906 (HDB8810) 24 09/06/25 PROBLEM: (PK85985) LOAD RESUME YES ON A COMPRESSED PARTITIONED OBJECT MAY CORRUPT A POPULATED PART, IF ANY PART BELO USERS AFFECTED: of CHECK DATA on a partitioned table space with 256 or more partitions RECOMMENDATION: INSTALL UK47286 ON VOLID 0906 (HDB8810) 23 09/06/24 PROBLEM: (PK85539) INSERT LOOP FOR NONSEGMENTED TABLESPACE WITH PK76544 APPLIED USERS AFFECTED: ALL DB2 for z/OS non-segmented table space users with PK76544/UK45207/UK45208 applied. RECOMMENDATION: INSTALL UK47270 ON VOLID 0906 (HDB8810) 22 09/06/22 PROBLEM: (PK80210) ABEND04E RC00E20017 AT DSNSTACK +034A USERS AFFECTED: All users of DB2 who have queries where a constant literal length is greater than 2000 characters RECOMMENDATION: INSTALL UK47178 ON VOLID 0906 (HDB8810) 21 09/06/17 PROBLEM: (PK85188) INCORRECT OUTPUT MAY OCCUR FOR SQLID OR USER SPECIAL REGISTER USERS AFFECTED: All DB2 INSERT with Special Register and SQLID users. RECOMMENDATION: INSTALL UK47033 ON VOLID 0906 (HDB8810) 20 09/06/15 PROBLEM: (PK85049) DSNIDBGC:5017 IN ALL MEMBERS EXCEPT ONE OF A DATA SHARING GROUP WHEN HANDLING A DBET NOTIFY EXIT. USERS AFFECTED: All DB2 data-sharing users. RECOMMENDATION: INSTALL UK46973 ON VOLID 0906 (HDB8810) 19 09/06/12 PROBLEM: (PK82886) PAUSE ELEMENTS SSD REMAIN ALLOCATED IN ESQA USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK46901 ON VOLID 0906 (HDB8810) 18 09/06/09 PROBLEM: (PK82254) INCORROUT (WRONG VALUE RETURNED) ON QUERY REFERENCING VIEW WITH UNION ALL AND DECIMAL COLUMN IN AGGREGATE FUNCTION USERS AFFECTED: All DB2 V8 and V9 users of queries referencing a view which contains aggregate function and UNION ALL or a view which contains a SUM function. RECOMMENDATION: INSTALL UK46842 ON VOLID 0906 (HDB8810) 17 09/06/03 PROBLEM: (PK85271) REORG ERROR ALLOCATING COPYDD GDG TO DATASET ON TAPE USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of DB2 Utilities who dynamically allocate GDG (generation data group) datasets to tape via Utility TEMPLATEs. RECOMMENDATION: INSTALL UK46662 ON VOLID 0906 (HDB8810) 16 09/06/01 PROBLEM: (PK81110) ABND=04E-00C200D8 DSNB5SCM+0568 USERS AFFECTED: DB2 data sharing users. RECOMMENDATION: INSTALL UK46623 ON VOLID 0905 (HDB8810) 15 09/06/01 PROBLEM: (PK83374) POOR INSERT PERFORMANCE AND RAPID GROWTH IN all types of PAGESETS USERS AFFECTED: DB2 data sharing users with PK58442 - V8 PTF UK42288 or V9 PTF UK42289 - applied. RECOMMENDATION: INSTALL UK46619 ON VOLID 0905 (HDB8810) 14 09/06/01 PROBLEM: (PK83952) INCORRECT OUTPUT FOR THE QUERY THAT CONTAINS LIKE PREDICATE AND REFERENCE A VIEW OR TABLE EXPRESSION WHICH HAS UNION USERS AFFECTED: All DB2 V9 and V8 users with UNION and LIKE predicate. RECOMMENDATION: INSTALL UK46611 ON VOLID 0905 (HDB8810) 13 09/05/29 PROBLEM: (PK82166) ABEND073-RC8 S073-8 OCCURRED IN DSNVXUL0 FROM PRIOR ABENDS SUCH AS ABENDA78-RC28 SA78-28 DURING RECOVERY USERS AFFECTED: All DB2 users. RECOMMENDATION: INSTALL UK46098 ON VOLID 0905 (HDB8810) 12 09/05/25 PROBLEM: (PK77382) INCORROUT WRONG ORDER WHEN QUERY USING GROUP BY ON A WORKFILE TABLE PRODUCED BY INSERT SELECT FROM USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users who use an INSERT query with a SUBSELECT that has a GROUP BY. RECOMMENDATION: INSTALL UK43892 ON VOLID 0902 (HDB8810) 11 09/05/25 PROBLEM: (PK78126) INCORROUT (WRONG VALUE RETURNED) WITH QUERY ON MQT USERS AFFECTED: All DB2 V8 and V9 users who use materialized query table. RECOMMENDATION: INSTALL UK45840 ON VOLID 0905 (HDB8810) 10 09/05/25 PROBLEM: (PK78877) BYTE 255-257 DISAPPEARS IN A LONG STRING CONSTANT IN THE DBRM EN TRY. USERS AFFECTED: Users of the DB2 coprocessor for DB2 UDB for z/OS and OS/390, and using a string constant longer than 255 bytes in an SQL statement. 810, 910 RECOMMENDATION: INSTALL UK43831 ON VOLID 0902 (HDB8810) 9 09/05/25 PROBLEM: (PK79220) FETCHING FROM CLOB USING SUBSTRING/CODEUNITS16 CAUSES DATA LOSS. USERS AFFECTED: All DB2 for z/OS v8 and DB2 9 for z/OS users of LOBs. RECOMMENDATION: INSTALL UK44391 ON VOLID 0903 (HDB8810) 8 09/05/25 PROBLEM: (PK81394) PRODUCTION CRASH WHEN USING LARGE SQL WITH DSNTIAUL. THE STORAGE BLOCK IS DETP ALLOCATED BY DSNXOGCM+9E61 AT UK35140 USERS AFFECTED: All DB2 for z/OS users using large non-boolean term predicates in their queries. RECOMMENDATION: INSTALL UK46347 ON VOLID 0905 (HDB8810) 7 09/05/25 PROBLEM: (PK81406) SQLCODE545 issued incorrectly when insert into table with check constraints USERS AFFECTED: All DB2 R810 and R910 users who use tables with check constraints. RECOMMENDATION: INSTALL UK46339 ON VOLID 0905 (HDB8810) 6 09/05/25 PROBLEM: (PK82169) INCORRECT VALUE FOR SEQUENCE OBJECT UNDER PARALLELISM USERS AFFECTED: All DB2 users who use parallelism and sequence objects RECOMMENDATION: INSTALL UK46342 ON VOLID 0905 (HDB8810) 5 09/05/25 PROBLEM: (PK82220) UNLOAD DOES NOT HONOR EXTERNAL DEC() SCALE WHEN SCALE IS 0 USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of UNLOAD with DECIMAL column(s) specifying a scale of 0 RECOMMENDATION: INSTALL UK46327 ON VOLID 0905 (HDB8810) 4 09/05/25 PROBLEM: (PK83419) LOAD MIEXED DATA CONVERSION PROBLEM FOREIGNKEY USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS utility users of LOAD RECOMMENDATION: INSTALL UK46329 ON VOLID 0905 (HDB8810) 3 09/05/22 PROBLEM: (PK81413) INCORROUT MAY OCCUR FOR A QUERY WITH AN INSENSITIVE SCROLLABLE CURSOR ON A TABLE WITH A FIELDPROC DEFINED. USERS AFFECTED: ALL DB2 R810 AND R910 USERS USING INSENSITIVE SCROLLABLE CURSOR AND FIELDPROC QUERY. RECOMMENDATION: INSTALL UK46312 ON VOLID 0905 (HDB8810) 2 09/05/22 PROBLEM: (PK83492) ABEND04E RC00E20005 DSNXEFB DSNSVBK 09B8 WHEN SELECT WITH FUNCTION VARIANCE ( DISTINCT ) USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users of queries that contain the VARIANCE or STDDEV function. RECOMMENDATION: INSTALL UK46333 ON VOLID 0905 (HDB8810) 1 09/05/21 PROBLEM: (PK80001) DBET NOTIFIED MEMBERS WERE BROUGHT DOWN WHEN GRECP NOTIFY MESSAGE WAS NOT PROCESSED CORRECTLY USERS AFFECTED: All DB2 users who experience LPL or GRECP conditions RECOMMENDATION: INSTALL UK46293 ON VOLID 0905 (HDB8810)


Cross Product Dependencies

This section contains information that is dependent upon another product other than this subset ID. It also contains information dealing with migration and product coexistance. 1. YY/MM/DD INTERDEPENDENT PRODUCT: PROBLEM: USERS AFFECTED: RECOMMENDATION: INSTALL XXXXXXX ON VOLID XXXX


Informational / Documentation


PTF / APAR Reference Lists

PTF Include List
UK69719 UK69826 UK69882 UK70046 UK70085 UK70133
PTF Exclude List
PE APAR List
PM18194 PM21683 PM23043


End of Upgrade DB2810 , Subset HDB88100601B , as of 2012/05/30.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

z/OS family

Modified date:

2011-08-10

Translate my page

Machine Translation

Content navigation