Rolling the Transaction Log

The vectorwise.log file, stored in /opt/Actian/VectorVW/ingre/files, accumulates all log messages for the accelerator database and this can grow quite large. This should be regularly rolled over to keep the size of the log manageable.

How to check the size of the vectorwise.log File

Run the following command as the Actian user:

# ls -lh /opt/Actian/VectorVW/ingres/files/vectorwise.log

How to roll the vectorwise.log File

If the file is getting large it is advisable to roll the log file. The following command should be run as the Actian user.

# echo "call vectorwise(vwlog_rotate)\g" | sql db

The expected output would be something along the lines of:

Check the log size again and it should be much less in size. There should also be another file next to it named vectorwise.log-<today's date>. This can be safely deleted.