Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

VSAM Part 2 (Tuning and Programming)

Course:   VS
Duration:   2 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/VS.html
 
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.

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:

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.

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.