Compacting Databases Via Operating System

We have a heavily used application which is also available on the web making it hard to keep everyone out of the application when you need to compact the database (Roll on R5). You can however compact a database using the ncompact commmand with the notes server task shut down. On Windows NT run a command window and go to the winnt directory (or wherever the notes.ini resides) type the command ncompact.exe <database path and name>...

and press return. You can also add switches to the command such as -m switch which I have used to increase the database to the maximum quota size of 4Gb. Don't use quotes when typing the command Eg: ncompact.exe doc/log.nsf -m Monitor the progress of the compaction by opening explorer and watching the .tmp file that the compact process creates. When finished the .tmp file becomes the database and the original .nsf is deleted.

This was first published in November 2000
This Content Component encountered an error

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close