One of our R and D databases now has over 2 million documents.  The database is not utilizing transaction logging.

In the Notes Client, when attempting to select all documents in some of the views in the database, we are seeing the error "Unable to extend an ID Table - insufficient memory".

I do not see this error for all views.  For example, I can successfully select all documents in a view of all documents by UNID, but then I see the error for other views containing a subset of 1 million documents or 500,000 documents.  I haven't seen this error for views containing less than 100,000 documents.

We've also seen this error in the Domino Server's Log file (log.nsf) after we've run a Java agent to update a data field on a large set of documents.  After this, one of our web applications fails to successfully search / display information from some views of documents.  At this time we have not run this agent against the large database in question, and we are not seeing any errors in the web application.

I have seen older Notes / Domino forum posts for this error associated with compacting a database.  One of the causes of this error is said to be a high number of deletions.  This database only has about 400 deletions, so I question if this is an issue with our database.

In years past it has been suggested to make a non-replica copy from a good backup.  We have gone this route but we still see the problem.

Also, there has been a recent reference to SPR JPAI6W8KUJ indicating that there is a new compact -REPLICA option for 9.x or for 8.5.3 FP3. We have tried this new style of compact without success.

First, I understand that a Domino database has multiple ID tables.  Are ID tables created for each view, or for sets of documents based on form type? Is there any way to gather any information about the ID tables in the database and which one(s) might be bad?

Second, is there any additional debugging or information gathering that I should be doing?

Thanks.