HI All,We are having problem in one of our databse.The size of the database is more than 2 Gig now.We cant able to open databse because it says its corrupted but when we run load compact with -B it works ok.we assume its the size effecting that database.
Is there Database limit in Lotus Notes? If so how much or its something else
we are using 6.5.4 version of Lotus Notes.Can we update our Lotus Notes?
Please someone advice and thanks in advance
Subject: Size limit in application 2 gig Iseries 400
I am not sure if there is a size limit. But my experience is that once the size crosses 1.5 or 2.0 GB or so, things become painful. View indexing, replication etc takes much more time than a small sized database.
Your operating system too will find it difficult marshalling such a big sized file.
Oracle supports very large database, but then it maitains its own raw file system. Because Oracle knows OS will cripple handling large files.
In Domino.Doc (Lotus Document Management System) it spawns a new database when size crosses 500 MB (configurable).
It’s good if you can think of Archiving old documents into some other db. Or categorize the documents and put it into different child databases.
Regards,
Litty Joseph
Subject: Size limit in application 2 gig Iseries 400
I worked in an environment which had a 40 GB db hosted by Domino on iSeries, and have such files much larger than 2 GB on other platforms as well.
Are you using BRMS for backups? If so you may want to look into BRMS settings for working with large files as file locking by the backup program may be causing the issue as it can conflict with Domino. I can’t remember exactly but I think there’s a BRMS setting for max backup time per file and max file size which can be adjusted.
Subject: Size limit in application 2 gig Iseries 400
Ben Langhinrichs put together a table of Domino limits: IBM Lotus Notes/Domino Limits
Domino’s built-in file size limit is 64GB or the OS limit. Both OS/400 V5R3 and i5/OS V5R4 will let you have a file up to 128GB. If you are accessing the file through QDLS, which would only be used by an external connection and not Domino, the limit is 4GB.
Check the owner of the database and make sure it’s QNOTES. The code page also should be set to something specific, but I don’t recall exactly what. Check something like names.nsf or events4.nsf and set it so it’s the same.