An exciting bit of info for UniVerse users out there! I just got confirmation from [EMAIL PROTECTED] that the ONLINE option of BUILD.INDEX in UniData appears as the CONCURRENT option in UniVerse as of 10.1 It has yet to make it into the standard documentation however.
(Disclaimer: It's possible that I'm the last one on the planet to learn of this.) Perry Taylor Zirmed, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Thursday, February 08, 2007 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Index Problem > I have not seen a problem since about UV9.6. 4 corrections to my own claim. There are 3 common sources of index corruption, all user-related: 1. Indexing a computed value, whose calculation does not depend ENTIRELY on the record being written. E.g.: - trans(), xlate(), T-correlatives - date(), time() - @variables such as @logname, @date, @who - SUBR(), where the subroutine READs anything. 2. Copying the primary data file using OS-level or Non-UV-aware utilities, but not correcting the new (copy) file header's pointer to the original's index files. Updates to the copy will be indexed on the original! Use SET.INDEX INFORM & SET.INDEX TO NULL on the _copy_ of the data file. 3. Updating the index files explicitly. Usually happens when there is a voc pointer to the .../I_fname/INDEXnnn type-25 file. There is a 4th that I consider it a long-standing bug. It is known to IBM. And to Informix, Ardent, & Vmark before them. 4. CNAME will not update any index on part of an id, e.g., FIELD( @ID, '*', 1 ). I was told CNAME uses an i/o mechanism different from every other update. cds ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
