Re: smency>12GB in size

[Chris.Whisonant@xxxxxxxxxxxxx]

I'm not in the office today, but isn't smency a replicated db? You could
end the TM tasks and then you can do dbcache flush, delete, and then
replicate from another server.

Chris Whisonant
803-326-7270
---------------------------------------
Sent using BlackBerry 8700c

    ----- Original Message -----

    From: "Patrick Trapp" [ptrapp@xxxxxxxxxxxx]
    Sent: 10/25/2006 04:30 PM
    To: Lotus Domino on the iSeries / AS400 <domino400@xxxxxxxxxxxx>
    Subject: 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
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.



_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.