Thanks for the tip(s). -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Tom Harper Sent: Thursday, March 12, 2009 4:06 PM To: [email protected] Subject: Re: VSAM files
Mike, Such tools exist (I think McKinney Systems has one), but I don't think you would want to use it in the manner you have described. Here's why: * CI/CA splits are not indicative of poor performance. If you reorg such a file, the splits are likely to re-occur. * Total extents do not degrade performance on today's RAID devices. * EXCPs are not recorded for many types of VSAM I/O, for example, Media Manager and STARTIO. * Statistics kept in the VSAM catalog are stale and only updated when the file is properly closed, perhaps never. I would study up on VSAM performance (there are some good sessions at SHARE) and re-assess your criteria. Then, be thankful you only have hundreds of VSAM files. I know of customers who have over a million VSAM files. In general, VSAM performance problems are less related to the data sets themselves and more related to the techniques used to access them, buffers, LSR, etc. Tom Harper IMS Utilities Development Team Neon Enterprise Software Sugar Land, TX -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Ward, Mike S Sent: Thursday, March 12, 2009 3:42 PM To: [email protected] Subject: VSAM files Hello all, I'm looking for a free utility that could read a vsam listcat and possibly display the names of the vsam files that might have problems performance wise. Something that would look at CI/CA splits, total extents, excps vs reads/writes inserts. We have hundreds of vsam files and I don't want to look at each and every one of them. Any help appreciated. Thanks ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ========================== This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
