The File Log Inspector window allows you to inspect log file information about job execution, fatal errors, and the system log. The log files are located in the \log subdirectory of the installation directory. The log files are:
execution.log — captures all information regarding job execution errors.
fatal.log — captures low-level information that is written when the system encounters serious unexpected behavior. This includes information from fatal system exceptions when the system was no longer able to write to the system log file.
system.log — captures all information about system activities, both operational and exceptional events. The detail of data written to this file depends on the Trace Level that is set in the default.ini file located in the /etc directory. You can also change the Trace Level within a project or job by using the uTracelevel(n) function in a JavaScript procedure.
A Trace Level of 0 (the default) only traces minimal processing information. A Trace Level of 5 traces the maximum amount of information about processing events and processing steps.
Even a Trace Level of 1 will considerably increase the
amount of logging information written to the system.log file
and, as a result, will impact the overall performance of the Sybase IQ ETL environment.
The function uTracelevel(n), where n is a value of 0 through 5, lets you set the Trace Level from within a project or job. As a result, you can trace the execution of a single component with maximum detail, while all other components are only tracing at the default level. You can call the uTracelevel function from within a JavaScript procedure.
