- Tel: +44 (0)1275 859666
BT08 - VSAM File Management - 1 Day
| Date | Location | Duration | Cost | Enrol | Enquiry |
|---|---|---|---|---|---|
| 2025-11-14 | Virtual | 1 Day | £600.00 (plus VAT) | Enquire |
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 File Characteristics
- 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
- Cluster Definition Parameters
- ENTRY-SEQUENCED DATASETS
- Entry-Sequenced Datasets
- ESDS Main Features
- Alternate Index
- ESDS Data Access
- ESDS Main Features
- 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
- KSDS Freespace Considerations
- RELATIVE RECORD DATASETS
- Relative Record Datasets
- Data Access
- RRDS Main Features
- RRDS Structure
- Data Access
- LINEAR DATASETS
- Linear Datasets
- Linear Main Features
- 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
- The Alter Command
- USING AN ALTERNATE INDEX
- What Is An Alternate Index?
- How Does An Alternate Index Work
- Defining An Alternate Index
- How Does An Alternate Index Work
- 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
- Datasets Supported
- VSAM AND CICS
- Initial Setup
- File Control Table (FCT)
- Reading
- Writing
- Deleting
- Updating
- Unlocking
- Browsing Multiple Records
- Batch And On-Line File Access
- File Control Table (FCT)
- 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
- Opening VSAM Files
- 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 Option for the FILENAME Statement
- VSAM AND REXX OVERVIEW
- Rexx / Vsam - File Processing
- Rexx / Vsam - File Definition / Deletion
- Rexx / Vsam - File Repro
- Rexx / Vsam – Data Manipulation
- Rexx / Vsam - File Definition / Deletion
- 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.