message log truncate argument: Delete the contents of a message log file (SQL administration API)

Use the message log truncate argument or file truncate argument with the admin() or task() function to specify the particular online, ON-Bar activity, or ON-Bar debug message log file to truncate. When the database server truncates a message log file, it deletes the messages in the log file, but keeps the log file.

Syntax

EXECUTE FUNCTION { admin | task } ( { "message log truncate" | "file truncate" } ," file_path" );
Element Purpose Key considerations
file_path Full path name for the online, ON-Bar activity, or ON-Bar debug message log file.

Examples

The following examples show the arguments that you can use to truncate the /usr/informix/online.log file:

execute function task("message log truncate", "/usr/informix/online.log");
execute function task("file truncate", "/usr/informix/online.log");