Logging Procedures

ProcedureDescriptionExample
logging.flush()Flush the buffer explicitlycall logging.flush();
logging.resetadapter()Resets the adapter back to the default: BASICcall logging.resetadapter();
logging.resetcomplevel(comp_id string)Resets the log level for a specific component back to the default: ERRORcall logging.resetcomplevel('SQL_REWRITER');
logging.resetflushlevel()Resets the flush level back to the default: INFOcall logging.resetflushlevel();
logging.resetlayerlevel(layer_id string)Resets the log level for a specific layer back to the default: ERRORcall logging.resetlayerlevel('GDK_ALL');
logging.setadapter(adapter_id string)Sets the adaptercall logging.setadapter('BASIC');
logging.setcomplevel(comp_id string, level_id string)Sets the log level for a specific componentcall logging.setcomplevel('SQL_PARSER', 'DEBUG');
logging.setflushlevel(level_id string)Sets the flush levelcall logging.setflushlevel('WARNING');
logging.setlayerlevel(layer_id string, level_id string)Sets the log level for a specific layercall logging.setlayerlevel('MAL_ALL', 'DEBUG');

Note: These procedures require elevated privileges.

You must include the logging. prefix for these procedures in order to work properly.

For explanation how to use the logging procedures Tracer Tutorial

select * from logging.compinfo();

Returns a table with for each component its id and current logging level.

Component Logging info

idcomponentlog_level
0ACCELERATORM_ERROR
1ALGOM_ERROR
2ALLOCM_ERROR
3BAT_M_ERROR
4CHECK_M_ERROR
5DELTAM_ERROR
6HEAPM_ERROR
7IO_M_ERROR
8PARM_ERROR
9PERFM_ERROR
10TEMM_ERROR
11THRDM_ERROR
12GEOMM_ERROR
13FITSM_ERROR
14SHPM_ERROR
15SQL_PARSERM_ERROR
16SQL_TRANSM_ERROR
17SQL_REWRITERM_ERROR
18SQL_EXECUTIONM_ERROR
19SQL_STOREM_ERROR
20MAL_WLCM_ERROR
21MAL_REMOTEM_ERROR
22MAL_MAPIM_ERROR
23MAL_SERVERM_ERROR
24MAL_OPTIMIZERM_ERROR
25GDKM_ERROR

For convenience there is also a system view logging.compinfo which selects all from logging.compinfo(). So you can also use query: SELECT * FROM logging.compinfo'` to get the same result.