Use Software Compression for Backups for Default PIPE
SAP MaxDB does not support deduplication on default PIPE of 8K BLOCK SIZE, so we recommend that you use software compression for backups (Instance Properties dialog box, Storage Device tab, Data Transfer Option tab, Software Compression).
Optimizing Performance
To optimize your performance, create a minimum of 2 pipe mediums.
Optimizing PIPE to Achieve Deduplication
If you use a PIPE of 128K BLOCK SIZE with 4 PIPES for FULL Data backup and 4 PIPES for incremental data backup, you can achieve deduplication (Instance Properties dialog box, Storage Device tab, Deduplication Option tab, Enable Deduplication on Client or Media Agent).
The ratio of deduplication might vary. Log backups will not achieve deduplication.
Warning
You should not use a PIPE of 128K BLOCK SIZE to restore old backups that were performed using a 8K BLOCK SIZE.
Examples
Verify if the numstreams Value is Set to the Minimum Value 4 in the SapMaxDbAgent Parameter File
[root@sde-bigsap ~]# cat /opt/commvault/SapMaxDbAgent/param
numstreams
4
CvInstanceName
Instance001
CvClientName
sde-bigsap
Set the Minimum Value 4 for MAXBACKUPDEVS
This example sets the minimum value 4 for MAXBACKUPDEVS.
dbmcli on testdb>param_extget MAXBACKUPDEVS
OK
$[MAXBACKUPDEVS] int $[4]
If the minimum value for MAXBACKUPDEVS is not set to 4, run the following commands:
dbmcli on testdb>param_put MAXBACKUPDEVS 4
OK
dbmcli on testdb >db_stop
OK
dbmcli on testdb >db_online
OK
Create PIPE Mediums for Deduplication On a Unix Computer
This example creates PIPE mediums for dedupData2, dedupPages2, and dedupLog.
dbmcli -d $[testdb] -u $[dbm,dbm]
dbmcli on testdb> backup_template_create $[dedupData2] TO BACKUPTOOL BACKINT PIPE $[/sapdb/testdb/files/ddm0] NAMED $[ddm0] PIPE [$[/sapdb/testdb/files/ddm1] NAMED $[ddm1] PIPE $[/sapdb/testdb/files/ddm2] NAMED $[ddm2] PIPE $[/sapdb/testdb/files/ddm3] NAMED $[ddm3] CONTENT DATA BLOCKSIZE $[128]
dbmcli on testdb> backup_template_create $[dedupPages2] TO BACKUPTOOL BACKINT PIPE $[/sapdb/testdb/files/ddm4] NAMED $[ddm4] PIPE $[/sapdb/testdb/files/ddm5] NAMED $[ddm5] PIPE $[/sapdb/testdb/files/ddm6] NAMED $[ddm6] PIPE $[/sapdb/testdb/files/ddm7] NAMED $[ddm7] CONTENT INCREMENTAL BLOCKSIZE $[128]
dbmcli on testdb> backup_template_create $[dedupLog] TO BACKUPTOOL BACKINT PIPE $[/sapdb/testdb/files/ddm8] NAMED $[ddm8] CONTENT LOG BLOCKSIZE $[128]
SAP MaxDB Agent Backup and Restore
You must use root user instead of SIDadm user for SAP MaxDB agent backup and restore.