Home > Domino Tips > Administrator > Database > Scheduled compact of open databases
Domino Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

DATABASE

Scheduled compact of open databases


peter meijdam
06.28.2001
Rating: --- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


Here is the ability to schedule/automate the compact of open databases like names.nsf. log.nsf and statrep.nsf. Do you have to compact statrep.nsf on Saturday because you need to bring down the Notes server? I used WinAT to schedule this on a Sunday morning. I created a small CMD file and scheduled that with WinAT. The files I used are from the Resource Kit (sleep.exe, shutdown.exe, winAT.exe).

- Set the NT Schedule service to start automatically. - Copy Sleep.exe , Shutdown.exe and the WinAT files (all from the NT ResourceKit) to c: as well as the cmd file ntdown.cmd. - Modify the ntstart.cmd file to your specific needs (time delays, path descriptions etc.). - Start WinAT and schedule the file c:ntdown.cmd to run at a certain time.

I tested it (I suggest you do that too) and it works just fine.

I had a problem on the spokes (mailservers). When starting the server, Notes client always prompts me to select the ID file. So when the DOS box opened and the compact wants to start, it prompts me for a password of the ID file as well. On the HUB server (where no users connect to, only other servers for mail routing and replication) I did not have that problem.

I had PcAnywhere on the servers. Therefore, I called in from home sometime before the scheduled task, take over the server console with PcAnywhere, start the client, select the server ID and shut down the client again.

It seems that at working hours, the client sessions disturb the last stored used ID setting. In the notes.ini, I did have the two lines: - KeyFilename = ... - ServerKeyFilename = nlschs01.id



Code

code for the file ntdown.cmd:

c:
cd notes
c:
otes
server -q
c:
cd
c:sleep 10
c:
cd notes
c:
otes
compact d:
otesdatastatrep.nsf
c:
cd
c:sleep 10
c:
cd notes
c:
otes
compact d:
otesdatalog.nsf
c:
cd
c:sleep 10
c:
cd notes
c:
otes
compact d:
otesdata
ames.nsf
c:
cd
c:sleep 10
c:shutdown /L /R /T:60 "Lotus Notes server is rebooting in 1 minute" /Y /C

Rate this Tip
To rate tips, you must be a member of SearchDomino.com.
Register now to start rating these tips. Log in if you are already a member.




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Database
LotusScript code rebuilds corrupted busytime.nsf file
How to move Notes databases off Domino 8 servers and save disk space
Top 10 Lotus Notes/Domino administration tips of 2008
Batch file runs scheduled Lotus Notes database maintenance tasks
Fix and update Lotus Notes documents with limited access
Programmatically replace the design of Lotus Notes databases
Add a program doc to compact Lotus Notes databases automatically
More efficient local Lotus Notes database replication
Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete'
Detect and fix 'Manager' access control list settings in Lotus Notes Domino

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



Domino & Lotus Notes Security Solutions: Authentication, Antispam, Encryption and Antivirus
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts