Show TOC

Space Management with SAP MaxDBLocate this document in the navigation structure

Use

Poor space management can lead to downtime because the database runs out of space. It is far better to prevent this problem than to recover from it. You can use CCMS or Database Studio to manage space in the SAP MaxDB database.

Prerequisites

In the following cases, an SAP MaxDB database stops processing, so that SAP applications can no longer continue:

  • Data area fill level 100%

    This means there is no more space in the data area of the database. You must quickly provide more space by adding a new data volume to the database. You can add a new data volume in ONLINE operational state, see DBA Cockpit: SAP MaxDB , Data Area .

  • Log area fill level 100%

    During normal database operations (that is, in ONLINE operational state), you can back up the log area without affecting SAP applications. If you do not back up the log area, messages are sent to the knldiag file and to the alert monitor in the SAP system. If the full log area is full, SAP applications cannot continue until you have backed up the log area.

    To avoid the log area filling up, use the automatic log backup. To do this, use CCMS function Activating Automatic Log Backups to activate the automatic log backup or use the corresponding Database Studio function. This means that the system backs up the log area when necessary.

Process

  1. You monitor the database and log area fill levels.

    To manage space in your database, we recommend using CCMS or Database Studio. For routine monitoring, use the alert monitor in CCMS.

  2. You configure your database for optimal production.

    Optimal installation of your database in view of the disks available and anticipated requirements can prevent future problems. This includes correctly sizing the database (for example, size and number of data volumes).

  3. You monitor the data area fill level.

    Closely watch the filling up of the data area. Use CCMS or Database Studio to monitor the fill level.

  4. If required, you add data volumes.

    As the result of your monitoring, you might decide to add a new data volume to the database using Database Studio.

    First, check whether the database parameter MaxDataVolumes is large enough to add a new volume. If this parameter is large enough, you can add the volume in ONLINE operational state. Otherwise, you have to increase the database parameter MaxDataVolumes, then stop and start the database, before you can add a new data volume.

    You can also activate automatic extension of the data area using CCMS or Database Studio.

    For more information, see Automating Administration Tasks in Database Administration .

  5. You monitor the log fill level.

    You can monitor the log fill level using CCMS or Database Studio. Make sure the log fill level does not approach 100%. Once you have backed up the log area, it is automatically free for reuse.

  6. You back up log entries when necessary.

    We recommend that you enable the automatic log backup function using CCMS or Database Studio.