I agree. I've seen this when a user has moved an index file around at the
OS level and there is a mismatch between the number of indexes recorded in
the header of the primary file and the actual number of indexes in the
index file. The advise to DELETE.INDEX fn ALL, and recreate and rebuild is
appropriate.
Wally Terhune
Manager - U2 Advanced Technical Services
IBM Information Management Solutions
Tel: 303.294.4866 Fax: 303.294.4832
[EMAIL PROTECTED]
www.ibm.com/software/data/u2/support - Open, Query, Update, Search -
Online!
"Alfke, Colin"
<[EMAIL PROTECTED]
> To
Sent by: <u2-users@listserver.u2ug.org>
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
RE: [U2] [UD] disconnected index
03/14/2005 10:14
AM
Please respond to
u2-users
I've only seen this when moving around files at the OS level.
I certainly wouldn't trust this index and would delete and rebuild it.
Colin Alfke
Calgary, AB
>-----Original Message-----
>From: Josh Marcus
>
>Has anyone ever seen a UniData file have its index become disconnected
>from the data file? I have a file that used to have indexes. I can
>verify that because I have a LIST.INDEX printout from a few months ago
>showing them. However, they are no longer in place. When I run
>LIST.INDEX against the file, it reports there are none.
>
>I checked at the Unix level and there was still an index file
>(X_TX.ARCHV) next to the data file.
>
>Not knowing what else to do, I tried to add one of the indexes back to
>the file. I got this:
>
>CREATE.INDEX TX.ARCHV TXA.CAMPAIGN
>"TXA.CAMPAIGN": can not create multiple indices on same location
>
>After that, the index showed up in LIST.INDEX. Furthermore, LIST.INDEX
>tells me the index is built, and selections on the file behave like
>there are built indexes in place.
>
>Anyone have any ideas as to what's going on here? Should I be
>concerned?
>
>The file in question is a dynamic file, if that is of any relevance.
>
>System info: UniData 6.0.11 on Tru64 Unix 5.1a.
>
>Thanks,
>Josh Marcus
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic03337.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
