[ngw] Maximum Physical Database Size

Michael Statman Mike at EMESConsulting.Net
Fri Jun 21 18:31:05 UTC 2019


on the other hand, maybe the msg3.db is actually corrupt and a stand-alone ngwcheck rebuild is in order.


>>> "Marvin Huffaker" <mhuffaker at redjuju.com> 6/21/2019 1:28 PM >>>
This is what I have.. There are only 5 users on the msg3.db database file..   

Userid    (FID / DiskID)  #recs Highest Deleted  Setup DB size (bytes)  (Name [Dept]

aaaaaaaaaaaa (eyf /  3)  64227 (122623)      2      9  	  89509888  (xxxxxxxxxxxxx])
bbbbbbbbbb (qyi /  3)  31180 ( 34851)      2      9  	  59015168  (xxxxxxxxxxxxxx[])
ccccccccccccc (u3u /  3) 138467 (1006528)      5      9  	 238934016  (xxxxxxxxxxxxxxxx])
dddddddddd (1kr /  3)   3744 (  9986)	  0      9   	  5977088  (xxxxxxxxxxxxxxx])
eeeeeeeeeee  (ato /  3)  47573 (119263)      0 	 8 	   65929216  (xxxxxxxxxxxxxxxxxxx]


What are the numbers in the Parenthesis under #recs Highest Deleted?	 These 5 accounts do not look like they could consume 4GB of space in the msg3.db file.   Am I missing something? 
>>> "Michael Statman" <Mike at EMESConsulting.Net> 6/21/2019 12:45 PM >>>
2014r2 doc states: "User databases (userxxx.db files) might contain large numbers of contacts and folders. Contacts and folders affect the size of the user databases, which have a maximum size of 4 GB, but do not count against the mailbox size for users."   I didn't find it stated as such, but presumably this is a hard limit that applies to the message db as well.

As to resolution... find out which users are associated to msg3.db ( see e.g.  https://support.microfocus.com/kb/doc.php?id=7013421 ) and then take a look at those mailboxes in particular for cleanup.  I'd suspect just one or maybe a couple users are the culprits.



-Mike
>>> "Marvin Huffaker" <mhuffaker at redjuju.com> 6/21/2019 12:07 PM >>>
Is there a hardset limit on the maximum physical size of the message databases?  Either in the ofmsg or ofuser folders?  (I'm not talking user quotas, I'm talking raw database files).

In all the years I've worked with GroupWise I've never run into this situation.   I have one file in the ofmsg folder that is 4GB and that seems to be the problem.. So is it a hardset limit of 4GB?   How would I go about resolving this?  I think I could probably do a reduce expire to get some temporary relief but it doesn't seem like a long term fix.

Here's the error:

"Error that occurred: C05C-The Database has reached its maximum size"


Look at the file below "msg3.db" is 4.0GB in size..



mdlxgw01:/srv/gwdata/bannerpo/ofmsg # ls -alh | grep G
total 103G
-rw-r--r--  1 root root 1.1G Jun 21 12:01 msg120.db
-rw-r--r--  1 root root 1.3G Jun 21 12:02 msg136.db
-rw-r--r--  1 root root 1.7G Jun 21 12:01 msg148.db
-rw-r--r--  1 root root 1.1G Jun 21 12:03 msg152.db
-rw-r--r--  1 root root 1.1G Jun 21 12:04 msg178.db
-rw-r--r--  1 root root 1.1G Jun 21 11:52 msg211.db
-rw-r--r--  1 root root 1.5G Jun 21 11:57 msg246.db
-rw-r--r--  1 root root 4.0G Jun 21 12:04 msg3.db



More information about the ngw mailing list