444 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
Cleanup Old DB Queue Entries
The Cleanup Old DB Queue Entries job deletes rows from several database
queues tables. The size of these tables can grow rapidly if the job is not enabled.
The number and the age of the rows to delete are set in the stored procedure
asisp_clean_old_queue_entries. Default values are 10,000 entries older than
one day. The queue tables that are cleaned up are shown in Table 14-4.
Table 14-4 Queues tables cleaned up by the Cleanup Old DB Queue job
To customize the job with values different from the defaults, you must update the
job step using the SQL Enterprise Manager as shown in Figure 14-3 on
page 445.
ProcessedAutoTicketEvent ProcessedAutoTicketFilteredEve
nt
ProcessedBatchRule
ProcessedEvent ProcessedHeartBeatMsg ProcessedMVSUploadRule
ProcessedNotification ProcessedNotification8 ProcessedNotificationJ
ProcessedPerfMonMsg ProcessedRuleCommand ProcessedScmMsg
ProcessedStagedEvent ProcessedTECExportEvent PendingAutoTicketEvent
PendingAutoTicketFilteredEvent PendingBatchRule PendingEvent
PendingHeartBeatMsg PendingMVSUploadRule PendingNotification
PendingNotification8 PendingNotificationJ PendingPerfMonMsg
PendingRuleCommand PendingScmMsg PendingStagedEvent
PendingTECExportEvent