: 4557 | 108237 | 12276

Autopurge function for databases 
Use this IdeaSpace to post ideas about Domino Server.

: -4
: 2
: 6
: Domino Server / Other
: archive
: Mark Demicoli11692 08 Mar 2012
:
: / Email
Typically, there exist databases which have high informational value but long, even medium term retention may not be desirable.
 
What I'm proposing is for templated databases to be automatically deleted and re-created on a configured interval.
 
The typical scenario is databases like domlog.nsf, which provides invaluable insight into a website's  usage patterns, bad URLs, data on external referers etc.  On a high volume website, this database grows dramatically from day-to-day.  Using the Archiving feature to delete documents is highly resource intensive making it inpractical.
 
LOG.NSF is another example.  Compacting to relinquish unused space  is impossible in this case without a server shutdown.
 
What I propose is a mechanism whereby Domino literally deletes and recreates specified databases on an interval, or on a size threshold, using it's internal mechanics to place a semaphore on such databases for the short procedure.
 
In the case of domlog.nsf, I am aware there are third party tools to analyse textual logging (ie not domlog.nsf), however I believe this functionality is fundamentally important for websites and should be internalised within Domino.



1) Peter Neidhart688 (14 Mar 2012)
So the log.nsf reaches its threshold, is deleted and recreated. And where are my log entries from this morning that I need to analyse a problem?
I feel it is a pretty stupid idea to delete the data. A better solution would be to rename the current database by extending the file name with a suffix like timestamp or a running number and then create a new empty database.
Then you are free to apply your own ways of handling this renamed databases.
2) Mark Demicoli11692 (14 Mar 2012)
Yea good idea - then you could specify a mass storage drive to keep historic databases.
3) Vlad Sh10379 (15 Mar 2012)
Options replication of the properties of a database has the following settings: -> Space Savers -> "Remove documents not modified in the last (days)". Or I understand something wrong?
4) Chris Hudson439 (30 Mar 2012)
There are numerous options to remove old documents from databases. As Vlas suggested, replication settings are one way, With the log.nsf there is also a notes.ini setting to control how big the log gets.

See { Link }
5) Bill Malchisky9249 (24 Aug 2012)
I can see additional problems stemming from older DBs or users that have bookmarks to the DB and then call the help desk when they can't get their data. Unless you are just talking log DBS. Perhaps I am not seeing this, but purging an entire DB just to recreate it? Archiving like on the Journaling which automatically appends a suffix to the filename and makes a new primary DBs would be better.










:
:

Welcome to IdeaJam™


You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>


6
Enable moving Notes workspace page
24
Getdocumentbykey should work using programmable sorted columns
21
Make task functionality with // TODO comments in Java available for LotusScript etc
10
Desktop Policy Settings Doc needs settings for full text index on local mail replicas
20
Add HTTP2 support to Domino
13
Publish a roadmap!
10
Provide a script to benchmark Notes Traveler servers
2
Client Version data is no longer collected after migrating to SmartCloud
3
Javascript editor that flags common errors between serverside & clientside
2
Need ability to import .ics files when using a browser in SmartCloud Notes
5
Add 'Group by Date' view option to iNotes as it is in Notes client
3
Need to be able to see which users do not have their ID file uploaded to the ID Vault in SmartCloud
2
Allow HideWhen on multiply selected outline entries
-1
make it easier to get from view or form to its related XPage
4
SmartCloud user accounts page: Change Jump to Page to Jump to User
25
Option ExtendedSyntax False (or NotesDocumentExtended False)
6
Better Administration Tools for IBM Connection
11
Add functionality in IdeaJam to Automatically create an SPR for the enhancement request with IBM
2
Extend existing webservices of IdeaJam
11
Give Administrators better control over Deletions
4
All-Day reservation in the ressource database
36
allow lists and arrays as return types from functions
20
Enable 'CAPTCHA' for a web form with the click of a button
6
Weekly/Monthly email of new Ideas and Comments from IdeaJam
25
circular use of script libs






IdeaJam developed by

Elguji Software Logo