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/