• Compact and transaction logging

    By Oliver Regelmann 1 decade ago

    According to the Release Notes bug NOSS-7XFBPW is fixed by changing compact style to -b when transaction logging is enabled.



    Then I shouldn't see this for a lot of databases when running DominoDefrag:



    29.01.2010 13:59:49 DominoDefrag: mailbox.ntf Started Compact

    29.01.2010 13:59:50 Recovery Manager: Assigning new DBIID for c:\lotus\domino\data\mailbox.ntf (need new backup for media recovery).

    29.01.2010 13:59:50 DominoDefrag: mailbox.ntf Completed Compact. Reduced from 3670016 to 3407872 bytes



    A new DBIID should only get created after a compact -B or -c. Also a compact -c wouldn't reduce the file size.



    Kind regards,

    Oliver Regelmann

    • Happens when structural changes are required

      By Andrew Luder 1 decade ago

      Hi Oliver,

      I've noticed too when I've built a server for the first-time that templates particularly seem to require structural change and therefore a compact -C is performed even when no options (-b) are used. See the table in this R851 admin compact help doc ->



      http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.help.domino.admin85.doc/H_WAYS_TO_COMPACT_DATABASES_OVER.html



      Does DominoDefrag_Compact=1 change the DBII again on the previously effected databases/templates on your server on the next run?



      Regards

    • Happens when structural changes are required

      By Andrew Luder 1 decade ago

      Hi Oliver,

      I've noticed too when I've built a server for the first-time that templates particularly seem to require structural change and therefore a compact -C is performed even when no options (-b) are used. See the table in this R851 admin compact help doc ->



      http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.help.domino.admin85.doc/H_WAYS_TO_COMPACT_DATABASES_OVER.html



      Does DominoDefrag_Compact=1 change the DBII again on the previously effected databases/templates on your server on the next run?



      Regards

    • Compact Options

      By Matthew J Cook 1 decade ago

      What is current behavior of the compact option? -b?



      We run transaction logging and do a weekly compact -B where whitespace is greater than ten percent before the weekend full backup runs.



      Ideally, I would like to combine the weekly compact -B -S 10 with a weekly defrag using DominoDefrag.



      Would it be possible to add functionality to give the admin control over the compact style and parameters using INI parameters so we could run a compact -B -S 10 before the defrag?



      This would be awesome!

      • Not a bad idea - can you please add as a request

        By Andrew Luder 1 decade ago

        Hi Matthew,

        not a bad idea. What I might do in the next release (2.2) is still use DominoDefrag_Compact=1 to maintain current functionality (which is default -b when transaction logging is enabled), but as an advanced option if an administrator puts



        DominoDefrag_Compact=-B -S 10 then it will override the default and call "ncompact.exe" with these options….



        Can you please add this as a request.



        Regards