Training

VSAM Classes

VSAM Concepts and Tuning
This is the most comprehensive VSAM tuning class you can get in 3 days! Over 25 years of tuning experience has gone into this class. AUDIENCE: Persons responsible for designing, implementing or tuning VSAM datasets such as data base administrators, application and system programmers. This unusual and popular class is invaluable to inexperienced and experienced OS/390 and VSE VSAM users. OBJECTIVE: Students should be able to properly design efficient VSAM databases. Also learn how to continually tune VSAM files. DESCRIPTION: This extremely comprehensive class illustrates how to design, tune, and reduce disk space utilization of VSAM files. All types of VSAM files including ESDS, KSDS and RRDS are covered. Catalogs and alternate indexes are also covered. VSAM performance and recovery are the major topics of this class. Conversions from SAM, DAM and ISAM are also discussed. ICF considerations for OS/390 new VSAM for VSE is examined. Planning for new device types is also discussed. This class is a must for persons responsible for tuning VSAM files. WORKSHOP: LISTCAT statistics evaluations. Students create, load, modify, and tune actual VSAM datasets using utilities and supplied programs. The effects of various options and dataset characteristics are evaluated. Students also receive valuable VSAM performance evaluation forms developed by MG Technologies. They may be used to gauge the performance of files as they are tuned. These forms are used long after the class! Students may request MVS or VSE books when registering for this class. Students in on-site classes may optionally use existing files for this workshop. On-site classes are taught in MVS or VSE versions.			The following topics will be covered in the workshop: VSAM dataset characteristics review Tuning methodologies Printing VSAM statistics Analyzing LISTCAT statistics Problem definition and setup Job Control Language Parameter selection Cluster definition Loading data with REPRO and SORT Loading data using application programs Performance evaluation forms Sequential retrieval Sequential maintenance Random retrieval Random maintenance Problem review Printing VSAM datasets Using VSAM files as work files Comparison of COBOL SEQUENTIAL, RANDOM and DYNAMIC processing PREREQUISITES: Students should understand random processing concepts. Knowledge of MVS or VSE Job Control Language is also recommended. TOPICS COVERED: VSAM dataset types and capabilities Cluster and component relationships Record, block and controlinterval relationships Organization of indexes Buffer allocation and selection Physical characteristics Controlinterval size selection DASD space utilization Controlarea size selection Adding, inserting and deleting records Controlinterval/area splits Controlinterval/area freespace selection Key compression Selection index options Speed versus Recovery Online considerations Alternate indexes Dataset design considerations Master and user catalogs IDCAMS commands overview Selecting cluster options Cluster definition LISTCAT analysis overview Tune sample dataset in class VSAM control blocks Online buffer sharing
DURATION: 3 days COURSE #: VS100		PUBLIC FEE: $800 Students Each 1 $800 2 $760 3-5 $720 6-7 $680 8-> $640		ON-SITE FEE: Students Each 10 $720 11-15 $540 16-> $360 Other Information

VSAM Application Programming
AUDIENCE: Application programmers and system programmers responsible for developing standards. OBJECTIVE: Illustrate the performance considerations of techniques used when writing high level language programs that process VSAM datasets. DESCRIPTION: Few people realize how much the application program can affect performance. Most programmers assume that file tuning is performed only through VSAM definitions. Students are made aware of the performance implications of various COBOL file functions. Students are shown how to efficiently create, load and modify VSAM datasets using application programs. The effects of various compiler options and file definitions are evaluated. VSAM diagnostic analysis and other advanced programming techniques are also illustrated. Student books are available for COBOL/OS390 and VSE. This class is a logical extension to the VSAM Concepts and Tuning class. On-site versions of this class may be presented in OS/390 or VSE versions. WORKSHOP: None. Examples are provided. PREREQUISITES: Students should have attended the VSAM Concepts and Tuning class.			TOPICS COVERED: VSAM dataset characteristics review Problem definition Job Control Language Command list Status key settings for COBOL Extended error analysis and status key settings for COBOL Open and close options Loading a dataset Sequential retrieval Sequential update of an ESDS Sequential update of a KSDS Sequential update of an RRDS Extending a dataset Random retrieval Random maintenance Processing via an alternate index Problem review Printing VSAM datasets VSAM work files Relative Byte Address (RBA) processing Changing performance via Job Control Language Online considerations Select, Declare and ACB options ISAM interface
DURATION: 2 days COURSE #: VS110		PUBLIC FEE: $500 Students Each 1 $500 2 $475 3-5 $450 6-7 $425 8-> $400		ON-SITE FEE: Students Each 10 $450 11-15 $337 16-> $225 Other Information

VSAM Utilities and Recovery
AUDIENCE: Database administrators, application and system programmers or other persons responsible for implementing and maintaining VSAM datasets. Experienced and inexperienced MVS and VSE VSAM users will find this class very useful. OBJECTIVE: Illustrate how to implement backup and recovery procedures, reliability evaluations, DASD conversions, and other responsibilities. DESCRIPTION: This is a comprehensive class on the VSAM Access Method Services utilities. Each function of IDCAMS is thoroughly covered. Emphasis is placed on VSAM catalog and dataset recovery. We will cover how to efficiently build and load alternate indexes Students are shown how to establish reliable and fast VSAM backup and restore procedures. Topics also include ISAM, DAM, SAM, and DASD device conversions. On-site versions of this class are taught in MVS or VSE versions. Student materials are available in both versions. WORKSHOP: None. Examples are provided. PREREQUISITES: Students must have attended the VSAM Concepts and Tuning class and know OS or DOS Job Control Language.			TOPICS COVERED: Command list overview Job Control Language requirements Modal commands and syntax Recovery considerations Security options Defining master and user catalogs for ICF or non-ICF Allocating VSAM space Establishing default models Defining non-VSAM entries Establishing alternate indexes Altering entry characteristics Transporting files and catalogs Backup and restore considerations REPRO functions EXPORT and IMPORT Non-VSAM backup utilities Recovery requirements SPEED and RECOVERY options Using VERIFY during recovery Using LISTCAT and LISTCRA during recovery Using RESETCAT during recovery Using EXPORT and EXPORTRA during recovery Converting non-VSAM to VSAM Integrated catalog Facility considerations Printing VSAM datasets Printing non-VSAM datasets Interpreting LISTCAT output Disconnecting catalogs Special commands
DURATION: 2 days COURSE #: VS200		PUBLIC FEE: $500 Students Each 1 $500 2 $475 3-5 $450 6-7 $425 8-> $400		ON-SITE FEE: Students Each 10 $450 11-15 $337 16-> $225 Other Information