DFSORT ICETOOL Papers and Examples

Product documentation


Abstract

Papers (DFSORT, ICETOOL, RACF)
Examples (DFHSM, DFSMSrmm, DCOLLECT, SMF)

Content

Topic list
Papers (DFSORT, ICETOOL, RACF)
Examples (DFHSM, DFSMSrmm, DCOLLECT, SMF)
 
 Papers (DFSORT, ICETOOL, RACF)

The following papers can help programmers be more productive with DFSORT/ICETOOL. These papers can be obtained electronically as indicated below.

  • SORTUGPG - User Guide for DFSORT PTFs UK51706 and UK51707 by Frank Yaeger
  • 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 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.

    Note:This paper provides the documentation you need to start using the features and messages associated with z/OS DFSORT V1R5 PTF UK51706 and z/OS DFSORT V1R10 PTF UK51707. The information in this paper will be included in the latest z/OS DFSORT book at its next major update.

    PDF View a PDF version of SORTUGPG (137KB)
     
  • SORTUGPF - User Guide for DFSORT PTF UK90013 by Frank Yaeger
  • 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.

    PDF View a PDF version of SORTUGPF (153KB)
     
  • SORTPEUG - User Guide for DFSORT PTFs UK90007 and UK90006 by Frank Yaeger
  • 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; justifying and squeezing data; comparing and inserting past and future date constants; testing for numerics and non-numerics; displaying hexadecimal floating-point values as integers; splitting files contiguously; suppressing page ejects in reports; using symbols for output columns; using system symbols (e.g. &SYSPLEX) in symbol constants; reformatting records before selecting or splicing; 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.

    PDF View a PDF version of SORTPEUG (209KB)
     
  • SORTPDUG - User Guide for DFSORT PTFs UQ95214 and UQ95213 by Frank Yaeger
  • 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.

    PDF View a PDF version of SORTPDUG (154KB)
     
  • SORTNEW - What's New in DFSORT by Frank Yaeger
  • 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 July, 2008. Examples using the various features are included, where appropriate.
    PDF View a PDF version of SORTNEW  (95KB)
     
  • SORTBYND - Beyond Sorting by Frank Yaeger
  • SORTBYND highlights and shows examples of some of the features of DFSORT that can improve application performance and programmer productivity. Topics included are: 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 July, 2008.
    PDF View a PDF version of SORTBYND  (90KB)
     
  • SORTTOOL - ICETOOL Mini-User Guide by Frank Yaeger
  • 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.
    PDF View a PDF version of SORTTOOL  (134KB)
     
  • RACFICE2 - Security Analysis using RACF Unload Utilities and DFSORT'S ICETOOL by Mark Nelson

    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 RACFICE2 package contains a set of DFSORT Symbols that define the IRRDBU00 and IRRADU00 fields as documented in the "RACF Macros and Interfaces (SA22-7682)".

    The RACFICE2 home page has instructions for downloading RACFICE2.

  • SORTPAUG - DFSORT PTF UQ90053 User Guide by Frank Yaeger
  • DFSORT Release 14 PTF UQ90053, first available in February, 2003 and incorporated into z/OS DFSORT V1R5, provides important enhancements to DFSORT and DFSORT's ICETOOL 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.

    PDF View a PDF version of SORTPAUG (150KB)
     
  • SORT2000 - DFSORT's Year 2000 Features (The New Generation) by Frank Yaeger

  • 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.

    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..

    PDF View a PDF version of SORT2000 (106KB)
     

Back to top  Back to top

 Examples (DFHSM, DFSMSrmm, DCOLLECT, SMF)
  • ICESTGEX - Storage Administrator Examples

    The DFSORT product tape contains a set of illustrative DFSORT/ICETOOL examples of interest to Storage Administrators and others who analyze data created by DFHSM, DFSMSrmm, DCOLLECT and SMF. The source for the following examples are available in sample job ICESTGEX:

  • DCOLEX1 - DCOLLECT Example 1: VSAM report.
  • DCOLEX2 - DCOLLECT Example 2: Conversion reports.
  • DCOLEX3 - DCOLLECT Example 3: Capacity planning analysis and reports.
  • DFHSMEX1 - DFHSM Example 1: Deciphering Activity Logs.
  • DFHSMEX2 - DFHSM Example 2: Recover a DFHSM CDS with a broken index.
  • RMMEX1 - DFSMSrmm Example 1: SMF audit report.
  • RMMEX2 - DFSMSrmm Example 2: Create ADDVOLUME commands.
  •  
    Download a ZIP file containing the ICESTGEX Examples
The ICESTGEX examples can also be obtained from the DFSORT R14 product tape.
  • SHR3054 - DFSMS Tools to Help Establish and Manage your Storage Configuration by Douglas Dunham

    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.
  •  
    Download a ZIP file containing the SHR3054 Examples.

Back to top  Back to top


Rate this page:

(0 users)Average rating

Document information


More support for:

z/OS family

Software version:

Not Applicable

Operating system(s):

z/OS

Reference #:

T7000097

Modified date:

2010-05-10

Translate my page

Machine Translation

Content navigation