IBM Support

DFSORT

Product Documentation


Abstract

Product highlights

Content

DFSORT is IBM's high-performance sort, merge, copy, analysis, and reporting product. DFSORT is an optional feature of z/OS.



Learn More

DFSORT adds the ability to do faster and easier sorting, merging, copying, reporting, and analysis of your business information, as well as versatile data handling at the record, fixed position/length or variable position/length field, and bit level. Sort, merge, or copy data sets while including, excluding, or reformatting records. Collate and compare data according to your national and cultural needs by using DFSORT's National Language Support. Add timestamps to records, perform date field conversions and arithmetic, include or omit records based on today's date, a past date or a future date, and convert SMF, TOD, and ETOD date and time values to readable form. Join and match records from different data sets in various ways.

DFSORT includes the high-performance ICEGENER facility, the versatile ICETOOL utility, Symbols, and multiple output capabilities with the powerful OUTFIL feature. Analyze data and produce detailed reports by using the ICETOOL utility or the OUTFIL function. In addition, OUTFIL allows you to create different views of the data and different reports with a single pass over the data. Use symbols for fields and constants in DFSORT and ICETOOL statements.

DFSORT is designed to optimize the efficiency and speed with which operations are completed through synergy with processor, device, and system features (for example, memory objects, Hiperspace, data space, striping, compression, extended addressing, DASD and tape device architecture, processor memory, processor cache, and so on) and other products (for example, The SAS System, COBOL, PL/I, IDCAMS BLDINDEX, and so on).

DFSORT together with DFSMS and RACF, form the strategic product base for the evolving system-managed storage environment.

Product Highlights

z/OS DFSORT 3.1 (September 2023)

DFSORT 3.1


DFSORT Symbol definitions for SMF Type 16 records and generate reports on DFSORT Use of Z Sort Accelerator.

z/OS DFSORT V2R5 (September 2021)

Added support for IBM Integrated Accelerator for Z Sort to provide CPU and Elapsed time improvements without the need for application changes to DFSORT.
PTFs UI90067 and UI90068 (September 2020)


Enable DFSORT to leverage new on chip sort accelerator known as the IBM Integrated Accelerator for Z Sort to provide CPU and Elapsed time improvements without the need for application changes.

z/OS DFSORT V2R4 (September 2019)

Added support for filtering records using regular expressions, filtering of Unicode data and other new features to DFSORT.
PTFs UI58435 and UI58461 (November 2018)


Enable DFSORT to create channel programs that leverage z Systems High-Performance FICON (zHPF) with SORTWORK data sets to provide I/O performance improvements without the need for application changes.

z/OS DFSORT V2R3 (September 2017)

Added support for Sort/Merge of Unicode Transformation Format (UTF8/UTF16/UTF32) data and other new features to DFSORT.
PTFs UI40659 and UI40658 (September 2016)


Added new performance improvements to z/OS DFSORT V2R1 and z/OS DFSORT V2R2, for several DFSORT functions that generate code at run time.


Added new features to z/OS DFSORT V2R1 and z/OS DFSORT V2R2, for supporting the transfer of blocks of records between DFSORT and user E15/E35 exits.
z/OS DFSORT V2R2 (September 2015)


Added support for high-performance FICON (zHPF), when available, for SORTIN, SORTOUT, and OUTFIL data sets, diagnostics, and first failure data capture and other new features to DFSORT.

z/OS DFSORT V2R1 (September 2013)

Added improvements to better balance the memory requirements of multiple large concurrent sort operations and other workloads, increasing the memory object workspace maximum from 64 GB to 1 TB, changes for DFSORT installation options and other new features to DFSORT.


Added new features to z/OS DFSORT V1R10 and z/OS DFSORT V1R12, including RESIZE, IFTRAIL, ACCEPT, TRAN=ATOE, TRAN=ETOA, TRAN=UNHEX, ADDDAYS, SUBDAYS, ADDMONS, SUBMONS, ADDYEARS, SUBYEARS, DATEDIFF, DATE5, KEYBEGIN, JPn"string", and more.

z/OS DFSORT V1R12 (September 2010)

Added improvements for performance, dynamic allocation, diagnostics, and first failure data capture, as well as other new features, to DFSORT.


Added new features to z/OS DFSORT V1R5 and z/OS DFSORT V1R10, including JOINKEYS, JOIN, REFORMAT, JKFROM, Y4x, TOJUL, TOGREG, WEEKDAY, DT, DTNS, MERGE operator, MERGEIN, and more.

z/OS DFSORT V1R10 (September 2008)

Added parmlib changes for DFSORT installation options and other new features to DFSORT.
PTF UK90013 (July 2008)


Added new features to z/OS DFSORT V1R5, including FINDREP, WHEN=GROUP, DATASORT, SUBSET, FIRST(n), FIRSTDUP(n), WITHANY, BCOUNT, WRITE, TEXT, NOCC, and more.


Added new features to z/OS DFSORT V1R5 and DFSORT Release 14, including PARSE, %nn, JFY, SQZ, DATEn-r, DATEn+r, NUM, SPLIT1R, BLKCCH1, BLKCCH2, BLKCCT1, sym:, S'string', and more.
PTFs UQ95214 and UQ95213 (December 2004)

Added new features to z/OS DFSORT V1R5 and DFSORT Release 14, including IFTHEN, OVERLAY, SFF, UFF, RESTART, COUNT+n, COUNT-n, KEEPBASE, VLENMAX, VLENOVLY, and more.

Publication Number

T7000077

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG90","label":"z\/OS"},"Component":"5740SM105 - DATA FACILITY SORT (DFSORT)","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB56","label":"Z HW"}}]

Document Information

Modified date:
08 December 2023

UID

isg3T7000077