You can enable the request logging in SAP SQL Anywhere or SAP IQ to record the executed SQL commands from database clients. This is very useful if you want to dig down into more details on performance analysis or determine application specific calls to database.
Please be noted that, by activating this request logging, the performance to the database system will be impacted. Use below command to disable the request logging.
CALL sa_server_option( 'RequestLogging', 'none' )
To enable the request logging, execute the following command in interactive
CALL sa_server_option( 'RequestLogFile', 'YOUR_LOG_FILE.txt' );
CALL sa_server_option( 'RequestLogging', 'all' );
CALL sa_server_option ('RememberLastStatement', 'YES');
You can use below command to check if the request logging is enabled and the related request logging file.
select property('RequestLogging');
select property('RequestLogFile');
Note
2072203 – How to generate an SAP SQL Anywhere or SAP IQ Request Log to record executed SQL commands from database clients
