VSAM Part 2 (Tuning and Programming)

Course:  VS
Duration:  2 Days
Level:  II
Course Summary

VSAM (Virtual Storage Access Method) is the most popular currently supported access method of IBM. As such, it is an area in which every application programmer will need some degree of expertise. Not only will the programmer be required to maintain and use VSAM files that have already been created, but will also find it necessary to create new data sets, define alternate indices for the existing files, and maintain master and user catalogs for optimum performance.

« Hide The Details
Topics Covered In This Course

INTRODUCTION TO VSAM

  • Evolution of Access Methods
    • DAM
    • BDAM
    • ISAM
    • VSAM
  • VSAM File Types
    • KSDS
    • ESDS
    • RRDS
    • LDS
  • Basic VSAM Terminology
    • Cluster
    • Component
    • Data
    • Index
    • Freespace
    • Control Interval
    • Control Area
    • Splits

DISKS AND CATALOGS

  • Disks
    • Blocks
    • Tracks
    • Cylinders
  • Catalogs
    • CVOL
    • VTOC
    • VSAM Catalog
    • ICF Catalog
    • Mastercats
    • Usercats
    • Alias
  • The order of a Catalog Search
  • Data Facility Product (DFP) Concepts
  • IDCAMS Commands
    • DEFINE MASTERCAT
    • DEFINE USERCAT
    • DEFINE ALIAS

RULES OF IDCAMS

  • IDCAMS Syntax Rules
  • JCL Requirements
    • MVS
    • VSE
    • ESA
  • Condition Codes
  • MODAL options

CREATING A VSAM CLUSTER

  • DEFINE CLUSTER options
    • KSDS
    • ESDS
    • RRDS
    • LDS
  • Example of an "IDEAL" Define

LISTCATS

  • Creating a LISTCAT
  • Interpreting a LISTCAT
    • Field by Field
    • At a Glance

TUNING A VSAM CLUSTER

  • VSAM Tuning Concepts
  • Using your LISTCAT
  • Tuning
    • CISZ
    • FSPC
    • Space Allocations
    • Indexes
  • Formulas and Calculations
  • Disk Tables

REORGANIZING A VSAM CLUSTER

  • Backing Up a Cluster
  • Deleting a Cluster
  • Reusing a Cluster
  • Loading Data
  • IDCAMS Commands
    • REPRO
    • DELETE
    • EXPORT
    • IMPORT

ALTERNATE INDEXES

  • Alternate Index Concepts
  • Building a path
  • Building an alternate AIX
  • Tuning an AIX
  • JCL Requirements

OPTIMIZING VSAM USE

  • Batch versus CICS use
  • Buffering
    • BUFNI
    • BUFND
  • Shareoptions
    • Cross Region
    • Cross System
  • CICS
    • NSR
    • LSR
    • FCT
    • Shutdown Statistics

COBOL PROGRAMMING

  • Batch COBOL Rules
    • Select/Assign Clause
    • FD Clause
    • File Verbs (Open, Write, etc.)
  • VSAM Differences for COBOL II
  • Examples
    • KSDS
    • ESDS
    • RRDS
    • AIX

PLI PROGRAMMING

  • Batch PLI Rules
    • Declare (DCL)
    • File Verbs (Open, Write, Etc.)
  • Examples
    • KSDS
    • ESDS
    • RRDS
    • AIX

ASSEMBLER PROGRAMMING

  • VSAM Macros
    • ACB
    • RPL
    • OPEN, etc.
  • Examples
    • KSDS
    • ESDS
    • RRDS

CICS Programming

  • CICS VSAM Concepts
    • FCT Definition
    • EXEC CICS Commands
  • Examples
    • KSDS
    • ESDS
    • RRDS
    • AIX

OTHER VSAM CONCEPTS

  • Manipulating a File
    • Print Contents of a File
    • Alter Definition of a File
  • Maintaining File Integrity
    • Verify End-of-File Marker
    • Compare Catalog Entry to Physical File Definition
  • Other Defines
    • Defining a NONVSAM File
    • Defining a Generation Data Group
  • Cache Memory Concepts

LINEAR DATA SETS(LDS)

  • Linear File Concepts
    • Virtual Storage Windowing
    • Data/Hyper Spaces
  • Define Cluster Example
  • Programming Example (COBOL II)

DATA FACILITY STORAGE MANAGEMENT SUBSYSTEM (DFSMS)

  • System Managed Storage
    • Data Classes
    • Storage Classes
    • Management Classes
    • Storage Groups
  • Changes to VSAM
  • JCL Changes
What You Can Expect

After taking this course the student should be able to:

  • Provide an understanding of the concepts of the VSAM file.
  • Present the Access Methods Services program and its parameters. (IDCAMS)
  • Develop the student's mastery of COBOL, COBOL II, PL1 AND ASSEMBLER programming language in relationship to VSAM files.
  • Provide the student with the necessary knowledge to tune VSAM files.
  • Present case studies which require the use of the Access Method Service Commands.
  • Introduce state of the art concepts.
Who Should Take This Course

This course is intended for those whose job it is to create, access, and maintain VSAM files.

Recommended Prerequisites

The participant should have a basic knowledge of file concepts is assumed. Some experience in creating and updating files is advantageous. A rudimentary knowledge of JCL is helpful but not required.

Training Style

This class is taught by lecture with hands-on workshops.

« Hide The Details
Related Courses
Code Course Title Duration Level
VSID
VSAM Part 1 (VSAM and IDCAMS Workshop)
3 Days
I
Details
ZOSM
z/OS Storage Management Fundamentals
5 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com