Hi Stephen,
Is there any way to shrink/compact the database of Intermapper.
The size of the database can be reduced by using more restrictive data
retention policies. You'll want to make sure that the server-wide (in
Server Settings, on the Database Server pane) and map-wide (in Map
Settings) retention policies are set to something other than 'Forever'.
Also, if your IM server was runing IM 4.6 or earlier at some point, then
any datasets created back then were given a policy of 'IM46Charts' when
you upgraded. By default, IM46Charts keeps data forever, to match the
behavior of 4.6 and earlier. You can use the 'Policies' page in the IM
DataCenter web interface to edit IM46Charts, so it keeps raw data for
only a few days, or whatever matches how you intend to use it.
Keep in mind that IMDatabase is just a copy of IM's data. It's an
optional feature that provides long-term storage, a way to combine
data-streams from multiple IM servers, and the ability to query that
data via SQL. IM's charts, i.e. what you see when you click on a value
in a device's status window, do not load from IMDatabase, and continue
to work even if IMDatabase is not running.
David
--
David Schnur
Dartware, LLC
http://www.dartware.com
____________________________________________________________________
List archives:
http://www.mail-archive.com/intermapper-talk%40list.dartware.com/
To unsubscribe: send email to: [email protected]
