SearchDomino.com September 19, 2001 Admin Tip: Simple freetime (busytime.nsf) corruption fix ================================================= Sponsored By: RPR Wyatt ================================================= ACL Watchdog with bite! Essential Tools (ET), Lotus Beacon Award Winner for best Administration Utility, collects comprehensive user, ACL, and database information in a single central location. Find your security holes at a glance and correct them globally by submitting a simple point and click document or by creating an ACL Enforcer. Download a ScreenCam or sign up for a personalized Sametime demo at http://www.rprwyatt.com/RPRWweb.nsf/frmsetET?OpenFrameSet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ================================================= TITLE: Simple freetime (busytime.nsf) corruption fix This tip was submitted by Gerard Volker, a system analyst in Columbus, Ohio. In Notes 5.x, Calendar & Scheduling issues have presented us with several opportunities to develop workarounds to fix customer issues. One such issue is that the freetime search -- checking available time for a person or a resource -- doesn't always return the proper data. After troubleshooting these issues for a while, we decided to delete the busytime.nsf database daily, in the middle of the night, and have it recreate itself by stopping and restarting the SCHED server task. This solution has reduced the number of C&S issues we have reported from our clients, and might also work in your environment, but be sure and test it prior to implementation. CODE: No LotusScript was used in this implementation, just simple program documents and a batch file on the Windows NT or 2000 server. For different platforms (such as UNIX or AS/400), you would need to write a simple batch file to accomplish the same tasks as the Windows .bat file. 1) Create a text file with the following content: del <drive path of Notes Data busytime.nsf>, e.g. del c:\notes\data\busytime.nsf Save and name the file delbt.bat 2) Copy the file to your Notes Server CODE directory (such as C:\NOTES or D:\NOTES). 3) Add program documents to accomplish the following tasks (below). In our environment, the tasks run M-F, the first starting at 4:30AM and the rest all 1-2 minutes later (per task). a. Shutdown calconn (4:30AM): turns off Calendar Connector to prevent access of busytime.nsf from another server: nserver -c "tell calconn quit" b. Shutdown sched (4:30AM): turns off the scheduler tasks to free the busytime.nsf database nserver -c "tell sched quit" c. Dbcache flush (4:32AM): clears db cache of pending queue to make all databases available, allows database to be deleted nserver -c "dbcache flush" d. Create a program document to run the batch file to delete busytime db (4:34AM) nserver -c "load delbt.bat" e. Restart calconn: Restarts the Calendar Connector task (4:35AM) nserver -c "load calconn" f. Restart sched (4:37AM): Restarts the Scheduler Task -- when busytime.nsf isn't found on the server, it automatically creates a new database. nserver -c "load sched" END CODE That's it! Be sure and test in your environment -- if the tasks don't restart properly you may need to adjust the times of the program documents. Enjoy! http://searchdomino.techtarget.com/tip/1,289483,sid4_gci761667,00.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ================================================= NEWLY POSTED ADMINISTRATOR TIPS: ================================================= We posted 3 new administrator tips last week. Thanks for your tips and keep them coming! Desktop category: http://searchdomino.techtarget.com/tipsIndex/0,289482,sid4_tax283823_alpD_idx0,00.html [1] Find out what version of Notes you are running Mail category: http://searchdomino.techtarget.com/tipsIndex/0,289482,sid4_tax283826_alpD_idx0,00.html [1] Restore "missing" folders Server category: http://searchdomino.techtarget.com/tipsIndex/0,289482,sid4_tax283832_alpD_idx0,00.html [1] Comparing server differences See all searchDomino administrator tips here: http://searchdomino.techtarget.com/tips/0,289484,sid4_tax283819,00.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ================================================= JULY'S TIP PRIZE WINNER: ================================================= Congratulations to our July tip winner, Aram Hovhannisyan, and now our newest Dog Pound member! Aram won the Olympus Stylus Epic Zoom 80 QD CG Camera. Grand Prize Tip: Aram Hovhannisyan Rollover buttons and @formulas http://www.searchDomino.com/tip/1,289483,sid4_gci753493,00.html Second place: Ruth Inman Migrating your (Notes) browser address book into Notes http://www.searchDomino.com/tip/1,289483,sid4_gci753406,00.html Third place: Carol Lee Make the hidden design visible http://www.searchDomino.com/tip/1,289483,sid4_gci754376,00.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ WIN SEPTEMBER'S TIP PRIZE: Submit an administrator tip in September and you could win a Pen Cam Mini Digital Camera. This mini digital camera is no bigger than a cigar lighter; the Pen Cam is tiny but a mighty 5 inches tall. Take quality pictures with this sleek device. Stay tuned next week when we announce August's tip prizewinner. http://searchdomino.techtarget.com/tipsPrize/0,289492,sid4_prz764172_cts764173,00.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ================================================= FEATURED BOOK ================================================= Lotus Domino administration in a nutshell By Greg Neilson Domino is one of the most effective platforms for developing and deploying e-business applications, allowing new communities of developers to enjoy its collaborative capabilities. With over 55 million seats worldwide, Domino already provided a strong foundation for messaging and web applications, and the release of R5 builds on that to make Domino easier to use than ever before. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog%5Fname=Books&product%5Fid=1565927176&partner_id=60 ================================================= Disclaimer: Our tips services and online tips exchange are a way for you to learn from other IT professionals and share technical advice and expertise with your peers. Techtarget.com provides the infrastructure to facilitate this sharing of information. However, we can't guarantee the accuracy and validity of the material submitted. You agree that your use of the searchDomino.com tips services and your reliance on any questions, answers, information or other materials received through searchDomino.com will be at your own risk. ================================================= NOTIFY US WITH FEEDBACK ================================================= Send us your tips feedback! Cast your vote and send us your tips comments. If you have vital code information or other comments you'd like to add to one of our online tips, send your comments to [EMAIL PROTECTED], and we'll add your User Feedback to the online tip! ================================================= If you would like to sponsor this or any TechTarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] ================================================= If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDomino.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
