Ingres 11.0 | Rotating the Vector Error Log

System Administrator Guide > System Administrator Guide > Configuring and Managing X100 > Error Reporting--vectorwise.log > Rotating the Vector Error Log

Was this helpful?

Rotating the Vector Error Log

If the error log gets too large, the VWLOG_ROTATE system call can be used to close the current error log file, move it to a new file, and then reopen the old error log file (which is now empty) and continue to append incoming log messages.

For example: The following statement moves the error log file to archive1.log. Subsequent log lines are written to a new, empty file that has the same name as the old log file:

CALL X100(VWLOG_ROTATE '''/opt/Actian/IngresXX/ingres/files/archive1.log''');

For more information, see VWLOG_ROTATE in the SQL Language Guide.

Last modified date: 01/30/2023