This readme file lists DFSORT/ICETOOL examples and packages you can download via FTP. You can find additional information about DFSORT and ICETOOL on the DFSORT/MVS home page at URL: http://www.ibm.com/storage/dfsort * sortugph - User Guide for DFSORT PTFs UK90025 and UK90026 by Frank Yaeger PDF file. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ z/OS DFSORT V1R10 PTF UK90025 and z/OS DFSORT V1R12 PTF UK90026, first available in October, 2009, provide important enhancements to DFSORT and DFSORT's ICETOOL for resizing records (RESIZE operator); updating the trailer record (IFTRAIL); processing subsets (ACCEPT); translation of ASCII to EBCDIC (TRAN=ATOE), EBCDIC to ASCII (TRAN=ETOA), EBCDIC hex to binary (TRAN=UNHEX), and more; date field arithmetic (ADDDAYS, ADDMONS, ADDYEARS, SUBDAYS, SUBMONS, SUBYEARS, DATEDIFF, NEXTDday, PREVDday, LASTDAYW, LASTDAYM, LASTDAYQ and LASTDAYY); timestamp constant with microseconds (DATE5); group functions (KEYBEGIN); use of SET and PROC symbols in control statements (JPn"string" in EXEC PARM); more information in reports; larger fields; easier migration from other sort products, and more. SORTUGPH is the documentation for PTFs UK90025 and UK90026. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. Note: This paper provides the documentation you need to start using the features and messages associated with z/OS DFSORT V1R10 PTF UK90025 and z/OS DFSORT V1R12 PTF UK90026. The information in this paper will be included in the latest z/OS DFSORT book at its next major update. * sortugpg - User Guide for DFSORT PTFs UK51706 and UK51707 by Frank Yaeger PDF file. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ z/OS DFSORT V1R5 PTF UK51706 and z/OS DFSORT V1R10 PTF UK51707, first available in November, 2009, provide important enhancements to DFSORT and DFSORT's ICETOOL for various types of two file join applications (JOINKEYS, JOIN, REFORMAT, JKFROM); date field conversions (Y2x, Y4x, TOJUL, TOGREG, WEEKDAY, DT, DTNS); merge operations (MERGE operator); alternate ddnames for MERGE (MERGEIN); easier migration from other sort products, and more. SORTUGPG is the documentation for PTFs UK51706 and UK51707. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. * sortnew - What's New in DFSORT by Frank Yaeger PDF file FTP from ftp.software.ibm.com/storage/dfsort/mvs/ Over the years, DFSORT has provided important enhancements in many areas. SORTNEW provides a quick introduction to selected DFSORT and ICETOOL enhancements available as of October, 2010. Examples using the various features are included, where appropriate. * sortbynd - Beyond Sorting by Frank Yaeger PDF file FTP from ftp.software.ibm.com/storage/dfsort/mvs/ SORTBYND highlights and shows examples of some of the features of DFSORT that can improve application performance and programmer productivity. Topics included are: JOINKEYS, ICEGENER, multiple output, ICETOOL, INCLUDE/OMIT tests, reformatting features, OUTFIL features, SMF, TOD and ETOD date and time formats, floating sign format, free form formats, product connections, Symbols, National Language Support, Time-of-day controls, continue or terminate controls, SAS booster, BLDINDEX, Year 2000 features, and sources of information. SORTBYND reflects DFSORT features available as of October, 2010. * sorttool - ICETOOL Mini-User Guide by Frank Yaeger PDF file FTP from ftp.software.ibm.com/storage/dfsort/mvs/ SORTTOOL is a mini-user guide for DFSORT's versatile ICETOOL data processing and reporting utility. The major features of ICETOOL, including its JCL and control statements, are discussed at length using many examples. The objective is to show you how to use ICETOOL to accomplish complex tasks. * racfice2 - Security Analysis using RACF Unload Utilities and DFSORT's ICETOOL by Mark Nelson Postscript and text files. Directions for FTP are on the RACFICE2 home page at URL: www.ibm.com/systems/z/os/zos/features/racf/downloads/racfice.html Effective security management requires flexible analysis and reporting tools. With OS/390 Version 2 Release 8, RACF introduced the RACFICE reports in 'SYS1.SAMPLIB(IRRICE)'. RACFICE used DFSORT's ICETOOL to create a set of 30+ reports based on the output of the RACF Database Unload Utility (IRRDBU00) and the RACF SMF Unload Utility (IRRADU00). Since then, there have been several major enhancements to DFSORT. This package, RACFICE2, demonstrates how those enhancements can be used to do even more with the output of IRRDBU00 and IRRADU00. In addition, the package contains a set of DFSORT Symbols that define the IRRDBU00 and IRRADU00 fields as documented in the "RACF Macros and Interfaces (SA22-7682)". * sortugpf - User Guide for DFSORT PTF UK90013 by Frank Yaeger PDF file. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ z/OS DFSORT V1R5 PTF UK90013, first available in July, 2008, provides important enhancements to DFSORT and DFSORT's ICETOOL for ICETOOL for find and replace (FINDREP), group operations (WHEN=GROUP); sorting data between headers and trailers (DATASORT); keeping or removing the first n records, last n records and/or specific relative records (SUBSET); selecting the first n duplicate records (SELECT with FIRST(n) and FIRSTDUP(n)); splicing with non-blank fields (SPLICE with WITHANY); displaying and writing counts (DISPLAY with COUNT, EDCOUNT, BCOUNT and EDBCOUNT, and COUNT with ADD, SUB, WRITE, TEXT, DIGITS, EDCOUNT and WIDTH); reports with multiple and multipart titles (DISPLAY and OCCUR with TITLE, TLEFT and TFIRST); reports without carriage control characters (DISPLAY and OCCUR with NOCC); additional defaults (BLKSIZE for DUMMY, SKIP=0L for SECTIONS, and SORTOUT=ddname for FNAMES); easier migration from other sort products, and more. SORTUGPF is the documentation for PTF UK90013. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. * sortpeug - User Guide for DFSORT PTFs UK90007 and UK90006 by Frank Yaeger PDF file. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ z/OS DFSORT V1R5 PTF UK90007 and DFSORT Release 14 PTF UK90006, first available in April, 2006, provide important enhancements to DFSORT and DFSORT's ICETOOL for extracting variable position/length fields (e.g. CSV, delimited fields, keyword separated fields, etc) into fixed parsed fields (PARSE, %nn); justifying and squeezing data (JFY, SQZ); comparing and inserting past and future date constants (DATEn-r, DATEn+r); testing for numerics and non-numerics (NUM); displaying hexadecimal floating-point values as integers (FL); splitting files contiguously (SPLIT1R); suppressing page ejects in reports (BLKCCH1, BLKCCH2, BLKCCT1); using symbols for output columns (sym:); using system symbols (e.g. &SYSPLEX) in symbol constants (S'string'); reformatting records before selecting or splicing (INREC, SELECT, SPLICE); sorting and merging with larger PD and ZD fields; easier migration from other sort products, and more. SORTPEUG is the documentation for PTFs UK90007 and UK90006. It highlights, describes and shows examples of the new features provided by these PTFs for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with these PTFs. * sortpdug - User Guide for DFSORT PTFs UQ95214 and UQ95213 by Frank Yaeger PDF, postscript and text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ z/OS DFSORT V1R5 PTF UQ95214 and DFSORT Release 14 PTF UQ95213, first available in December, 2004, provide important enhancements to DFSORT and DFSORT's ICETOOL for conditionally reformatting records; overlaying only selected parts of records; larger numeric fields and constants; new data formats for extracting digits, and displaying TOD and ETOD date and time values; restarting sequence numbers; join and match operations; date and time constants; conversion of statistical and count values; reports; easier migration from other sort products, and more. SORTPDUG is the documentation for PTFs UQ95214 and UQ95213. It highlights, describes and shows examples of the new features provided by these PTFs for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with these PTFs. * sortpaug - DFSORT PTF UQ90053 User Guide by Frank Yaeger PDF, postscript and text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ DFSORT Release 14 PTF UQ90053, first available in February, 2003 and incorporated into z/OS DFSORT V1R5, provides important enhancements for join and match operations, sampling, repeating and distributing records, arithmetic operations using numeric fields and decimal constants, longer fields for substring searches, easier migration from other sort products, and more. SORTPAUG is the documentation for PTF UQ90053. It highlights, describes and shows examples of the new features provided by PTF UQ90053 for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details changed messages associated with this PTF. * sort2000 - DFSORT's Year 2000 Features (The New Generation) by Frank Yaeger PDF, postscript and text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ DFSORT has Year 2000 features you can use to sort, merge, compare and transform a wide variety of dates with two-digit years according to a specified sliding or fixed century window. DFSORT's new generation of Year 2000 features handles "full dates" like yyq, yymm, yyddd, yymmdd, qyy, mmyy, dddyy and mmddyy and their special indicators like zeros and nines. SORT2000 contains a detailed discussion of DFSORT's Year 2000 features and examples of the control statements needed to order, compare and transform all kinds of character, zoned decimal and packed decimal date fields. * icestgex - Examples of DFSORT/ICETOOL Jobs for Storage Administrators Text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ DFSORT's ICETOOL is a versatile data set processing and reporting utility that provides an easy-to-use batch front-end for DFSORT. ICETOOL combines new features with previously available DFSORT features to perform complex sorting, copying, reporting and analytical tasks using multiple data sets in a single job step. ICETOOL is particularly useful for Storage Administrators. icestgex contains the following illustrative DFSORT/ICETOOL examples of interest to Storage Administrators and others who analyze data created by DFHSM, DFSMSrmm, DCOLLECT and SMF: * DCOLEX1.JCL - DCOLLECT Example 1: VSAM report * DCOLEX2.JCL - DCOLLECT Example 2: Conversion reports * DCOLEX3.JCL - DCOLLECT Example 3: Capacity planning analysis and reports * DFHSMEX1.JCL - DFHSM Example 1: Deciphering Activity Logs * DFHSMEX2.JCL - DFHSM Example 2: Recover a DFHSM CDS with a broken index * RMMEX1.JCL - DFSMSrmm Example 1: SMF audit report * RMMEX2.JCL - DFSMSrmm Example 2: Create ADDVOLUME commands * shr3054 - DFSMS Tools to Help Establish and Manage your Storage Configuration by Douglas Dunham Text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ SHARE 86 presentation 3054 includes the following examples of using DFSORT's ICETOOL to create reports from DCOLLECT data: * SHAR861 - Example using ICETOOL to extract SMS statistics for volumes, and produce a summary report * SHAR862 - Example to show allocated space, used space, and unblockable space by data set by DSORG. * hbexits - Exits for accessing Hiperbatch files using QSAM. Text files. FTP from ftp.software.ibm.com/storage/dfsort/mvs/ * HBE15 - DFSORT E15 for reading HiperBatch data with QSAM. Sort and Copy examples are included. * HBE35 - DFSORT E35 for writing HiperBatch data with QSAM. Sort, Merge and Copy examples are included. * HBE32PGM - DFSORT Program with E32 for Merging Hiperbatch data with QSAM. Merge examples are included.