Manage message logs in an embedded environment
You can enable the database server to automatically rotate and delete online message log files, and you can specify the maximum number of online, ON-Bar activity, or ON-Bar debug message log files to rotate. The Scheduler tasks that rotate and delete these message log files are useful for embedded applications, because they reduce DBA or system administrator requirements for managing the logs.
Additionally, you can run SQL administration API commands to rotate, remove the contents of (truncate), or delete one of these message log files. For example, you might want to run a truncate or delete command when performing a load operation.