> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of McKown, John > Sent: Monday, December 04, 2006 8:31 AM > To: [email protected] > Subject: Re: Cancelling a job/tso user in a 100% CPU situation. <snip> > > We use Hyper-buff to "self tune" access to VSAM files. Although we are > 100% VSAM (no RDMS at all) for all "data storage", our programmers are > very VSAM ignorant. We are constantly reminding them that they cannot > add a base record if there is an AIX and the new key won't fit in the > AIX record for the base key. They get what they intepret as an "out of > space" error and look at the base, which has plenty of expansion > available, and just zone out. > <snip>
Uh, said that just backward - Quick! More Coffee! I meant that you cannot add another base key to the AIX record for an given alternate key if the base key will not fit into the RECSIZE defined for the AIX file. We have VSAM files where there are literally THOUSANDS of base keys for a given alternate key. Like using a person's ZIPCODE or STATE code for the alternate key. Yes, we do this. -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology This message (including any attachments) contains confidential information intended for a specific individual and purpose, and its content is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this transmission, or taking any action based on it, 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
