Maintain acknowledged messages in the management server database
Messages that have been acknowledged are removed from the active
messages browser and displayed in the acknowledged messages
browser. The management server database that contains these
acknowledged messages eventually reaches its capacity if regular
maintenance is not performed. The DBMaint component, which is an
integral part of the OvEpMessageActionServer service, performs this
regular database maintenance.
The Database Maintenance namespace in the Server Configuration
dialog box enables you to reconfigure the default registry
settings, which specify when and how often such maintenance should
be performed.
Database maintenance time: specifies that the database
should be scanned daily at 3:00 a.m. for old acknowledged
messages.
Acknowledge message retention period (in days):
specifies that messages which have been acknowledged for longer
than 30 days should be deleted. To save these deleted messages,
download the messages to text
files using the configuration values Export acknowledged
messages before deleting them and Location of the exported
message files.
Messages processed per database transaction: defines the
maximum number of messages which can be processed (exported or
deleted) within one transaction. After the defined number of
messages has been processed, the current transaction is committed
and a new transaction is started to process the next block of
messages.
Maximum database maintenance scan duration (in seconds):
defines the maximum time interval (duration) in seconds DBMaint is
allowed to perform its operation. If during operation the end of
the defined time interval is reached, but there are still
outstanding message blocks to be processed, then DBMaint finishes
the processing of the current message block by committing the
current transaction. DBMaint will not start additional transactions
so that it can continue to process further messages. In this case,
it writes the following warning message into the Windows
Application Event Log:
(MS850) DBMaint stopped due to the maximum duration time limit
being reached.
Then DBMaint updates the table ov_ms_stats with the appropriate
statistics. Messages which could not be processed (exported or
deleted) due to the maximum time interval being reached will be
processed the next time DBMaint is scheduled to run.
Maintenance occurs automatically and requires no further action
from administrators and users.
However, as administrator, you can change these defaults if they
do not meet your needs by manually changing the settings in the
Server Configuration dialog box.
To edit default database maintenance configuration values
In the console tree, right-click Operations Manager, and
then click Configure Server.... The
Server Configuration dialog box opens.
Click Namespace and then click Database
Maintenance. A list of values appears.
Click the value that you want to change. Depending on the type
of value, you can either type a new value, or select a value from a
list that appears.
Optional. If a value appears in bold, the default
value has been changed. To reset the value to its default,
right-click the value, and then click Set to default.
Server.... The
Server Configuration dialog box opens.