Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 1 May 2024
DB2 Sort for z/OS V2.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH60198
14_Mar
2024
UI96089


SET DEFAULT VALUES IN TCZ FOR SWCRYPT=NO
PH59091
12_Mar
2024
UI96048


CORRECTIONS TO THE JCLIN SUPPLIED IN DB2 SORT PTF UI73712. 24/01/09 PTF
PECHANGE
PH59090
12_Feb
2024
UI95640


INCLUDE THE SORTL PARMLIST IN THE DEBUG OUTPUT FOR IMPROVED DIAGNOSTICS.
PH58533
5_Feb
2024
UI95565


ABEND 8ED IN DB2 SORT WHILE ATTEMPTING TO PERFORM ENCRYPTION OF SORTWK DATA SETS.
PH58021
6_Dec
2023
UI94691


ABOVE THE LINE STORAGE PROBLEMS WHEN MORE THAN 10 SORTS ARE INVOKED CONCURRENTLY.
PH57796
30_Nov
2023
UI94655


ABEND S0C4 IN DB2SORT WHILE TRYING TO OBTAIN THE AVAILABLE STORAGE INFORMATION FROM LDA
PH55226
27_Sep
2023
UI93780


LIMIT MEMORY OBJECT USAGE TO MEMLIMIT
PH55686
24_Aug
2023
UI93301


CORRECT CNK526E DB2 SORT FOR Z/OS INTERNAL ABEND - 27 CAUSED BY OMISSION OF CNKOPTNS
PH54463
5_Jun
2023
UI92108


ABEND S0C4 IN DB2SORT CASES WITH SORTL=YES AND INACCURATE FILE SIZE ESTIMATES.
PH53083
20_Apr
2023
UI91520


DB2 SORT FOR Z/OS INTERNAL ABEND - 27 MAY OCCUR WHEN REGION IS FRAGMENTED
PH53214
3_Apr
2023
UI91245


UNABLE TO SET CERTAIN INSTALLATION OPTIONS VIA TCZ AFTER APPLYING PH51315
PH51315
25_Jan
2023
UI90275
PH55686

INTRODUCING AN INSTALLATION PARM TO TURN OFF CACHE FAST WRITE FOR SORT WORK DATASETS
PH51213
21_Dec
2022
UI83840
UI90275


THE ALGORITHM TO EXPLOIT IBM'S ZSORT ACCELERATOR MAY NOT BEING UTILIZED WHEN THE DD STATEMENT DB2SORTI IS MISSING.
PH49126
27_Oct
2022
UI83040
UI90275


AN ERROR MAY OCCUR FOR A VARIABLE LENGTH DB2 SORT WHEN THE NUMBER OF RECORDS PROCESSED BY SORT IS LESS THAN 4 GB
PH46734
28_Jul
2022
UI81698


INDICATE THE REASON DB2 SORT HAS NOT USED THE IBM INTEGRATED ACCELERATOR FOR Z SORT.
PH46733
9_Jun
2022
UI80957


THIS FIX RESOLVES A LOOP ENCOUNTERED AFTER A PRIMARY ABEND RESULTING FROM AN UNUSUAL SET OF CIRCUMSTANCES.
PH44720
20_Apr
2022
UI80219


THIS FIX RESOLVES AN 0C4 ABEND (S0C4) THAT MAY BE OBSERVED WHEN INACCURATE INFORMATION IS PROVIDED AS INPUT TO DB2SORT.
PH45410
19_Apr
2022
UI80213


THIS FIX WILL PROVIDE SUPPORT FOR V13 TCZ VNEXT
PH42837
14_Jan
2022
UI78924
UI91520

HIPER

0C4 ABEND THAT IS SOMETIMES OBSERVED IN THE DB2SORT ALGORITHM EXPLOITING THE SORT ACCELERATOR TECHNOLOGY
PH42177
15_Dec
2021
UI78579


INTERNAL SERVICEABILITY CHANGE
PH41828
2_Dec
2021
UI78371


ABEND S0C4 IN DB2SORT WHEN INVOKED WITH HPU
PH36046
7_Jun
2021
UI75740
UI81698


DB2SORT INTERNAL ABEND - 04E S REASON=00E40347 OBSERVED IN REORGJOB DUE TO LIMITED STORAGE IN OPTIMIZING MULTIPLE SORTS.
PH36048
17_May
2021
UI75433


DB2SORT INTERNAL ABEND - 27 WHICH IS BEING OBSERVED WHEN THERE ARE ZERO RECORDS/ROWS IN A PARTITION IN A DB2 REORG JOB.
PH35059
22_Apr
2021
UI75057


ACCEPT AND IGNORE THE PARMS ZSORT AND NOZSORT
PH32512
2_Mar
2021
UI74223


THIS FIX WILL RESOLVE A DB2SORT INTERNAL ABEND-90 THAT MAY BE OBSERVED WHEN TOO MANY SORTS ARE RUNNING IN PARALLEL
PH33044
15_Feb
2021
UI73979


RESOLVE AN 0C9 THAT MAY BE OBSERVED FOR SORT RUNNING WITH LARGE FILE SIZE AND A SMALL SORTWORK FILE SIZE.
PH32409
9_Feb
2021
UI73873


THIS FIX CORRECTS AN INTERNAL ABEND307W FOR A SORT WITH MORE THAN 2 TERABYTES OF INPUT DATA.
PH32374
29_Jan
2021
UI73712
PH59091

AN ENHANCEMENT TO EXPLOIT THE SORT ACCELERATOR TECHNOLOGY INTRODUCED WITH Z15
PH32364
15_Jan
2021
UI73497


THIS FIX WILL RESOLVE THE DB2SORT INTERNAL ABEND 27 THAT MAY BE OBSERVED IN CERTAIN SCENARIOS
PH28031
4_Jan
2021
UI73330
UI73712


BELOW THE LINE STORAGE ADJUSTMENT FOR DB2 UTILITY APPLICATION
PH29904
23_Dec
2020
UI73282


ADDRESS ABEND 0C9 FROM DB2 SORT IN A REORG OPERATION
PH29137
16_Dec
2020
UI73188


ABEND 481 DUE TO STORAGE FRAGMENTATION
PH29567
16_Dec
2020
UI73189


DB2 UTILITY APPLICATION REPORTED INCORRECT ZIIP USAGE STATISTICSFOR OPTMODE=ELAP
PH27488
14_Aug
2020
UI71080


DB2 UTILITY APPLICATION REPORTED INCORRECT ZIIP USAGE STATISTICS.
PH24231
10_Jun
2020
UI69971


EXCESSIVE PAGES OF MEMORY OBJECTS ARE USED FOR DB2 UTILITY APPLICATIONS PROCESSING A LARGE VOLUME OF DATA
PH23857
22_Apr
2020
UI69151


DB2 UTILITY INVOKED COPY APPLICATION MAY HIT "CNK526E DB2 SORT FOR Z/OS INTERNAL ABEND - 27" AFTER APAR 20/04/24 PTF
PECHANGE
PH21649
13_Mar
2020
UI68405
UI73979


DEGRADED CPU AND ELAPSED TIME IN REORG APPLICATIONS FOR EXTREMELY LARGE TABLES.
PH18918
3_Feb
2020
UI67697
UI69151


DB2SORT IS DOING GETMAIN CONCURRENTLY WITH OTHER TASKS AND RESULTED IN ABEND 878
PH17147
14_Jan
2020
UI67389
PH23857

SORTWORK ENCRYPTION AND IMPROVE PARALLELISM
PH18090
7_Jan
2020
UI67287


ABEND 301S CAN OCCUR IN DB2 LOAD, REORG OR REBUILD INDEX UTILITYAPPLICATIONS, WHEN INTERNAL DATASETS RNXX AND SWXX ARE
CREATED
PH15119
6_Sep
2019
UI65189


JOB WITH A SMALL FILE SIZE, VARIABLE LENGTH AND BLOCK LEVEL INTERFACE GOES INTO LOOP
PH10491
23_Apr
2019
UI62619


DB2SORT IS DOING GETMAIN CONCURRENTLY WITH OTHER TASKS AND RESULTED IN ABEND 878.
PH07356
1_Feb
2019
UI61083


PARMLIST USED BY BLDL IS NOT LONG ENOUGH
PH00800
22_Aug
2018
UI58029


WER039A INSUFFICIENT VIRTUAL STORAGE CNK526E DB2 SORT INTERNAL ABEND
PI94467
12_Mar
2018
UI54392


0C4 IN EXIT15
PI94211
6_Mar
2018
UI54290


ABENDS0C9 IN DB2 SORT.
PI89110
9_Nov
2017
UI51779


DB2SORT / FORCED OPTMODE=CPU AND REBUILD NPI RESULT IN SINGLE SORT
PI88397
10_Oct
2017
UI50995


MESSAGE CNK998E UNSUCCESSFUL SORT ABENDS0C1
PI85811
17_Aug
2017
UI49657


CNK998E UNSUCCESSFUL SORT 8ED U U2285 UNSUCCESSFUL SORT 04E S REASON=00E40347
PI80059
29_Jun
2017
UI48439


CNK526E DB2 SORT FOR Z/OS INTERNAL ABEND - 90
PI75855
14_Feb
2017
UI44690


REORG TABLESPACE FAILS WITH 0C4-00000004 IN DATA SORT AT QKD3INIT+ 2936
PI75398
14_Feb
2017
UI44691


MESSAGE CNK061E I/O ERROR OUT OF EXTENT EXCP EAV
PI75326
7_Feb
2017
UI44480


ABEND0C4-00000011 IN CSVS2RTN+03A8
PI75385
2_Feb
2017
UI44405


INTERMITTENT 878-10 ABENDS ON DB2 UTILITIES OR DB2 TOOLS RUNNINGWITH DB2SORT
PI71916
21_Dec
2016
UI43516


POTENTIAL DEGRADED ELAPSED TIME PERFORMANCE
PI65906
15_Dec
2016
UI43392


REDUCE CPU TIME & ELAPSED TIME AND OFFLOAD MORE WORK TO ZIIP IN VARIABLE-LENGTH RECORD SORTS
PI69626
7_Oct
2016
UI41506
UI80213


DB2 12 SUPPORT
PI57245
13_Apr
2016
UI37025


OPTMODE OVERRIDE SPECIFIED IN DB2SORTI NOT HONORED
PI48165
2_Nov
2015
UI32593


PROVIDE ADDITIONAL SORT EXECUTION STATISTICS TO DB2
PI43423
2_Jul
2015
UI29087


CNK526E DB2 SORT FOR Z/OS INTERNAL ABEND - 90
PI40480
14_May
2015
UI27643


ABENDS878 CAN OCCUR IN A UTILITY JOB WITH MANY PARALLEL SUBTASKS
PI37956
22_Apr
2015
UI26963


PROVIDE ABILITY TO TURN OFF SNAP DUMPS IN DB2 SORT
PI38385
21_Apr
2015
UI26917


ABENDS0C4 PIC4 WHEN DB2 SORT IS INVOKED BY HPU
PI36601
1_Apr
2015
UI26463


JOB HANG MAY BE CAUSED BY A SORT KEY OF A CERTAIN LENGTH WITH FIXED LENGTH RECORD INPUT CNK998E AND UNSUCCESSFUL SORT 13E S
PI35222
19_Mar
2015
UI26141


NEW INSTALLATION PARAMETER PAGEMONL
PI35024
26_Feb
2015
UI25500


ABEND S0C4, MEMORY OVERLAY

Top of page