RSORATDB

Definition

RSORATDB analyzes the growth of certain tables, indexes and tablespaces and writes the results to database table MONI .

This program carries out forecasts on the basis of values from the past, in order to be able to issue warnings in good time of any storage bottlenecks that may occur.

The results are stored with a timestamp (date, time). This means that you should execute the program on the database system at least once a day (entry in table TCOLL , system=C ). If there is no dialog instance active on the database server, the data collector switches to the first available application server.

Considerable CPU resources are required on the database server to run RSORATDB, depending on the database size. This means that you should not schedule this program too frequently. Therefore the data determined will not always be up-to-date but will reflect the status at the time of the collector run.