![background image](http://html1.mh-extra.com/html/patton-electronics/foresight-6300-nms/foresight-6300-nms_administrators-reference-manual_4040070137.webp)
Adding Policies
137
FS6300 NMS Administrator’s Reference Guide
10 • Managing Database Policies
Table Cleanup Policy
The
Statistics Table Cleanup
policy automatically cleans statistical information from the database.
Table 7
describes the fields for adding a new
StatsTableCleanup
policy.
Figure 106. Adding Table Cleanup Policy
Table 7. Table Cleanup Policy Properties
Property
Description
Delete data after
(days)
Specify how long to store the data in the database before it is deleted.
Default = 7days
status
Specify whether the status of the policy is Enabled or Disabled.
The policy can be executed only when it is Enabled.
Table Name
Specify the name of the table that stores the statistical data.
Default = STATSDATA%, unless you have changed the data collection parameters.
If you have specified your own table name in the data collection parameters, that
table name should be specified in this field.
groupName
Specify the name of the group to which the policy belongs.
If default is specified, the policy does not belong to any group.
(You can execute different policies at the same time by associating them with a
common group name).
Period
Displays the interval (default interval - 3600 seconds) at which the policy checks
whether it is time for cleanup.
This field cannot be edited.
Cleanup Hour
(0-23)
Specify the hour of the day to clean up the statistics.
Default = 0 (i.e., between Midnight and 1 A.M.).
name
Displays the name of the policy.
This field cannot be edited.