Sorry yes, I was speaking of UV. There the data for the index is stored in I_(filename) by default. But inside the header of the actual file, there is a pointer to where the indexes live. So the indexes could live somewhere else by using the SET.INDEX command, if you wanted to move them for performance reasons. You can use SET.INDEX (filename) INFORM to see where the index resides. So when you restore a file, both the real and the restored files have pointers to /accountpath/I_(filename)... provided it wasn't moved. Either way they will both point to the same place. Using the restored file without SET.INDEX (filename) TO NULL can (and often will) corrupt the index. Once you do this once, you won't forget about it again. Robert
>>> Steve Romanow <[email protected]> 7/8/2009 10:43 AM >>> Robert Porter wrote: > Just a quick note on indexes... and kind of goes to the EMC question. > > The location of the index is stored in header of the file itself! This can > lead to a problem if you have a copy of the data somewhere else > and try to use it. For example, we'll occasionally want to see how a > file/record looked from a few days ago. We'll restore it to > an alternate path. The first thing you MUST DO before you touch that file is > SET.INDEX (filename) TO NULL -- If you don't and you > start accessing it (iirc, even a read can make it go check the indexes) it > will start updating the live file's index with the restored files > data. Best part if you may not even know, until things (like SELECTs just > don't work in your production account. > > Robert > > > > Robert F. Porter, MCSE, CCNA, ZCE > Sr. Programmer / Analyst > Laboratory Information Services > Ochsner Health System > (504) 842 - 5185 > > > > This transmission (including any attachments) may contain confidential > information, privileged material (including material protected by the > solicitor-client or other applicable privileges), or constitute non-public > information. Any use of this information by anyone other than the intended > recipient is prohibited. If you have received this transmission in error, > please immediately reply to the sender and delete this information from your > system. Use, dissemination, distribution, or reproduction of this > transmission by unintended recipients is not authorized and may be unlawful. > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > Note that this is for Universe only, correct Robert? In Unidata, the index is in the present working dir as X_{filename} _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
