Re: [U2] Unidata Index Failure

Doug:

I've had problems in the past when updating indexes while people were 
using the file.  I began using the ONLINE keyword to the CREATE.INDEX 
command and it took several sub-releases before the problems have gone 
away (knock, knock!).

My problem was the indexes I build for everyone's name and address come 
from a central address book file, while this information is used by 
multiple files (e.g. vendors, employees, customers, etc). Even though 
the address book file is indexed, so are all the other files (I don't 
want to look at employees when I'm looking for vendors).  So, the 
solution was to set a flag when a change was made, then delete & rebuild 
the indexes for the file when the next person logged in.  Now, using UO 
and the web, it is checked much more frequently than when on telnet.

Anyway, this process was obviously rebuilding when others were in the 
file.  We occasionally had missing items that required the index be 
rebuilt by hand (at TCL/ECL).  The ONLINE keyword seems to have resolved 
this over the course of several sub-releases.

HTH,

Bill
Untitled Page


------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* U2 Users List <[email protected]>
*Date:* 2/26/2014 7:20 AM
*Subject:* [U2] Unidata Index Failure
> We have be experiencing a Unidata index failure above 7.3.2 on Windows
> 2008/2012.  When we go back to 7.3.2 the problem goes away.  The problem is
> sometimes the index does not get built for certain items.  If we save the
> records or rebuild the index it goes away for a few days to a weeks until
> one or two items show up not in the index.  Our customers report a software
> failure which takes us hours determine that no application software is the
> cause and we rebuild the indexes on the file in question.
>
> We have been working with Rocket Software for about 6 months on this
> problem.  Rocket is reporting to me that no one has reported this issue to
> them.  We thought we ask anyone on the list if they have seen any problem
> that is similar where they have solved the problem by rebuilding the
> indexes.
>
> Regards,
> Doug
> www.u2logic.com
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users