VSAM Performance Optimization
- A Practitioner Series Course Offering
Copyright © 2001 Mentor Services Corp - 200 White Plains Road - Tarrytown - NY 10591.

MORE INFORMATION COURSE LIST MENTOR HOME PAGE

Introduction: The VSAM access method provides services for all forms of data set manipulation, and is used extensively in most MVS installations. VSAM is frequently used for application data bases in such systems as CICS and IMS. Therefore, its performance can be a major concern, as it can drastically affect end-user response time. This course takes a close look at the aspects of VSAM data set organization and buffer utilization affect the performance of VSAM data sets.

This course is intended for users who will actively create or monitor and tune VSAM data sets. It covers the Access Method Services (AMS) DEFINE command options that affect initial allocation and performance. It also shows how the statistics available from the AMS LISTCAT command can be used to determine when a VSAM performance problem exists and can indicate the activity required to correct it. In addition, it shows which utility services can be used to reorganize a VSAM data set.

Audience: System or application programmers, data base administrators, or system support personnel who need to create or tune VSAM data sets used in performance-oriented applications.

Objectives:  On completion of this course, the student should be able to:

  • Explain the impact of AMS DEFINE options on VSAM data sets performance
  • Calculate the number of buffers for optimum VSAM data set performance
  • Use AMS LISTCAT statistics to analyze and fix VSAM performance problems
  • Use AMS utilities to reorganize VSAM data sets
  • Determine optimum Control Interval size for VSAM data set components

Prerequisites: The student must have a working knowledge of Access Method Services, MVS JCL and VSAM concepts. These requirements can be met by attending the VSAM and Access Method Services and JCL for End-Users courses.

Duration: This course is 3 days long.