MaxDB WikiHow to decrease the size of an existing database
Starting with release 7.6 it is possible to delete data volumes while you are in online mode. All you have to do is to use the db_deletevolume command from within dbmcli. There are no restrictions on which volume you are allowed to drop as long as the remaining volumes are big enough to hold all your data.
It is not possible to delete log volumes.
Remember to always keep enough room for temporary data such as undo log information or temporary result tables!
Hint: If you want to check how much space is used on your individual volumes, try Select * from Datavolumes.
dbmcli on ol77>param_getvolsall OK LOG_MIRRORED NO MAXLOGVOLUMES 2 MAXDATAVOLUMES 11 LOG_VOLUME_NAME_001 6250 F LOG01.dat DATA_VOLUME_NAME_0001 25000 F DAT01.dat DATA_VOLUME_NAME_0002 25000 F DAT02.dat --- dbmcli on ol77>help db_deletevolume OK db_deletevolume [DATA] [ NAME <vol_name> | [ID] <vol_no> ] --- dbmcli on ol77>db_deletevolume name DAT02.dat OK --- dbmcli on ol77>param_getvolsall OK LOG_MIRRORED NO MAXLOGVOLUMES 2 MAXDATAVOLUMES 11 LOG_VOLUME_NAME_001 6250 F LOG01.dat DATA_VOLUME_NAME_0001 25000 F DAT01.dat