BPMDeleteDurableMessages command

Syntax

BPMDeleteDurableMessages -olderThan age_in_days -maximumDuration number_of_minutes -transactionSlice number_of_messages

Purpose

The BPMDeleteDurableMessages command deletes durable subscription messages based on their age. You can use this capability to trim the size of the LSW_DUR_MSG_RECEIVED database table periodically.

Durable subscription messages exist and persist if durable subscriptions are enabled for intermediate message events or intermediate content events. See the "Using intermediate message events to receive messages" topic for more information.

Required parameters

-olderThan age_in_days

Specifies an age in days. Durable subscription messages that are older than the specified age are deleted when the command is run.

Note: A day is interpreted as a period of 24 hours rather than as a calendar day. For example, if you specify a value of 3 for the -olderThan parameter, it is interpreted as 72 hours rather than as 3 calendar days. As a result, all durable subscription messages that are older than 72 hours will be deleted when you run the command. However, durable subscription messages that were created after the end of the 3rd calendar day will not be deleted if they are not actually older than 72 hours.

Optional parameters

-maximumDuration number_of_minutes

Specifies the maximum duration of the deletion operation in minutes. The default value is 0 (which is equivalent to an unlimited number of minutes). When the maximum duration is exceeded, the command is aborted after the current transaction has committed.

-transactionSlice number_of_messages

Specifies the number of durable subscription message instances that are deleted with each transaction. The default value is 1000.