Stores information on the internal state of a database that contains X100 tables. Updates, inserts, and deletes to the data and the layout of the data in the data files are stored as log information in the main.wal file. The WAL also contains persistent catalog information. The data files and the WAL file must be considered together as files that represent the database. A WAL file exists for each database and is located in the wal subdirectory of the default data location.

For more information, see X100 Write-Ahead Log

Stores errors and other messages for the X100 Engine. The file is located in: II_SYSTEM/ingres/files/vectorwise.log. For Actian X for Windows installations: %ALLUSERSPROFILE%\Actian\VectorXX\files\vectorwise.log. You can configure error logging to change the level of information logged, the name and location of the log file, and the record format.

For more information, see Error Reporting--vectorwise.log.