Request log file analysis

The format of the output in the request log file (generated by setting the -zr server startup switch) has changed in Sybase IQ 15.0. The stored procedures sa_get_request_profile and sa_get_request_times can be used to read the -zr log file and summarize the results.

The procedure sa_get_request_profile analyzes the request log to determine the execution times of similar statements and summarizes the results in the global temporary table satmp_request_profile. For example:

call sa_get_request_profile('/sys1/users/jones/iqreqs1_zr.log');
select * from satmp_request_profile;

The procedure sa_get_request_times analyzes the request log to determine statement execution times and summarizes the results in the global temporary table satmp_request_time. For example:

call sa_get_request_times('/sys1/users/jones/iqreqs1_zr.log');
select * from satmp_request_time;