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. AUDIENCE:   This course is intended for those whose job it is to create, access, and maintain VSAM files. 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. DURATION:   2 Days APPROACH:   This class is taught by lecture with hands-on workshops. OBJECTIVES:   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. COURSE CONTENT:   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 HW/08