You can configure your database system in such a way that it automatically adds a new data volume as soon as the fill level of the data area reaches a certain percentage. To do so, you use a Database Manager event that is preconfigured in the MaxDB software as of database version 7.5.00.08.
You can activate the option for extending the data area automatically and use the system default value, which adds a data volume when the fill level reaches 90%. You can also define a different percentage value for adding a data volume. You can overwrite this value by executing the DBM command again.
If the AutoExtDir is not defined, the Database Manager creates the new data volume in the run directory of the database instance. It generates the name based on the name of the last data volume that was created and assigns a sequence number or adds 1 to an existing number in the name.
· You have the server authorization ParamFull or AccessUtility.
· The operational state of the database instance is ONLINE.
auto_extend <mode> [<number>]
Options
Option |
Description |
<mode> |
Function for automatically extending the data area;
possible values: |
<number> |
Percentage value that acts as a threshold for adding a
new data volume. The
following applies: The default value is 90 |
OK
[ON [<number>] | OFF [, <reason> | UNKNOWN]
Values for the Reply Fields
Field |
Description |
ON |
The function for automatically extending the data area is active |
<number> |
Defined percentage as of which the system adds a data volume |
OFF |
The function for automatically extending the data area is not active |
<reason> |
Reason why the function was deactivated |
UNKNOWN |
The status of the function for automatically extending the data area cannot be determined |
Logging on to the Database Manager CLI as operator DBM with password DBM, connecting to the database instance HOTELDB (log on in session mode),
· Activate the function for automatically extending the data area; the system is to add a data volume as soon as the data area is 66 % full:
dbmcli -d HOTELDB -u DBM,DBM
dbmcli on HOTELDB>auto_extend ON 66
OK
· Display the status of the function for automatically extending the data area:
dbmcli on HOTELDB>auto_extend SHOW
OK
ON 66