Frank, I should have explained that there is a reason for inserting the record and then deleting it. When building the initial key for the VSAM KSDS record for insertion and subsequent deletion, you should build a key of all X'FF's. If you do not do this, then later, as subsequent keys are inserted into the data set, performance is degraded.
You mentioned also that you are doing this for indexes, and mentioned VSAM ESDS data sets. Normally, IMS indexes are just VSAM KSDS data sets, except when you have non-unique keys, and then the VSAM ESDS data sets are required. If you a /SX to the secondary index key, then your keys are unique and you can get rid of the VSAM ESDS data sets completely and just have the VSAM KSDS data sets. Most customers have done this long ago because the performance benefits are significant. You also might get some interesting responses if you post this question to the IMS-LIST. 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 Frank Swarbrick Sent: Wednesday, March 25, 2009 8:38 PM To: [email protected] Subject: Re: initialize (reset) file On Wed, 25 Mar 2009 19:17:27 -0500, Tom Harper <[email protected]> wrote: > Frank, > > Agreed, it would be nice, but there is no such function. > > Your program needs a couple of additions to work. You'll need to set up a standard save area and you need to do a PUT to add a record and an ERASE to delete it. Why the need for the add/delete record? I've tried it without it and it works. I seem to recall some historical need for this, but it appears to no longer be required(?). Frank ---------------------------------------------------------------------- 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
