If you have SYSADM authority or higher and exclusive use of the server, you can temporarily turn the logging system off. When issued from the SQL Wizard, the SET LOG OFF command temporarily suspends logging for the location during the remainder of the current session. Turning logging off for a particular location is a temporary expedient for an exclusive user that does not want to incur the overhead of logging during administrative tasks.
Logging is turned off for the current session, only. Logging can be activated again in the current session by issuing a SET LOG ON command. Exiting the session toggles the status of location logging back to on (the default). The next session that accesses the location therefore has logging turned on. Setting the logging system on or off from the SQL Wizard does not affect the logging configuration settings in your xdbsrvco.ini file.