Altering a file
Use the ALTER FILE command to change the configuration of an existing ObjectServer file.
Syntax
ALTER FILE file_name
TRUNCATE |
SET ENABLED { TRUE | FALSE };The TRUNCATE setting clears any information that has been written to the physical file. When there is more than one physical file, the file that is currently being written to is truncated; the other files in the set are deleted.
The ENABLED setting turns logging on and off. If TRUE, a WRITE INTO command writes data to the file. If FALSE, WRITE INTO commands are ignored and nothing is written to the file. Disabling a file is useful when you want to stop logging temporarily, but do not want to discard the file you have configured.
Example
alter file logit truncate;