Mainframe: Virtual Storage Access Method [Vsam]

KSDS ESDS RRDS LDS PS

What you'll learn

What is VSAM?

Differences between KSDS, ESDS,RRDS and PS

How to create VSAM files using IDCAMS utility?

IDCAMS utility commands: DEFINE, REPRO, PRINT, DELETE, LISTCAT

Requirements

TSO/ISPF Module

JCL

Description

This course consist of: What is VSAM?Cluster DefinitionDifferences between VSAM and NON-VSAM datasetsDifferences between KSDS, ESDS, RRDS and LDS What is Control Interval (CI) and Control Area (CA)How to create KSDS, ESDS, RRDS files using IDCAMS utility  Explained different IDCAMS utility commandsDEFINEREPROPRINTDELETELISTCATALTERFile Manager toolDITTO toolThis course is totally practical oriented hence you will get almost all concepts explanation on Mainframe Shop.What is VSAM?The term Virtual Storage Access Method (VSAM) applies to both a data set type and the access method used to manage various user data types.As an access method, VSAM provides much more complex functions than other disk access methods. VSAM keeps disk records in a unique format that is not understandable by other access methods.Different type of VSAM datasets:Key Sequence Data Set (KSDS)This type is the most common use for VSAM. Each record has one or more key fields and a record can be retrieved (or inserted) by key value. This provides random access to data. Records are of variable length. IMS uses KDSDs.Entry Sequence Data Set (ESDS)This form of VSAM keeps records in sequential order. Records can be accessed sequentially. It is used by IMS, DB2, and z/OS UNIX.Relative Record Data Set (RRDS)This VSAM format allows retrieval of records by number; record 1, record 2, and so forth. This provides random access and assumes the application program has a way to derive the desired record numbers.Linear Data Set (LDS)This type is, in effect, a byte-stream data set and is the only form of a byte-stream data set in traditional z/OS files (as opposed to z/OS UNIX files). DB2 and a number of z/OS system functions use this format heavily, but it is rarely used by application programs.

Overview

Section 1: VSAM [Virtual Storage Access Method]

Lecture 1 Introduction to VSAM

Lecture 2 ESDS file creation

Lecture 3 RRDS Cluster creation

Lecture 4 IDCAMS Commands: REPRO, PRINT

Lecture 5 Control Interval and Control Area

Who are interested to know more about VSAM