Request Log File Analysis

Use the stored procedures sa_get_request_profile and sa_get_request_times to read the -zr log file and summarize the results.

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;

sa_get_request_times also 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;

For more information about request-level logging, see the start_iq -zo switch in Utility Guide > start_iq Database Server Startup Utility, and the sa_server_option system procedure in Reference: Building Blocks, Tables, and Procedures.

Request logging
Request logging logs individual requests received from, and responses sent to, an application. It is most useful for determining what the database server is being asked to do by the application.

Parent topic: Logging Server Requests