HP Operations Manager

Change StartTime DBMaint and DBMaintTimeSpec Settings


The default settings for database maintenance can be easily changed to meet your specific requirements. The table following the numbered steps shows the correct format for the values and some example settings for each.

To edit default database maintenance configuration values

  1. In the console tree, right-click Operations Manager, and then click Configurearrow Server.... The Server Configuration dialog box opens.
  2. Click Namespace and then click Database Maintenance. A list of values appears.
  3. 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.
  4. 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.
  5. Click OK.
Value Description
Database maintenance time Specifies when the DBMaint component should start the maintenance cycle. The default specifies that the database is scanned daily at 3:00 a.m. for old acknowledged messages. It has the following format:

Syntax:

[DayOfWeek-]HourOfDay:Minute
DayOfWeek: 0 -6; Sunday = 0
HourOfDay: 0 -23
Minute: 0 -59

Examples:

6-20:10 (each Saturday at 8:10 p.m.)
23:59 (every day at midnight)

Acknowledged message retention period (in days) Specifies the time interval after which acknowledged messages should be deleted. The default is 30 days.

Syntax:

NumOfDays-NumOfHours-NumOfMin
NumOfDays: 0 - any number.
NumOfHours: 0 - 23
NumOfMin: 0 - 59

Examples:

2-0-0 (purge messages after 2 days of acknowledgement).

375-23-0 (purge messages after 375 days, 23 hours of acknowledgement)
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.

Syntax:

Possible values:

any value > 0
Default value: 150 (process maximum 150 messages within a transaction. After processing 150 messages, start a new transaction.
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 with processing 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.

Syntax:

Possible values:

0 (indicates unlimited time; default)
any value > 0 (indicates the number of seconds DBMaint is allowed to perform its operation).

Use this configurational value if there is a danger that occasionally DBMaint could take too long (more than ~30 minutes), which could then lead to problems as it overlaps with other scheduled tasks.

Example:

1800 (Process messages maximum 30 minutes. Those messages which could not be processed within 30 minutes will be processed the next time DBMaint is scheduled to run.)
Note NOTE:
DBMaint history log files use local time in the file name, not Greenwich Mean Time (GMT).

To delete acknowledged messages at any time you specify

If you want to delete acknowledged messages from the database at any time you specify, rather than waiting for the regularly scheduled maintenance, you can change the configuration value Database maintenance time to the time you prefer. You can also change the default 30-day setting for the deletion of acknowledged messages by changing the setting for the configuration value name Acknowledged message retention period (in days), as shown in the following examples. For best performance, delete no more than 1,000 messages at a time.

To delete all acknowledged messages immediately

  1. Assume that the current time is 2:10 p.m.
  2. Set the following registry values.

    Database maintenance time: 14:11

    Acknowledged message retention period (in days): 0-0-0

The Database maintenance time must use time specifications in the range of 0:00-23:59. It does not understand a.m. and p.m. You should add one or two minutes to the current time.

The Acknowledged message retention period (in days) value of 0-0-0 means a time interval of zero, so it includes all acknowledged messages.

DBMaint automatically responds when any of its configuration values change.

Note NOTE:
Reset the values to their normal settings when this exceptional maintenance finishes.

DBMaint notifies all interested HP Operations Manager components on message deletions; running consoles register for message deletion events and update their acknowledged messages browser accordingly. Check your acknowledged messages browser to confirm that the messages have been deleted.

Related Topics: