VSAM Performance Tuning

50 pages
20 views

Please download to get full document.

View again

of 50
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
VSE/VSAM – Inside & Out John Mycroft, Software Developer CSI International www.e-vse.com johnm@e-vse.com WAVV 2007, Green Bay, WI Acknowledgement With grateful thanks to Dan Janda, The Swami of VSAM, from whom most of this presentation was stolen WAVV 2007, Green Bay, WI Abstract This presentation gives an overview of VSAM & its components. We take a look at what a VSAM file really looks like and how to soup up its performance. We also look at some common mistakes and how to avoid them. Th
Tags
Transcript
  WAVV 2007, Green Bay, WI VSE/VSAMVSE/VSAM––Inside & OutInside & Out John Mycroft, Software DeveloperJohn Mycroft, Software DeveloperCSI InternationalCSI Internationalwww.ewww.e--vse.comvse.com johnm@e johnm@e--vse.comvse.com  WAVV 2007, Green Bay, WI AcknowledgementAcknowledgement  With grateful thanks to DanWith grateful thanks to DanJandaJanda, The Swami of VSAM,, The Swami of VSAM,from whom most of thisfrom whom most of thispresentation was stolenpresentation was stolen  WAVV 2007, Green Bay, WI AbstractAbstract  This presentation gives an overview of VSAM & its components.This presentation gives an overview of VSAM & its components.We take a look at what a VSAM file really looks like and how toWe take a look at what a VSAM file really looks like and how tosoup up its performance.soup up its performance.  We also look at some common mistakes and how to avoid them.We also look at some common mistakes and how to avoid them.  This presentation and its materials are copyrighted andThis presentation and its materials are copyrighted anddeveloped by John Mycroft from a presentation srcinallydeveloped by John Mycroft from a presentation srcinallycopyrighted by Dancopyrighted by DanJandaJanda. Permission is granted for WAVV to. Permission is granted for WAVV toreproduce this presentation for distribution to its members at nreproduce this presentation for distribution to its members at noocharge.charge.  Trademarks:Trademarks:  IBM, VSE, VSE/ESA,IBM, VSE, VSE/ESA,zVSEzVSE, CICS & DL/I are trademarks or registered, CICS & DL/I are trademarks or registeredtrademarks of the IBM Corporationtrademarks of the IBM Corporation  The Swami of VSAM is a trademark of DanThe Swami of VSAM is a trademark of DanJandaJanda..  WAVV 2007, Green Bay, WI VSE/VSAM OverviewVSE/VSAM Overview  Virtual Storage Access MethodVirtual Storage Access Method  For disk filesFor disk files  SequentialSequential–– “Entry Sequence Dataset” or ESDS “Entry Sequence Dataset” or ESDS  Begin at the beginning, go onBegin at the beginning, go ontiltilyou get to the end andyou get to the end andthen stopthen stop  IndexedIndexed–– “Keyed Sequence Dataset” or KSDS “Keyed Sequence Dataset” or KSDS  Process by key or sequentially or a mixtureProcess by key or sequentially or a mixture  DirectDirect–– “Relative Record Dataset” or RRDS (fixed) or “Relative Record Dataset” or RRDS (fixed) orVRDS (variable)VRDS (variable)  Calculate a record’s location in the file to access itCalculate a record’s location in the file to access it  Alternate index (AIX)Alternate index (AIX)––gives an alternative route to agives an alternative route to aKSDSKSDS  Allows unique & nonAllows unique & non--unique keysunique keys
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks