MONITOR_OUTPUT_DIRECTORY option

Controls placement of output files for the IQ buffer cache monitor.

String.

Can be set for the PUBLIC group. Takes effect immediately. DBA permissions are required to set this option.

Same directory as the database.

The IQ monitor sends output to the directory specified by this option. The dummy table used to start the monitor can be either a temporary or permanent table. The directory can be on any physical machine.

The DBA can use the PUBLIC setting to place all monitor output in the same directory, or set different directories for individual users.

This example shows how you could declare a temporary table for monitor output, set its location, and then start the monitor sending files to that location for the main and temp buffer caches.

declare local temporary table dummy_monitor (dummy_column integer)

set option Monitor_Output_Directory = "/tmp"
iq utilities main into dummy_monitor start monitor '-debug -interval 2'

set option Monitor_Output_Directory = "tmp/"

iq utilities private into dummy_monitor start monitor '-debug -interval 2'