18 May, 2012
Text Size

VSAM Tuning and Performance

Audience

This course is designed for those z/OS technicians who require a greater understanding of VSAM within their z/OS installation. This will allow them to analyse their use of VSAM with the aim of improving performance and reliability and reducing errors.

Prerequisites

Delegates should have at least a basic knowledge of TSO/ISPF and JCL. An appreciation of VSAM, IDCAMS and general buffering would be helpful.

Duration

2 days. Hands on.

Course 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

Upcoming IBM z/OS Courses

Course Contact Form

Please complete the form to enquire about running a course at your premises or one of our training facilities

Name:

Email:

Telephone:

Organisation:


Comment: