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 [email protected]