VSAM Performance and Tuning (DEV1180)
Course Description
This course explores the performance and tuning options available with VSAM including CISZ, CASZ, IMBED, REPLICATE, freespace and bufferspace allocations. The student is given practical tools to work with to help determine the best setup for a VSAM file. Examples of LISTCATs are used to illustrate points made in lecture. The student is given exercises to determine optimum bufferspace and to determine the size of a file. A hands-on workshop gives the student a chance to see the results of his tuning choices on an actual VSAM file.
Course Audience
Programmers, systems programmers and technical support people who are responsible for tuning VSAM files.
Course Topics
Introduction
- Basic steps in tuning
- Areas for tuning
Control interval/Control area sizes
- Control interval, control area structures
- Physical blocks
- KSDS indexes
- CI/CA splits
- Key compression
- CI/CA sizes
Freespace
- How freespace is used
- Calculating effective freespace
| | |
Calculating space requirements
- Determining space allocation
- Estimating space for data/index components
Buffer allocation
- Allocating buffers to data, index
- VSAM buffer allocation techniques
- How bufferspace is allocated for sequential/random processing
- Alternate index buffering
- Shared resources
|
Prerequisite Education
None.
Prerequisite Knowledge/Experience
Experience using IDCAMS and working with VSAM data sets.
Delivery & Duration
This instructor-lead course is a one-day offering.
|
Outline Location: http://www.goldencg.com/edu/outlines/dev1180.html
