How Can I Analyze Timed Statistics?

A script (analyze_stats.pl) is available to analyze timed statistics output. The script creates a configuration file for the tables analyzed by the report. The generated configuration file shows tables that you could configure for caching and the recommended number of records to be cached. The generated configuration file can be used as is. You could also modify the settings or use the recommendations to create a new configuration file or update an existing one. If you already have a configuration file for a table that has been analyzed through the analyze_stats.pl script, you can merge the recommendations into your existing configuration file.

After you run a process with timestats turned on, you can run analyze_stats.pl. The script does the following:

• Create a report of the timestats data with output organized in meaningful ways.

  The report is generated in the /tmp/ programname .out file under the directory for the product line that is being analyzed.

  By default, the report is sent to the screen (standard output). Send to a file if you want to be able to print the output.

  The report can be disabled with the -q option. If the -q option is used, only the configuration file is created.

• Generate a configuration file with recommendations about how caching could improve processing of the tables accessed by the program:

  /location /productline|dataarea.programname .cfg

  where location is the directory where the timestats data is located, and productline|dataarea and programname are those specified in the timestats data.

  If you run the run the analyze_stats.pl script using the -d (data area) option, all programs in the data area are analyzed and a configuration for each is created. The generation of the configuration file can be disabled with the -r option. If the -r option is used, only the report is created.