wtdbclear or wtdbclear.pl

iKnow-IT banner

wtdbclear

Clears events from the event database.

Syntax

wtdbclear [–e] [–f] [–l] [–c classname] [–r severity] [–s status] –t seconds [–a records]

a records

 

A commit is performed after x number of records are deleted.

c classname

Clears events with the specified class name.

Note: You cannot use the this option when clearing reception logs with the –l option.

e Deletes events in the event repository and the task repository. You must use the –t option to specify the age of the events to be deleted. If you do not specify the –t option, no events are deleted.

f Forces deletion of QUEUED and WAITING events from the reception log.

Note: Never use this option while the Tivoli Enterprise Console server is running.

l Deletes events in the reception log. You must use the –t option to specify the age of the events to be deleted. If you do not specify the –t option, no events are deleted.

Note: You cannot use the –c, –r, or –s options when clearing the reception log with this option.

r severity

Clears events with the specified severity. The valid default values are FATAL, CRITICAL, MINOR, WARNING, HARMLESS, and UNKNOWN.

Note: You cannot use the this option when clearing the reception log with the –l option.

s status

Clears events with the specified status. The valid default values are OPEN, CLOSED, RESPONSE, and ACK.

Note: You cannot use the this option when clearing the reception log with the –l option.

t seconds

Deletes events that are older than the specified number of seconds. This option is required.

 

The following example deletes all events from the event repository:

wtdbclear –e –t 0

 

The following example clears the entire database:

wtdbclear –elf –t 0

$ wtdumper -o ASC | grep ACK | wc -l

$ wtdumper -o ASC | more

Remove the Errpt_TH messages (e.g. if there was an event storm)

wtdbclear -e -c Errpt_TH -r MINOR -s OPEN -t 0

 

wtdbclear -e -s ACK -t 259200 (60 sec * 60 min * 24 hours * 3 days)