BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-13-2007, 01:51 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Notes state databases - maintenance?

Please Login to Remove!

We run BES 4.1.3 for Domino. W2k3 SP2 and Domino 6.5.4.

I am not a Domino admin. I see each BES user has a Notes "state" database. They seem to keep on growing in size. Is there any maintenance that I should ask our Domino admin to run on a regular basis?
Thanks,
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 06-13-2007, 04:45 PM   #2 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Yes, on a regular basis shutdown the Domno server an run the following from the Domino program directory.

nfixup
nupdall -R
ncompact -c
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 06-14-2007, 09:01 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks!
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 06-18-2007, 09:43 PM   #4 (permalink)
New Member
 
Join Date: Feb 2007
Model: 8900
Carrier: Optus
Posts: 13
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

With the compact it may pay to do a compact -c -i

You dont need to take the server down, just create program documents.

We run these tasks once a week.
Offline  
Old 06-19-2007, 12:43 PM   #5 (permalink)
Thumbs Must Hurt
 
m4ilm4n's Avatar
 
Join Date: Oct 2006
Location: Loony bin
Model: 8800
Carrier: T-Mobile
Posts: 111
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by x14 View Post
Yes, on a regular basis shutdown the Domno server an run the following from the Domino program directory.

nfixup
nupdall -R
ncompact -c
Your admin should set these up as a weekly maintenance job (this is SOP for Domino mail databases anyways), using the server versions of the commands, e.g. "load fixup", et al. No need to shut the server down if it's run as a scheduled Domino task.
Offline  
Old 06-19-2007, 08:02 PM   #6 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

We use program docs to perform those tasks weekly.

It's not the same as doing it with the server down. Since our BES are required to be up 24/7 we only get to do this every 2 months.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 07-13-2007, 09:59 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all the information.
One more question regarding maintenance on the Notes state databases:
now I stop the Lotus Notes service and backup the \state folder every night; I know it is possible to setup Notes replication, so I went to our Notes guru and he told me I'll need to set up replication for each and every state database. So when a new BES user is added, a new step is to setup replication of the new nnnnn.nsf file if I can figure out which one it is.
How do other organizations do it? Do they setup replication or simply backup the State databases (file copy)?
Thanks,
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 07-13-2007, 11:50 AM   #8 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

The state db title is the person's name.

You can also look in the blackberryprofiles.nsf. In the document property of the person look in the StateDBName field.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 07-13-2007, 02:03 PM   #9 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, x14. I can see how to figure out a user's state database.
Do other organizations use Notes replication of state databases for DR purposes, or simply backup the \state folder nightly or however often? We only have 35 users, so it won't be a big deal for us.
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 07-13-2007, 06:26 PM   #10 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Disaster Recovery / Failover?
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 07-16-2007, 05:09 PM   #11 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes Notes replication of not only state Databases but the BES\Folder in general. This all can be stated specifically in the Connection Documents when you create them. Let the DR server initiate the pull and push / do the work so the production bes doesnt have an extra load to work on.
Offline  
Old 07-16-2007, 05:13 PM   #12 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Also, taking down the server every 2 months is not critical to do. BES State Databases and DB's dont take up as much space as a mail file. I would do such extreme tasks on a mail server but not a bes server. Add the tasks to the program documents, perform a reboot every 15-20 days, depending on the reboot schedule and usage of your server and memory and you will be fine.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.