How Do I Reduce The Size of STATREP.NSF

[PhilNic]

I need to reduce the size of my STATREP database (Notes 4.6)
Does anyone know how I go about doing this ?

The only hint I have found so far is to set the last modified date in replication, but I do not want a smaller replica I want the main server copy of STATREP to be smaller.

Any ideas would be gratfully received.

 

[AmazingDominik]

Hi,

All replica's in Notes are equall. There is no "main" replica and "sub" replica's.

That means you can even set replication settings on a replica that does not replicate!

Just go to the replication settings of your database and check the option "remove documents not modified in the last" and enter a number of days. 14 days for example.

It is possible that in R4 the name of this setting is a bit different. Too long ago for me to remember, but it should be similar.


This will immediatly delete all documents older then 14 days, and keep it that way.



Kind regards,

Dominik Malfait
dominik@amazingit.com

http://www.amazingit.com

 

[PhilNic]

Thanks for that Dominik, that was a good help.
But I am still not completely there.

My STATREP is now down to 10% usage but still takes up it's original disk space. I can not compact the database as it always appears to be in use ( I assume by the system itself) .

So how can release the space I just freed up ??

Answer this and I truely will consider you to be "Amazing" !!!

 

[AmazingDominik]

Very easy: you can compact the database while it is in use.
You need to do a "copy-style" compacting that allows access. Look up the options for the compact command in the Administration help.

On the other hand you can stop the statistic collector task on the server and that will also make the database available for compacting. After compacting you can start the task again.

Third way:
Stop the server and run the ncompact.exe command line version of compact to do the job! ("ncompact statrep.nsf&quot

It is possible however that the houshold tasks during the nightime will compact the database for you. I am not sure about this one. If so, then tomorrow morning it should be compacted.

Let me know if you need more help on this.


Kind regards,

Dominik Malfait
dominik@amazingit.com

http://www.amazingit.com

 

[PhilNic]

OK I admit I must have my dim head on today, but I can not find out how to stop the statistic collector task on the server.

I have ploughed through all the help files I can find, but no joy. I guess I must just be looking in the wrong place.

 

[AmazingDominik]

Hi again,

Type the following in the console:

tell router quit
tell collect quit
tell repoter quit
tell stats quit

This will stop all tasks that collect statistics and reports that can be stored in the database. We also stop the router in case the database is used as mail-in database.
Optional you can also stop the Events task:
tell event quit

IMPORTANT: maybe not all of these tasks are running on your server. Try to observer which one do not run, so you do not start them later on.

now type the following

load compact statrep.nsf -B

This should compact the database. If you get an error that the database is still in use, or nothing happens try the following:

load compact statrep.nsf -c -L

IMPORTANT: all arguments for the copact command are CaSe sensitive!

Now start everything that was stopped again:
(remember that you might not need to start everything I list here)

load router
load collect
load reporter
load stats
load event

Or to do it in 1 time:

restart server

But this one will of course bring your server down for 1 or 2 minutes....

Note: everything I list here works on a R5 server. I do not have an R4 server anymore here to check, but most of it should be the same!

Hope this makes it clear!




Kind regards,

Dominik Malfait
dominik@amazingit.com

http://www.amazingit.com

 

[PhilNic]

Many thanks for your help Dominik. My stats file is now down to a more acceptable size, and the world is at peace again.

I ended the services as you said, but got error messages on both the load compact line, so I ran ncompact from a command line, as per your previous posting, and then restarted the services.

All nice and clean.

Thanks again.