Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SQL_DEBUG LOG_STMT_TIMES_FETCH

SQL_DEBUG LOG_STMT_TIMES_FETCH

Log start and end times of a fetch sequence (open cursor, all fetches and close cursor). Logging is to the CTSTATUS.FCS file.

Behavior Change

In V11.6 and later, the statement logging output produced by this configuration keyword has been changed to be in one line in JSON format and to include extra information such as the timestamp, the user, and the IP address of the client making the request.

For example:

{"timestamp":"Fri Aug 24 11:56:24 2018","ipaddr":"::ffff:127.0.0.1","db":"CTREESQL","user":"admin","thread":23,"operation":"OPEN","exectime":7,"tmptime":2,"statement":"select * from syscolumns order by width "}

See Also

TOCIndex