Articles & Content

Archives

All You Ever Wanted To Know About DB2 and DFSORT - B10

Topic: DB2 for z/OS

Subtopic: 2012



The DB2 Utilities Suite is designed to work with the DFSORT program. As a DB2 DBA on z/OS it is important to understand how most DB2 utilities use DFSORT to sort either the table space or index data and how to react in case of problems. In this presentation we will focus on recent enhancements concerning DB2 and DFSORT. We will try to give recommendations to get the best sorting performance and how to avoid sort failures. We will explain how sort workload can be directed to a zIIP processor when available. We will show how to debug DFSORT problems and share some practical experiences with the new SORTNUM elimination feature.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.