A database has reached the limit of 64GB with the error “Database has grown too large; use File New Replica to recreate your file with larger capacity.”
I tried fixup , compact , new replica, notes lotuscript agent to get the documents, but nothing worked. The database does not open.
What I can do ?
If i copy database on linux it might open?
Subject: no guarenteed fix
There is usually no Fix for this issue. You should restore the last good backup for the file, and then trim out the file so that you do not run over the 64gig limit. You can use DAOS to shrink the file size, but, if DAOS is used, then when you try to restore the file from DAOS, it will exceed the limit, so you must still remoe documents from the file. You can create an Archive as well to move ome documents.
Subject: No sure fix.
First off, I would make sure you have a backup of the database before you do anything.
Then you can try:
Remove all the views indexes from the database using compact -D (https://www.ibm.com/support/knowledgecenter/en/SSKTMJ_9.0.1/admin/tune_compactoptions_r.html https://www.ibm.com/support/knowledgecenter/en/SSKTMJ_9.0.1/admin/tune_compactoptions_r.html)
Purge all deletion stubs (https://www-01.ibm.com/support/docview.wss?uid=swg21095683 https://www-01.ibm.com/support/docview.wss?uid=swg21095683)
Enable LZ1 compression, design compression and document compression using compact -c -v -n -ZU
Enable DAOS using compact -c -daos on
Move the view indexes to disk using compact -c -nifnsf (must have it enabled first Daniel Nashed's Blog http://blog.nashcom.de/nashcomblog.nsf/dx/current-information-about-nifnsf.htm)