![]() |
VSAM / IDCAMS Utility
Duration: 2 or 3 days |
Participants: Application developers, analysts, technical support, systems and operations personnel. |
Objectives:
Upon successful completion of this course you will be able to:
- Describe the architecture of the ESDS, KSDS, and RRDS VSAM data files. - Describe important VSAM data set tuning and performance considerations. - Code the IDCAMS control statement(s) and JCL to create and alter VSAM data sets, indexes, paths, list the catalog entries, and print, copy, and delete VSAM and non-VSAM data sets. - Optional, upon request - Create and manage Generation Data Sets (GDSs) and Generation Data Groups (GDGs). |
Overview:
- This workshop covers VSAM architecture, IDCAMS utility commands, and creating, accessing and updating VSAM files using IDCAMS and appropriate JCL. Participants create and process KSDS, ESDS, and RRDS VSAM datasets. The coverage of RRDS and ESDS data sets can be abbreviated to the conceptual level. |
Prerequisites: Participants must be able to code basic JCL statements and use the edit and submit facilities of TSO/ISPF. |
Format: Instructor-led and extensive hands-on computer workshops. |
Related Courses:
After completing this course, consider attending:
- VSAM COBOL Programming - VSAM KSDS Performance and Tuning - VSAM CICS COBOL Programming - File-AID for VSAM |
Topic Outline:
- VSAM Overview Objectives History Reference books and online manuals VSAM Concepts - VSAM Architecture VSAM Organizations Advantages of VSAM KSDS ESDS RRDS Record Storage Dataset Components Control Interval Control Area Data Storage Terminology Comparison of File Types - VSAM / IDCAMS Utility IDCAMS Overview JCL for IDCAMS Command Language Structure Command Examples Condition Codes Modal Commands and Examples Functional Commands Define Cluster Syntax Define ESDS Example Define KSDS Example Define RRDS Example LISTCAT Repro Repro with INFILE Repro with REPLACE DELETE CI, CA Split Problem Reorganization – When, Why, and How VERIFY Alternate Indexes DEFINE ALTERNATEINDEX /AIX Data Record Layout DEFINE PATH BLDINDEX Comprehensive Example Using Alternate Indexes Using Commands with AIX ALTER - Generation Data Groups (GDGs) – Optional, Upon Request Defining and Using GDGs Accessing by Relative or Absolute Names Deleting a Generation Data Set (GDS) Deleting an Entire GDG |
|