IBM Support

Recommendations for Tuning Large DFSORT Tasks

Product Documentation


Abstract

Sets out a series of recommendations for dealing specifically with high data volume DFSORT tasks.

Content

by Trevor Kingsbury

Most installations have experienced explosive growth in recent years in the volume of data to be stored and processed; both in operational applications and in decision-support and data warehousing.

While RDBMS on either MVS or Unix remains the permanent data storage platform of choice, much of this data must be extracted, processed, transformed and loaded using traditional MVS batch processing. Sorting and merging of data, using DFSORT under MVS, endures as a key component of this batch processing.

In addition, utility processing in DB2/OS390 has always made extensive use of DFSORT. The introduction of LARGE tablespaces in version 5 has produced a new class of potential DFSORT challenges in this area.

The SRTMLTUN paper attempts to set out a series of recommendations for dealing specifically with high data volume DFSORT tasks.

PDF

View a PDF version of this paper. (99KB)

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

Document Information

Modified date:
03 September 2021

UID

isg3T7000092