Skip to end of metadata
Go to start of metadata

SAP® MaxDB - Data Area Full

 

 

Moderator: Birgit Malik

WIKI Space Editor: Thiago Lüttig

This section explains how you can handle a database full situation and how you can prevent it.

Symptom
  • Symptom: Data Area Full (warning)

If the data area is full (no space left on the data volumes), the application is suspended - you don't see any progress anymore. All database tasks are suspended until some space is available again.

Additional Useful Information
Relevant Training
Solution of Log Full situations

(tick) Add a new data volume

When the data area is full, you have to Add a new data volume using DatabaseStudio or Database Manager CLI (DBMCLI).
(thumbs up) DatabaseStudio -> Administration -> Data Area -> mark a new Volume and choose New

The new data volume can be added in operational state ONLINE and can be used immediately. All suspended tasks continue their work as soon as the ADD VOLUME is finished.

You can also use the following DBM command to add a new data volume:
dbmcli -d <database_name> -u <dbm_operator>,<password> db_addvolume DATA <volume_name> <volume_type> <volume_size>

<volume_name> is the complete path including the file name of the new data volume.
<volume_type> is the device type: F (file), R (raw device) or L (link).
<volume_size> is the size of the volume to be added in pages (1 page = 8 KB).

Details

KnlMsg

The system writes messages into file KnlMsg/knldiag even before a filling level of 100% is reached:

 

2016-02-03 12:04:16 WNG KernelDBE_ 20000:   95 percent of data area occupied, 1500 pages free 
2016-02-03 12:04:17 WNG KernelDBE_ 20000:   96 percent of data area occupied, 1200 pages free 
2016-02-03 12:04:17 WNG KernelDBE_ 20000:   97 percent of data area occupied, 900 pages free 
2016-02-03 12:04:17 WNG KernelDBE_ 20000:   97 percent of data area occupied, 900 pages free 
2016-02-03 12:04:17 WNG KernelDBE_ 20000:   98 percent of data area occupied, 600 pages free 
2016-02-03 12:04:18 WNG KernelDBE_ 20000:   99 percent of data area occupied, 300 pages free
:
2016-02-03 12:04:20 WNG FBM        20001:  No more free blocks on data volumes available
:
2016-02-03 12:04:20 WNG FBM        20001:  No more free blocks on data volumes available

 back to top

DatabaseStudio

Database Studio -> select the database -> choose Administration -> Data Area
You'll get the information about data area full situation and a hint how to solve this data area full situation.

Click on Add new data volume brings you into the Data Volume menu.

 back to top

XCONS

The database console programm x_cons has to be started on operating system level. It shows the data area full situation with the command x_cons <DBNAME> show act. If the data area is full, all active tasks are in state DB full.


ID   UKT  Win   TASK       APPL Current        Timeout  Region     Wait UKT 
          tid   type        pid state          Priority cnt try    item count 
:
T69    4  0x96C Savepnt         DB FULL  (198)          0               (s)3003 

back to top

db_cons

You can start the database program XCONS as well with command db_cons via Database Studio -> select the database -> choose Administration -> Command Line-> db_cons show act . 
If the data area is full, all active tasks are in state DB full.

 
ID   UKT  Win   TASK       APPL Current        Timeout  Region     Wait UKT 
          tid   type        pid state          Priority cnt try    item count 
:
T69    4  0x96C Savepnt         DB FULL  (198)          0               (s)3003 
 

back to top

activate the auto_extend feature (as of version 7.6)

To prevent a database standstill caused by a data area full situation, you can activate the auto_extend feature (as of version 7.6). When a specified filling level is reached, a new data volume is added automatically. The name of the new data volume is choosen depending on the already existing data volumes. Using the Database Manager Parameter AutoExtDir you can specify in which directory the new data volumes are created. If no directory is specified, the new volumes are created in the same directory as the lastly added volume. Using the Database Manager Parameter AutoExtSize you can specify the size of the new data volumes - either in Pages or in % of the database size (at the point in time when the new volume is added). If the parameter is not set, the new volume gets the same size as the lastly added volume.

(warning) Please keep in mind that the database does not check if there is enough free space in the filedirectory for the new volume. This feature should only be used in combination with dynamic file systems extension which grows implictely.

back to top