Data volume filling level

Data volume filling level <percentage>%, <number_of> pages configured, perm used <perm_used>, temp used <temp_used>


The fill level of the data volumes is high. If the fill level is 100%, the database instance stops.

User Response

If the amount of data that needs administering in the database instance has increased, you may need to add a new data volume.

A large proportion of temporary data pages (temp used) indicates large amounts of (buffer) result sets. Find the statement that is causing these large amounts of (buffer) result sets to be created, and check the access strategies for this statement.

For information on creating optimized SQL statements, see the SQL Optimizer documentation.