I'm not a DBA, but I would think there would be a problem with an AIX with a large number of "unknows" in it. If there are a large number of rows with an index of hex zeros, is the AIX really helping any?
Tom Kelman Enterprise Capacity Planner Commerce Bank of Kansas City (816) 760-7632 > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Chris Hoelscher > Sent: Monday, May 04, 2009 10:53 AM > To: [email protected] > Subject: Re: Crazy VSAM question > > i do not know of a way to do what you are asking (bypass updating the AIX) > - but ... > > how bout adding a 1-byte field to the file (alt--key-known) > when the AIX key is not known - radomize it - and move "N" to the one-byte > field - else use the real AIX-key value and move "Y" to the new field > > there are most likely at least 100 things wrong with my suggestion - but > it MIGHT work ... > > > Chris Hoelscher > Senior IDMS & DB2 Database Administrator > Humana Inc > 502-476-2538 > [email protected] > > you only need to test the programs that you want to work correctly > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain CONFIDENTIAL material. If you > receive this material/information in error, please contact the sender and > delete or destroy the material/information. > > ---------------------------------------------------------------------- > 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 ***************************************************************************** If you wish to communicate securely with Commerce Bank and its affiliates, you must log into your account under Online Services at http://www.commercebank.com or use the Commerce Bank Secure Email Message Center at https://securemail.commercebank.com NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. ***************************************************************************** ---------------------------------------------------------------------- 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
