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         PRINT         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

Course List       Site Map       Home