10.10.6 Estimating the size of information that is output from the statistics log files when the adbstat command is executed

This subsection explains how to estimate the size of information that will be output from the statistics log files when the adbstat command is executed.

Use the following formula to determine the size of the CSV file that will be output as the SQL statement statistical information (variable SQL_CSV_SIZE).

Formula (kilobytes)

Determine the size by assuming that information in all statistics log files will be output using the adbstat command.

Explanation of variables

STLOG_SUM

Combined total size of all statistics log files (kilobytes)

DBAREA_NUM

Number of DB areas in the entire HADB server

To Page Top