Skip to end of metadata
Go to start of metadata

Use

Data volume filling level <percentage>%, <number_of> pages configured, used on volumes <used_on_volumes>, perm used <perm_used>, temp used <temp_used>, shadow used <shadow_used>, pages in cache not yet written to volumes <not_yet_written>


Explanation

The fill level of the data volumes is high. If the fill level is 100%, the database 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.

 

More Information

Relevant  DB-Analyzer Files
Helpful with ...
 DBAN_FILLING.csvFill level of the database (for example, the size of the data volumes, number of permanently and temporarily used pages) 
SAP Note
Helpful with ...
  
Expert Sessions (Link to trainings)
Content / Helpful with ...

Session 16: SAP MaxDB SQL Query Optimization (Part 1)
Session 16: SAP MaxDB SQL Query Optimization (Part 2)

Find detailed information about different optimizer strategies and performance optimization.
Session 18: SAP MaxDB Architecture General explanations about database concepts.
Documentation (links)
Helpful with ...

Database Administration

Adding Data Volumes 
<übernommen>
SQL Optimizer <übernommen>

                            

 

  • No labels