SAP MaxDB Helper Notes

maxdb_helper.txt

# List data or log volumes
sudo -u sdb /sapdb/programs/bin/dbmcli -U c param_getvolsall DATA
sudo -u sdb /sapdb/programs/bin/dbmcli -U c param_getvolsall LOG

# Add data or log volume
sudo -u sdb /sapdb/programs/bin/dbmcli -U c db_addvolume DATA
sudo -u sdb /sapdb/programs/bin/dbmcli -U c db_addvolume LOG

# Set database parameter
sudo -u sdb /sapdb/programs/bin/dbmcli -U c param_directput MaxLogVolumes 3
sudo -u sdb /sapdb/programs/bin/dbmcli -U c param_directput MaxDataVolumes 128

# Create SAP MaxDB Backup Template
sudo -u sdb /sapdb/programs/bin/dbmcli -U c backup_template_create <TEMPLATE> TO FILE /<dir>/INCR OVERWRITE COMPRESSED CONTENT INCREMENTAL DATA BLOCKSIZE 8

# Restore SAP MaxDB from different source
sudo -u sdb /sapdb/programs/bin/dbmcli -U c -uUTL -c db_activate RECOVER <TEMPLATE> DATA
sudo -u sdb /sapdb/programs/bin/dbmcli -U c -uUTL -c recover_start <TEMPLATE>