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:* dave...@gmail.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
