RE: [U2] Disappearing Indexes on UniVerse
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/
RE: [U2] Disappearing Indexes on UniVerse
Every problem I have seen here was caused by running index operations while a file was in use. Golden rules: 1. Make sure no-one is using the file 2. REALLY make sure no-one is using the file 3. REALLY, REALLY make sure (you get the idea). fuser -u name of Unix file name This is your friend here - check each file component - data (and the parts if it is dynamic) and index. Block access (permissions if necessary) and then re-check and do your index deletion / creation / rebuild as necessary. If you still have a problem after that (sometimes Herculean I know) effort I'd be very surprised (it does happen tho). Regards JayJay observer of hot air baboons to the cognoscenti --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Disappearing Indexes on UniVerse
Could be that RESIZE isn't re-creating the index pathname in the file's header - which, if true, would be a bug. A workaround would be to follow the RESIZE with a SET.INDEX command to re-inform the hashed file about the location of its indexes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Disappearing Indexes on UniVerse
I have seen where the system automatically creates a new index when it encounters an error. I have two sets of indices right now on my system. We didn't create them so the system must have. I_CUST.HIST.XR00 I_CUST.HIST.XREF I_CUST.MS00 I_CUST.MSTR I've checked the SET.INDEX and the 00 files are the ones being used, the others were the ones we created. We do batch rebuilds of our indices at night so I guess they could have been created then. Resize may do it also. Jerry -Original Message- From: Bernard Lubin [mailto:[EMAIL PROTECTED] Sent: Sunday, July 08, 2007 6: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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[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/