John, I don’t know the details of your situation so I’m just tossing out ideas here:
If the AIX doesn’t have to be upgradable, build the alternate index manually, excluding from the AIX any alternate index entries with low values keys. Depending upon your application, this may even work with an upgradable AIX. You might be able to use the obsolete parameter “KEYRANGES” on your AIX definition to exclude low value key entries on the alternate index. You could use a range of values instead of just low values to indicate an absent AIX key: set aside a range of values that will not occur with a non-absent key. For example, x’00’ followed with a binary timestamp. You could define an exceptionexit (on the Cluster or AIX) and code a work-around within it or at least avoid a lot of application changes. Combinations of the above suggestions. Harry > Date: Mon, 4 May 2009 10:37:18 -0500 > From: [email protected] > Subject: Crazy VSAM question > To: [email protected] > > A programmer has posed this question to me. My response, so far, has been > "no way". But I'll ask the truly knowledgeable here. > > We have a KSDS with an AIX. The data in the field which defines the > alternate keys is sometimes "unknown" and coded as LOW-VALUES (0x00's). > Well, this has lead to a problem where the number of base records for the > "unknown" value is often quite huge and exceeds the maximum allowable record > size on the AIX. This causes the base record add or update to fail. What the > programmer wants is a way to tell VSAM that if the AIX key is 0x00s, that it > is not necessary to update the AIX at all. I cannot think of any way to do > this. > > Any clever ideas? > > -- > John > > ---------------------------------------------------------------------- > 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 ---------------------------------------------------------------------- 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
