VSAM Performance Optimization
|
|
|
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:
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. |