Deleting events

You can use the istool event deleteEvents command to delete events, such as exception events, from the metadata repository.

Purpose

When you use suite tools that create events, each event is stored in the metadata repository. To manage the size of the repository, you can delete events periodically by using the event deleteEvents command on the istool command line.

Only those events for which notifications have been sent as part of the subscription process can be deleted.

Prerequisites

You must have the IBM® InfoSphere® Information Server suite administrator role.
Run the command from a computer that is on the engine tier or the client tier.

The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool before the command name.

Command syntax

Optional parameters and values in the syntax are enclosed in brackets, [ ].

event deleteEvents
authentication parameters
[-eventTypeName event_type]
[-begindate "begin_date_time"] 
[-enddate "end_date_time"]
[generic parameters]

Parameters

These parameters are specific to the event deleteEvents command. For authentication parameters and generic parameters, see Commands and common parameters for istool.

authentication parameters: Required. All asset interchange commands use authentication parameters to connect to a specific installation of InfoSphere Information Server.
-eventTypeName | etn event_type: Specifies the name of the registered event type that generates the events that you want to delete.; If the name of the file has an embedded space, enclose the name in double quotation marks (").; If you do not specify eventTypeName, events of all types are deleted.
-begindate | bd begin_date_time: If you specify this parameter, only events with a time stamp that is on or after the value specified are deleted.; Enter the value in the following format: "YYYY-MM-DD hh:mm:ss".
-enddate | ed end_date_time: If you specify this parameter, only events with a time stamp that is on or before the value specified are deleted.; Enter the value in the following format: "YYYY-MM-DD hh:mm:ss".
generic parameters: The generic parameters are available to all asset interchange commands. Use the generic parameters to request help on command syntax, to specify silent or verbose operation, and to use a script to run commands.

Examples

The following command deletes events of all types, regardless of when they occurred.

event deleteEvents -domain https://myinformationserver.com:9443 -u isAdminUser -p isAdminPwd

The following command deletes events of a specific type, regardless of when they occurred.

event deleteEvents -domain https://myinformationserver.com:9443 -u isAdminUser -p isAdminPwd -eventTypeName "NEW_EXCEPTION_DESCRIPTOR_EVENT"

The following command deletes events of a specific type that occurred during June 30, 2014 and July 15, 2014.

event deleteEvents -domain https://myinformationserver.com:9443 -u isAdminUser -p isAdminPwd -etn "NEW_EXCEPTIONS_EVENT" -beginDate "2014-06-30 11:00:00" -endDate "2014-07-15 11:00:00"

The following command deletes events of a specific type that occurred before July 15, 2014 at 11:00 am.

event deleteEvents -domain https://myinformationserver.com:9443 -u isAdminUser -p isAdminPwd -etn "NEW_EXCEPTION_DESCRIPTOR_EVENT" -ed "2014-07-15 11:00:00"

The following command deletes events of all types that occurred after June 30, 2014 at 11:00 am.

event deleteEvents -domain https://myinformationserver.com:9443 -u isAdminUser -p isAdminPwd -bd "2014-06-30 11:00:00"