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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+---------------------------------->

>--(--+-"message log truncate"-+--,--"--file_path--"--)--;-----><
      '-"file truncate"--------'                             

Element Purpose Key considerations
file_path Full path name for the online, ON-Bar activity, or ON-Bar debug message log file.  


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");

Copyright© 2019 HCL Technologies Limited