SET TRACE TERMINAL 'terminalname' sets the terminal the DBMS trace logs are written to. If a terminalname is currently defined for tracing, then Ingres uses the newly defined terminalname for subsequent tracing. If no terminal is currently defined for tracing (either SET TRACE TERMINAL has not been executed once or the latest trace terminal command executed has been SET NOTRACE TERMINAL), then terminalname will be used for subsequent tracing.

The 'terminalname' option must be a quoted string and the complete path of the terminal device in the OS file system. For example, to set terminal pts/6 on a Linux machine as the trace terminal, use the command SET TRACE TERMINAL '/dev/pts/6'.

SET NOTRACE TERMINAL closes the trace terminal. No trace information is written to any terminal until a subsequent SET TRACE TERMINAL statement is executed.