Deleting Data

About this task

On the Data management page, you can permanently delete obsolete audit data for a specified Retention time period. You must carefully choose the Retention time period, as deleting too much data at once might have negative effects on the database, such as an increased time of the archive operation, locking issues, a large increase of the database size, an increase of the transaction log, and an increase of the temp table size. To avoid these negative effects, for each delete operation, choose the largest retention period possible.

Service Monitoring can archive user-defined messages for a service only if customized logging is set up for the service. If service logging is globally enabled in Integration Server, but customized logging is not set up for the service in Designer, then Service Monitoring cannot delete user-defined messages written by the service.

To delete audit date

Procedure

  1. In the Retention time period area of the screen, specify how long you want to keep the data in the IS Core Audit Log tables. Service Monitoring deletes data that is older than the retention period you specify.
    The following table describes the data retention options.
    Option Description
    Number of days to retain

    (ending with today)

    		Number of days for which you want Service Monitoring to keep archive data.

    For example, if you specify 15, Service Monitoring will delete data that is 16 days old or older.

    Retention period start date

    (ending with today)

    		Date of the oldest data to keep. Click the calendar icon and select the date and time.

    For example, if you specify 6/3/2020 0:00:00, Service Monitoring will keep data from 6/3/2020 until the current date, and will delete data logged before 6/3/2020.

    Note: Service Monitoring deletes services based on their end timestamp, and documents and server data based on the timestamp.
  2. Select Data types to delete.
    1. Select the check boxes corresponding to the types of data to delete.
      The following table describes the types of data.
      Select To archive
      Services Service log entries, input pipelines, error data, user-defined messages, and service control data (resubmit actions).
      Documents Logged documents for all webMethods Broker (deprecated) clients and document control data (resubmit actions). If selected, Service Monitoring deletes all logged documents.
      Server data Integration Server session and guaranteed delivery log entries, and error log entries that are not associated with logged processes, services, or documents (for example, errors that occur during startup or during the run of unlogged services, activations, and documents). If selected, Service Monitoring deletes all server data.
    2. If you want to delete services, select which status to delete.
      The following table lists the status options.
      Option Archives or deletes
      Completed Audit data for services with status Completed.
      Completed-Failed Data for services with status Completed, Failed, Failed (Escalated), and Resubmitted.
  3. In the Archiving batch size field, indicate the number of primary items and accompanying items to delete at a time.
    For example, to delete 100 services, activity logs, and errors at a time, choose a number that takes the size of each record and other performance factors into consideration. If the record size is large, consider reducing the batch size; if the record size is small, increasing the batch size might increase the speed of the deletion.
  4. Click Delete only.