SQL Language Guide : 8. SQL Statements : CALL VECTORWISE : VWLOG_ROTATE Command
 
Share this page                  
VWLOG_ROTATE Command
The VWLOG_ROTATE command performs the following actions on the Vector error log file:
1. Closes the current log file.
2. Renames the current log file to a new file.
3. Reopens the old log file (which is now empty) and continues to append incoming log messages.
This command makes it easier to transfer, manage, and analyze the error log file. It can be used if the error log file gets too large. It can be used daily or weekly to better organize log files, such as compressing them, and then archiving them to another storage location.
This command has the following format:
CALL VECTORWISE( VWLOG_ROTATE ['''new_filename''']);
where:
new_filename
Specifies the name of the new error log file. The new_filename can be an absolute path and must be enclosed in triple quotes.
If new_filename does not specify an absolute path, then the error log file is moved to the installation’s files subdirectory (or II_LOG location on Windows). If new_filename is an existing file, VWLOG_ROTATE does not overwrite it and raises an error message. The new_filename must specify a file on the same partition as the existing error log file. It can be moved to another partition later.
Windows: The backslashes in the path name must be escaped, as shown in the example.
Examples:
1. Move the error log file to new_file. Write subsequent log lines to a new (empty) file that has the same name as the old log file:
Linux:
CALL VECTORWISE(VWLOG_ROTATE '''/home/John/new_file''');
Windows:
CALL VECTORWISE(VWLOG_ROTATE '''C:\\Documents and Settings\\John\\My Documents\\new_file''');
2. Move the error log file to a file whose name is the concatenation of the current log file name and a timestamp string of the form "-YYYYMMDDTHHMMSS, in the same directory as the current log file. Write subsequent log lines to a new (empty) file that has the same name as the old log file:
CALL VECTORWISE(VWLOG_ROTATE);