Charles, The only explanation that we think could have accounted for this is that a user had restored a file, using uvrestore. When they restored the file, they restored it under another file name. As we all know the index location is stored in the header of the file. When we run our resize procedure, we also delete files that are not identified as standard files.
So that meant that all backuped files were deleted. Hence it also deleted the associated indices. We have since changed our "UVRESTORE" procedure to ensure that the header of the file is reset, and are also checking the header of the file prior to deleting a file. Since changeing the procedure, we have not had any reported cases of disappearing indices. So it looks like our disappearing indices were a result of an incorrect uvrestore procedure. Rgds ---------- Original Message ---------------------------------- From: "Stevenson, Charles" <[EMAIL PROTECTED]> Date: Fri, 14 Sep 2007 19:13:16 -0400 >Did you find the answer to this puzzle? >Just curious. I'll bet other list members would like to hear it, too. > >Thanks, >Chuck Stevenson > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lubin >Sent: Sunday, July 08, 2007 4:21 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] Disappearing Indexes on UniVerse > >I have several instances of indexes disappearing. The symptom is as >follows: > The index file is still present at unix, but it looks like it has been >re-initialised (It looks like someone has manually deleted the index, >then re-issued the CREATE-INDEX without running the BUILD.INDEX) This >seems to happen after we have run a RESIZE on the system. We do not >disable the index prior to running the RESIZE command. But there have >been instances of the index just disappearing when no RESIZE was done on >the system. > Our normal users do not have access to TCL, and no programs issues the >"DELETE-INDEX" command. The indexing of a file can only be done by the >system administrator. > > >Has anyone experienced similar situation? If so, how did you resolve >it? > >Any help/suggestion would be greatly appreciated. > > >Bernard Lubin >Development Department >Reynolds and Reynolds ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
