[ngw] Maximum Physical Database Size

Michael Statman Mike at EMESConsulting.Net
Fri Jun 21 17:58:04 UTC 2019

Agreed, the 5 users themselves probably don't account for the 4Gb, since it's just the 2k of sent items. Unless an account was hijacked by a spambot.

Received items don't go into the user's associated db, they go into the sender's. You said multiple post offices. So that means messages from a user on _another_ post office, who is associated to msg3.db there, will get placed into msg3.db on this post office, regardless of to whom they are addressed. ("Incoming messages from users in other post offices are stored in the message database that corresponds to the message database assigned to the sender in his or her own post office.")   But if that was the case, I might expect to see msg3.db large on a 3rd post office.  Not sure how inbound internet messages get assigned to a msg.db.

Perhaps another approach would be gwcheck against the msg3.db with the SUBJECTLIST option which might allow you to identify a block of messages that could be removed (using SUBJECTPURGE), or otherwise provide a direction.


>>> "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.

>>> "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