The MONITOR_OUTPUT_DIRECTORY option controls placement of output files for the IQ buffer cache monitor. All monitor output files are used for the duration of the monitor runs, which cannot exceed the lifetime of the connection. The output file still exists after the monitor run stops. A connection can run up to two performance monitors simultaneously, one for main cache and one for temp cache. A connection can run a monitor any number of times, successively.
The MONITOR_OUTPUT_DIRECTORY option controls the directory in which the monitor output files are created, regardless of what is being monitored or what monitor mode is used.
The chapter “Database Options” in the Sybase IQ Reference Manual contains an example of setting the MONITOR_OUTPUT_DIRECTORY option. In this example, the output directory string is set to both “/tmp” and “tmp/”. The trailing slash (“/”) is correct and is supported by the interface. The example illustrates that the buffer cache monitor does not require a permanent table; a temporary table can be used.
