Thanks for the tips, Colin. I've added them to my collection of goodies. Great point, too, about making sure nobody has the file open before deleting its index. Not sure if the docs have been updated, but they didn't used to warn you about this. So thinking it was safe, somebody here ran DELETE-INDEX <filename> ALL on a production file and everyone who had the file OPENed by their UniBasic program was blown out of the affected Unidata session.
>>> [EMAIL PROTECTED] 08/03/04 1:58 PM >>> I think your assumption may be incorrect. I recently restored some indexes into an account where the files weren't "defined" as having an index and it caused some problems. However, it is easy to trick UD with a bogus index. I just copy another X_ file and rename it. If one doesn't exist I simply create an index on another (small) file, copy and rename it, and then delete both with the ALL keyword. Works like a charm. Of course, I make sure nobody will be trying to update the file while I'm doing it - just in case. I think I've even copied over a "data" file and renamed it before doing the DELETE-INDEX filename ALL. -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: Thomas Derwin [mailto:[EMAIL PROTECTED] >Sent: Tuesday, August 03, 2004 11:29 AM >To: [EMAIL PROTECTED] >Subject: RE: [U2] [UV] Primary:Index (mis)matching. > > >FWIW, I learned the hard way that UD keeps a flag in the file >header that knows there's an index on the file, then looks for >the index in the same directory. > >Restored a file from a backup tape to another directory, but >UD refused to let me even read the data until I went back and >restored the index. (Yes, I tried to cheat and run >DELETE-INDEX on the restored file, but it failed with an >"index missing" error.) > >So would assume that UD doesn't go looking for the index >unless the "index exists" flag is set in the file header. I >haven't played around with how to trick UD with a bogus index, >as that's just asking for trouble... > >Regards, >Tom ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ----------------------------------------- This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
