Database Management

The Database Management section provides tools to manage logs within your integration system. This includes clearing logs, setting parameters for automatic log deletion, and customizing the cleanup schedule. Log management is important for maintaining the performance and storage efficiency of your system. It helps in ensuring that the database does not become overloaded with old or unnecessary log entries.

Log Cleaning

Log cleaning is the process of deleting old log entries from the database. This can be done based on a specific date range or according to an automated schedule. By managing the logs effectively, you can reduce the size of the database and keep it performing optimally.

Clear Logs Between Dates

You can clear logs between a specified date range. This helps in removing logs that are no longer relevant to your operations.

Field	Description
Start Date	The beginning date from which the logs will be deleted. This marks the earliest log entry that will be removed.
End Date	The ending date until which the logs will be deleted. This defines the latest log entry that will be removed.

To delete logs between specific dates, you would specify a start and end date. For example, to clear logs from January 1, 2023, to January 31, 2023, you would provide the respective dates.

Dynamic Cron Job for Log Cleanup

You can configure a cron job that runs dynamically to clean up logs at specified intervals. The cron job determines how often the log cleanup task will be executed. For example, you can set up the cron job to run weekly, monthly, or at custom intervals to ensure that logs are automatically cleaned after a certain period.

Field	Description
Cron Expression	The cron expression defines the schedule for the log cleanup job. This determines how frequently the log cleanup will run. A cron expression might look like 0 0 * * * for running the cleanup every day at midnight or 0 0 * * 0 for running it every Sunday at midnight.
Delete Interval	Defines the interval at which logs will be deleted, such as daily, weekly, or monthly. This interval works in conjunction with the cron expression to automate the process.

---

tip

Example Usage

1. Clearing Logs Between Specific Dates:
   If you want to delete logs between January 1, 2023, and January 31, 2023, you would use the start and end date fields to specify this range and trigger the deletion.

2. Setting Up a Cron Job:
   If you prefer the system to automatically clean logs weekly, you can set up a cron expression like 0 0 * * 0 to run the job every Sunday at midnight. The delete interval could be set to "weekly" to match this schedule.

---

Managing Log Cleanup

Clicking the three dots under the "Action" heading offers the following options in MIP:

• Edit Log Cleanup Settings: Allows changing the log cleanup settings, such as the cron expression and delete interval.
• Delete Logs: Allows the immediate deletion of logs based on the specified date range.
• Change Auto Log Deletion Parameters: Allows modification of the parameters for automatic log deletion, including the interval and cron schedule.

By managing logs effectively, you can optimize your system's performance and ensure that storage resources are used efficiently.