Re: smency>12GB in size

I'm guessing from your question that the size has not improved.  The 
deleted documents in the show command might be deletion stubs rather than 
full documents that were deleted.  I think I've seen that the life of the 
deletion stub is determined by the number of days in the replication space 
saver properties.  But they shouldn't be very large, so I'm wondering if 
the extra size you are looking at is the views.  It would be interesting 
to see how large the Patternfile view really is, for example.

Patrick




rob@xxxxxxxxx 
Sent by: domino400-bounces+ptrapp=nex-tech.com@xxxxxxxxxxxx
10/25/2006 03:23 PM
Please respond to
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>


To
Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
cc

Subject
Re: smency>12GB in size






I deleted the replication/save conflicts.

How do I get rid of the deleted records?

At the domino console I ran:
dbcache flush
load compact smd/smency.nsf
10/25/2006 16:08:53   Compacting smd/smency.nsf (ScanMail Update Database)
10/25/2006 16:12:03   Compacted  smd/smency.nsf, 0K bytes recovered (0%)
10/25/2006 16:12:03   Database compactor process shutdown 
sho database smd/smency.nsf
ScanMail Update Database
Document Type                            Live         Deleted
    Documents                            25           265
    Info                                 1            0 
    Form                                 45           0 
    View                                 10           0 
    Icon                                 1            0 
    Design                               1            0 
    ACL                                  1            0 
    Help Index                           0            0 
    Help                                 1            0 
    Macro                                67           0 
    Shared Field                         3            0 
    Repl. Formula                        1            0 
    Private Design                       0            0 
    Unknown                              52           0 
View sizes                               Bytes 
    (Spyware)                            42,192 
    (Patternfile)                        132,904 
    (SpamDB)                             67,368 
    All Docs                             91,944
    (Template)                           42,192
    smency                               0 
    (SpamEng)                            43,216
    (ScanEngineType)                     42,192
    (ScanEngine)                         42,192
    (Program)                            42,192
sho users 
no names listed for that database.

Rob Berendt