BT08 - VSAM File Management - 1 Day

Course Description

The course is aimed at developers' wanting to design, set up and maintain VSAM clusters. This course covers all the statements required to create, amend and delete VSAM datasets. Exercises are included, so that experience is gained in the key areas of maintaining VSAM datasets.

Pre-requisites

Knowledge of JCL is required. This can be gained by attending course BT02.

  • Choose the correct VSAM format
  • Understand the four types of VSAM datasets
  • Understand and set the necessary parameters to allocate VSAM datasets
  • Be able allocate VSAM datasets using JCL, ISPF and File-Aid
  • Understand and use Alternate Indexes
  • Load data onto VSAM datasets
  • Understand how VSAM datasets are accessed in COBOL or PL/1 programs

Objectives

Whilst covering the basics of VSAM File Management, this course also aims to give an insight into the different types of VSAM clusters and how they are accessed.

On completion of this course the student will be able to:

  • Choose the correct VSAM format
  • Understand the four types of VSAM datasets
  • Understand and set the necessary parameters to allocate VSAM datasets
  • Be able allocate VSAM datasets using JCL, ISPF and File-Aid
  • Understand and use Alternate Indexes
  • Load data onto VSAM datasets
  • Understand how VSAM datasets are accessed in COBOL or PL/1 programs

Environment

Development will be performed using:

  • IBM Mainframe

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

GETTING STARTED
VSAM Datasets
VSAM File Characteristics
VSAM Advantages
VSAM File Types
Ways to Identify Logical Records
VSAM Components
VSAM Cluster
Control Interval
Control Area
Spanned Records
Considerations
VSAM Access Types
Summary Of VSAM Facilities

VSAM DEFINITION
Defining a Cluster
Cluster Definition Parameters
Deleting a Cluster
Cluster Deletion Parameters
Parameter Abbreviations
Using ISPF to Define and Delete VSAM Clusters
VSAM File - Define
Allocating A New VSAM File Using File-AID

ENTRY-SEQUENCED DATASETS
Entry-Sequenced Datasets
ESDS Main Features
Alternate Index
ESDS Data Access

KEY-SEQUENCED DATASETS
Key-Sequenced Datasets
KSDS Freespace Considerations
KSDS Main Features
The Index Component
Index Structure
Control Interval Splits and Control Area Splits
Data Access
Direct Access
Sequential Access
Skip-Sequential Access

RELATIVE RECORD DATASETS
Relative Record Datasets
Data Access
RRDS Main Features
RRDS Structure

LINEAR DATASETS
Linear Datasets
Linear Main Features

VSAM COMMANDS
Overview
The Alter Command
The Repro Command
Using Repro to Reorganize a Dataset
Repro Parameters
The Listcat Command
The Examine Command
The Verify Command
The Print Command

USING AN ALTERNATE INDEX
What Is An Alternate Index?
How Does An Alternate Index Work
Defining An Alternate Index

BROWSING USING FILE-AID
Overview
Datasets Supported
Accessing Browse
The Browse Panel
Character Mode
Vertical Mode
Formatted Mode
Browse Primary Commands
COBOL File Layout / Copybook Example

VSAM AND CICS
Initial Setup
File Control Table (FCT)
Reading
Writing
Deleting
Updating
Unlocking
Browsing Multiple Records
Batch And On-Line File Access

VSAM AND COBOL OVERVIEW
File Definition – Select Statement
Opening VSAM Files
Indexed Read
Sequential Read
Write Records
Rewriting Records
Deleting Records
Positioning Within A File - Start

VSAM AND SAS OVERVIEW
Using SAS System Options
VSAM Option for the FILENAME Statement
Reading a VSAM File
Writing to an Empty VSAM File
Updating a VSAM Data Set
Reading Records from a KSDS
KSDS Reading – Key Option
KSDS Reading – KEYGE Option
KSDS Reading – GENKEY Option
KSDS Reading – Direct RBA Access
Reading a KSDS with Skip Sequential Access
Adding Records to a KSDS
Updating Records in a KSDS
Erasing Records from a KSDS

VSAM AND REXX OVERVIEW
Rexx / Vsam - File Processing
Rexx / Vsam - File Definition / Deletion
Rexx / Vsam - File Repro
Rexx / Vsam – Data Manipulation

FILE ACCESS STATUS CODES
File Access Status Codes

Course Format

Practical sessions make up a large part of the course, allowing delegates to demonstrate and reinforce the lectures given. During these sessions the delegate will gain experience of writing and testing different types of JCL to create, delete, modify and load data onto VSAM files.

Examples are used extensively, ranging from simple code snippets to full applications with complete 'real world' functionality. These are supplied at the start of the course and it is encouraged that the delegates execute and 'experiment' with these under the instructor's guidance as they are introduced.

These examples are available to take away, along with the delegate's own work.

The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.

Course Enquiry