{"id":65,"category_id":1,"slug":"vsam-adminaid","type":null,"name":"VSAM AdminAid","code":"VAA","content":"

MacKinney Systems' VSAM AdminAid<\/strong> (VAA) aids VSAM administrators in monitoring, tuning, and reorganizing production VSAM files. This helps reduce online response times, batch window, CPU cycles, DASD space usage, and VSAM administration time. The four main VAA components are:<\/p>\r\n

1. <\/strong> Catalog List and Extraction<\/strong><\/span>
\r\nVSAM AdminAid batch jobs process selected production catalogs and report on VSAM datasets, VSAM volumes, and non-VSAM datasets. Tuning messages, warning messages, and important statistics can print for VSAM files. Vital information can be saved in the VSAM AdminAid VSAM History file, and the VSAM AdminAid Adhoc Report Writer extract file, then available for use by other VSAM AdminAid batch and online applications. The current and historical production file data allows you and VAA to monitor current VSAM file reorganization and tuning needs and see VSAM file changes over time, growth trends, reorganization history, etc. Click here to see excerpts of a VSAM AdminAid Catalog List report.  <\/a><\/p>\r\n

2.<\/strong> <\/strong><\/strong> Online System<\/strong><\/span>
\r\nVSAM AdminAid panels display (in z\/OS ISPF or z\/VSE CICS) current and historical dataset information stored in the VAA VSAM History file. All fields are available for use in the extensive online filtering facility to list the desired VSAM files. For example, you can show all the files on volumes PROD* with less than 10 percent free space. The results initially display one line per dataset. When you select a dataset, one line for each date and time displays, allowing a drill down to see the detailed statistics for the selected date and time. Critical fields for any two file dates can show on the same screen. To see a dataset's changes between those dates, place a C (Compare) beside the two desired dates. In z\/OS, you can also enter an R (Reorganize) to edit a file's reorg JCL. \r\nClick here to see examples of some of VSAM AdminAid's ISPF screens. <\/a> <\/p>\r\n

3.<\/strong> <\/strong><\/strong> File Reorganization List Report<\/strong><\/span>
\r\nA batch report listing files potentially needing reorganization is based on criteria entered in online panels. The requirements can be at the dataset, category, catalog and default levels. Datasets can be grouped into categories. An example of reorg criteria is: files with more than 30 extents and more than 50 CA splits in the past three days. Files needing reorganization can also be listed online. Click here to see examples of a reorganization criteria screen and part of a File Reorganization List report.<\/a><\/p>\r\n

4.<\/strong> <\/strong><\/strong> VSAM AdminAid Adhoc Report Writer<\/strong><\/span>
\r\nVSAM AdminAid Adhoc Report Writer allows customized batch reports from a catalog list extract file. Input control parameters determine the files to select (for example, files on volumes TEST* with more than 1,000 tracks allocated), the field names to  include on the detail lines, and the report sort field(s) (tracks allocated in this example). Click here to see sample Adhoc Report Writer control cards and the report that is produced from them.<\/a><\/p>\r\n

\r\n<\/p>\r\n

\r\nVSAM AdminAid Purge Utility<\/strong> (also included)
\r\nA batch purge utility job is provided to clean up older, unneeded VAA VSAM History file records. Records can be purged based on several criteria (age, DSN no longer cataloged in z\/OS, any of the fields in the online filter, etc.). In addition, the job can reorganize the VSAM History file with the remaining records.<\/p>\r\n

 <\/p>\r\n

\r\n<\/p>\r\n

\r\n<\/p>\r\n

\r\nCurrent LISTCAT Plus and LISTCAT Plus Adhoc Report Writer customers will be pleased to know all existing LISTCAT Plus and Adhoc Report Writer functions are available, and jobs will work in VSAM AdminAid with minor or no modification. However, the existing jobs will need modification to take advantage of new product features.<\/p>\r\n

 <\/p>\r\n

VSAM AdminAid replaces LISTCAT PLUS and Adhoc Report Writer.<\/p>\r\n

","summary":null,"featured":1,"status":1,"passwords":1,"extended_info":"0","deleted_at":null,"created_at":"2017-11-14T23:21:28.000000Z","updated_at":"2023-11-16T17:39:00.000000Z","sorted_releases":[{"id":562,"parent_id":null,"product_id":65,"release":"1.1","notes":"

<\/p>\n

    \n
  • Added the current statistics for VSAM files when that line\nis Selected or Compared in ISPF.<\/li>\n
  • Made the following enhancements for multiple-volume<\/strong><\/span> VSAM\nfiles:<\/li>\n<\/ul>\n

    Changed Extents and Tracks Allocated to\nbe the total extents or tracks allocated for ALL of a file's volumes,\ninstead of just for its first volume.\u00a0
    \nIncreased the maximum volumes per file kept on the History file from 20\nto the z\/OS maximum of 59.
    \nAdded Tracks Allocated per volume for each VSAM file.
    \nAdded the total number of volumes per file to the Browse VSAM detail\npanel.<\/p>\n

      \n
    • Added the following new\nfields<\/strong><\/span> for VSAM files to all areas of VSAM AdminAid\n(Browse History, Filter selection, and Adhoc Report Writer):<\/li>\n<\/ul>\n

      CA-Reclaim, Speed\/Recovery, Record Level\nSharing fields RLS Log, RLS VSAM Quiesced, RLS in Use.<\/p>\n

        \n
      • Added Tracks Allocated, Unused Tracks and Index Levels to the VAA\nCSI (job VAAJCSI, program VAAPCSI).<\/li>\n
      • Added new field DSN-LAST-QUALIFIER to the Adhoc Report Writer. This\nis the cluster's rightmost\/low-level qualifier.<\/li>\n
      • Various other minor fixes, improvements and enhancements.<\/li>\n<\/ul>\n","released_on":"2014-02-28T23:21:28.000000Z","deleted_at":null,"children":[]},{"id":509,"parent_id":null,"product_id":65,"release":"1.0","notes":"

        Initial release.<\/p>\n","released_on":"2012-09-18T21:21:28.000000Z","deleted_at":null,"children":[{"id":539,"parent_id":509,"product_id":65,"release":"1.0.06","notes":"\n

        Maintenance release.<\/p>\n","released_on":"2013-05-16T21:21:28.000000Z","deleted_at":null}]}],"releases":[{"id":509,"parent_id":null,"product_id":65,"release":"1.0","notes":"

        Initial release.<\/p>\n","released_on":"2012-09-18T21:21:28.000000Z","deleted_at":null,"children":[{"id":539,"parent_id":509,"product_id":65,"release":"1.0.06","notes":"\n

        Maintenance release.<\/p>\n","released_on":"2013-05-16T21:21:28.000000Z","deleted_at":null}]},{"id":562,"parent_id":null,"product_id":65,"release":"1.1","notes":"

        <\/p>\n

          \n
        • Added the current statistics for VSAM files when that line\nis Selected or Compared in ISPF.<\/li>\n
        • Made the following enhancements for multiple-volume<\/strong><\/span> VSAM\nfiles:<\/li>\n<\/ul>\n

          Changed Extents and Tracks Allocated to\nbe the total extents or tracks allocated for ALL of a file's volumes,\ninstead of just for its first volume.\u00a0
          \nIncreased the maximum volumes per file kept on the History file from 20\nto the z\/OS maximum of 59.
          \nAdded Tracks Allocated per volume for each VSAM file.
          \nAdded the total number of volumes per file to the Browse VSAM detail\npanel.<\/p>\n

            \n
          • Added the following new\nfields<\/strong><\/span> for VSAM files to all areas of VSAM AdminAid\n(Browse History, Filter selection, and Adhoc Report Writer):<\/li>\n<\/ul>\n

            CA-Reclaim, Speed\/Recovery, Record Level\nSharing fields RLS Log, RLS VSAM Quiesced, RLS in Use.<\/p>\n

              \n
            • Added Tracks Allocated, Unused Tracks and Index Levels to the VAA\nCSI (job VAAJCSI, program VAAPCSI).<\/li>\n
            • Added new field DSN-LAST-QUALIFIER to the Adhoc Report Writer. This\nis the cluster's rightmost\/low-level qualifier.<\/li>\n
            • Various other minor fixes, improvements and enhancements.<\/li>\n<\/ul>\n","released_on":"2014-02-28T23:21:28.000000Z","deleted_at":null,"children":[]}]}