Defrag and optimize Domino databases managed by XPages mobile solution
Hello Andrew, let me first say many thanks for the tool you have written. Anyway it seems to be that the tool is not really working for Dir- or DBLinks or I am doing something wrong. If I defrag the Domino data partition everything is fine but files behind a dirlink or dblink will not defragment. I have tried several thinks: Load DominoDefrag mail1 Load DominoDefrag mail1.dir Load DominoDefrag "mail1.dir" Load DominoDefrag G:\Lotus\Domino\Data\Mail1 Nothing helped. The log shows that the files have been defragged but do not show any status about the fragmentation status before and after the defragmentation (see log extraction below). The defragmentation of files behind a DirLink goes very fast and checking the defragmentation status before and after the DominoDefrag does not show any changes. Note that I have a server with approx. 1800 users with a lot of partitions which were assigned to the Domino Data directory via DirLinks and DBLinks. Can you help here or am I doing something wrong ? Best regards Manfred log extraction: > load dominodefrag "mail1.dir" 05.05.2010 22:26:46 DominoDefrag: v2.4.2 (26 Apr 2010 C++ version) 05.05.2010 22:26:46 DominoDefrag: Initializing… 05.05.2010 22:26:46 DominoDefrag: Running on Windows 5.2.3790.Service Pack 2 05.05.2010 22:26:47 DominoDefrag: Running on Domino 267 05.05.2010 22:26:47 DominoDefrag: Using contig.exe 1.55 05.05.2010 22:26:47 DominoDefrag: 32bit version running on 32bit platform 05.05.2010 22:26:47 DominoDefrag: Directory -> mail1.dir 05.05.2010 22:26:47 DominoDefrag: Process Full Text Index -> On 05.05.2010 22:26:47 DominoDefrag: DominoDefrag_MinuteInterval parameter not found. Task will only run once 05.05.2010 22:26:47 DominoDefrag: Run Time -> 600 05.05.2010 22:26:47 DominoDefrag: Start Point -> 500 05.05.2010 22:26:47 DominoDefrag: Verbose Logging -> On 05.05.2010 22:26:47 DominoDefrag: Compact Database Before Defrag -> Off 05.05.2010 22:26:47 DominoDefrag: Summary Email Address -> manfred.schlindwein@sobis.com 05.05.2010 22:26:47 DominoDefrag: Transaction Log -> Off 05.05.2010 22:26:47 DominoDefrag: DAOS -> Off 05.05.2010 22:26:47 DominoDefrag: Performance Check -> On 05.05.2010 22:26:47 DominoDefrag: Initialization complete 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.nsf Performance before defrag took 8235 milliseconds to collect 18679 documents 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.nsf Started Defrag 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.nsf Completed Defrag 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.nsf Performance after defrag took 156 milliseconds to collect 18679 documents 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.nsf Performance gain is 8079 milliseconds 05.05.2010 22:26:56 DominoDefrag: mail1\AMIRALLE.ft Directory does not exist 05.05.2010 22:27:45 DominoDefrag: mail1\ATITZMAN.nsf Performance before defrag took 48641 milliseconds to collect 69271 documents 05.05.2010 22:27:45 DominoDefrag: mail1\ATITZMAN.nsf Started Defrag 05.05.2010 22:27:45 DominoDefrag: mail1\ATITZMAN.nsf Completed Defrag 05.05.2010 22:27:46 DominoDefrag: mail1\ATITZMAN.nsf Performance after defrag took 937 milliseconds to collect 69271 documents 05.05.2010 22:27:46 DominoDefrag: mail1\ATITZMAN.nsf Performance gain is 47704 milliseconds 05.05.2010 22:27:46 DominoDefrag: mail1\ATITZMAN.ft Directory does not exist 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.NSF Performance before defrag took 22907 milliseconds to collect 44626 documents 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.NSF Started Defrag 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.NSF Completed Defrag 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.NSF Performance after defrag took 454 milliseconds to collect 44626 documents 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.NSF Performance gain is 22453 milliseconds 05.05.2010 22:28:09 DominoDefrag: mail1\BDOTTER.ft Directory does not exist
Can't reproduce as yet… This is what I've just done…. On My R655 Domino server running on Windows 2003 my configuration is program files d:\lotus\domino and data files d:\lotus\domino\data. I just copied the file "lotuskb.nsf" into the directory c:\kb and created a file called "d:\lotus\domino\data\testlink.dir" with simple contents of c:\kb Here's my output below: > load dominodefrag testlink.dir 06/05/2010 07:57:19 PM DominoDefrag: v2.4.2 (26 Apr 2010 C++ version) 06/05/2010 07:57:19 PM DominoDefrag: Initializing… 06/05/2010 07:57:19 PM DominoDefrag: Running on Windows 5.0.2195.Service Pack 4 06/05/2010 07:57:19 PM DominoDefrag: Running on Domino 200 06/05/2010 07:57:19 PM DominoDefrag: Using contig.exe 1.55 06/05/2010 07:57:19 PM DominoDefrag: 32bit version running on 32bit platform 06/05/2010 07:57:19 PM DominoDefrag: Directory -> testlink.dir 06/05/2010 07:57:19 PM DominoDefrag: Process Full Text Index -> On 06/05/2010 07:57:19 PM DominoDefrag: DominoDefrag_MinuteInterval parameter not found. Task will only run once 06/05/2010 07:57:19 PM DominoDefrag: DominoDefrag_RunTime parameter not found. No time limit on task execution 06/05/2010 07:57:19 PM DominoDefrag: DominoDefrag_StartPoint not found. Defaulting to 2 06/05/2010 07:57:19 PM DominoDefrag: Verbose Logging -> On 06/05/2010 07:57:19 PM DominoDefrag: Compact Database Before Defrag -> On 06/05/2010 07:57:19 PM DominoDefrag: Compact -b will occur as Transactional logging is enabled 06/05/2010 07:57:19 PM DominoDefrag: Summary Email Address -> World Administrator 06/05/2010 07:57:19 PM DominoDefrag: Summary Email From -> spider.man@acme.com 06/05/2010 07:57:19 PM DominoDefrag: Transaction Log -> Off 06/05/2010 07:57:19 PM DominoDefrag: DAOS -> Off 06/05/2010 07:57:19 PM DominoDefrag: Performance Check -> On 06/05/2010 07:57:19 PM DominoDefrag: Initialization complete 06/05/2010 07:57:31 PM 06/05/2010 07:57:32 PM DominoDefrag: c:\kb\LotusKB.nsf Started Compact 06/05/2010 07:58:28 PM DominoDefrag: c:\kb\LotusKB.nsf Completed Compact. Reduced from 482869248 to 436994048 bytes 06/05/2010 07:58:29 PM DominoDefrag: c:\kb\LotusKB.nsf Performance before defrag took 972 milliseconds to collect 22775 documents 06/05/2010 07:58:29 PM DominoDefrag: c:\kb\LotusKB.nsf Started Defrag 06/05/2010 07:58:31 PM Admin Process: Searching Administration Requests database 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf File Size -> 436994048 bytes 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf Before Fragments -> 40 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf After Fragments -> 1 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf Completed Defrag 06/05/2010 07:58:46 PM DominoDefrag: c:\kb\LotusKB.nsf Performance after defrag took 932 milliseconds to collect 22775 documents 06/05/2010 07:58:46 PM DominoDefrag: c:\kb\LotusKB.nsf Performance gain is 40 milliseconds 06/05/2010 07:58:46 PM DominoDefrag: c:\kb\LotusKB.ft Directory does not exist 06/05/2010 07:58:46 PM DominoDefrag: Total databases to be processed -> 1 06/05/2010 07:58:46 PM DominoDefrag: Total databases defragged -> 1 06/05/2010 07:58:46 PM DominoDefrag: Total databases partially defragged -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total databases already defragged -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total databases below start point -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total databases with not enough disk space to defrag -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total databases with no access to defrag -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total databases with performance gain -> 1 06/05/2010 07:58:46 PM DominoDefrag: Total databases compacted before defrag -> 1 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes defragged -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes partially defragged -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes already defragged -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes below start point -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes with not enough disk space to defrag -> 0 06/05/2010 07:58:46 PM DominoDefrag: Total full-text indexes with performance gain -> 0 06/05/2010 07:58:46 PM DominoDefrag: Termination complete 06/05/2010 07:58:47 PM Router: Message 0036D19D delivered to World Administrato r/ACDC
Hi Andrew, note that I do not get any information regarding the fragmentation status as it look like in your example log: 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf Before Fragments -> 40 06/05/2010 07:58:45 PM DominoDefrag: c:\kb\LotusKB.nsf After Fragments -> 1 This information is not shown during the defragmentation. I also checked the defragmentation status of the files before and after the DominoDefrag and no changes were made. Even if the StartPoint parameter is set to 500 it should defragment approx. 230 files in this directory having a fragmentation status from 500 to 10.000. If you need more information on this just let me know. The server is a Domino Server Version 7.04 FP2. We are not allowed to upgrade to 8.5 at the moment. Maybe you will have another idea later :-) Anyway many thanks for the fast reply on this. Best regards Manfred
Hello Andrew, found out the following: Wenn using: Load DominoDefrag mail1.dir => is not working Load DominoDefrag G:\Lotus\Domino\Data\Mail1 => is not working Load DominoDefrag G:\Lotus\Domino\Data\Mail1*.nsf => is not working Load DominoDefrag G:\Lotus\Domino\Data\Mail1\mschlind.nsf => is working but useless if you want to perform the defragmentation on the whole directory Hope this information helps to get the problem resolved ? Best regards Manfred
Yes it does help - thanks. I think I've identified your bug. Are you able to send me your email address so I can send you a test version over the next few days?
Hi Andrew, my eMail address is manfred.schlindwein@sobis.com. Think that it would be good in your programm to first check if the database or directory is a link and then use the path behind of that to defrag the regarding database(s) because we also do have DirLinks where the target directory contains also database links which then addresses the databases which again are in to another directory. Looking forward to test your new version. Many thanks for your help Best regards Manfred