Hi Vera,

    The database reorg message is hard to explain if you are
correct in asserting the tables are not being modified - or having
indexes created upon them.

    You could double check by connecting to the database and
extractiing the modify_date from iitables for each table and index
involved.

    I'm wondering if the problem stems from having two sole
servers. These would need to synchronise their view of what the
database looks like.  I don't know if sole servers need to do more in this
regards than servers on a shared cache. But it seems a reasonable
thing to check if you could configure a shared cache in your system.
You can try an experiment in this regards without affecting the currently
running system. But, first make a copy of the existing config.dat,
protect.dat and config.log in $II_SYSTEM/ingres/files.

Why are you running two servers on II2.0? How many connections are
allowed per server? Perhaps you could bypass the problem altogethor
by configuring a single server with lots more connections.

Martin Bowes
--
Random Titus Quote #28:
God - let me live, and I promise I'll never watch 'The Sound of Music'
that way again