Troubleshooting
Problem
This document provides an example on how the tuning of the DISKBUFFSIZE Tivoli Storage Manager API option may provide performance improvement with the backup of Data Protection for Oracle database.
Cause
Tivoli Storage Manager API client DISKBUFFSIZE option tuning needed.
Diagnosing The Problem
In this case, the DP Oracle backup is done via LAN-Free using the following Tivoli Storage Manager API options :
COMPRESSION ON
ENABLECLIENTENCRYPTKEY YES
ENCRYPTKEY SAVE
INCLUDE.ENCRYPT /.../*
DISKBUFFSIZE 32
The Oracle backup was initiated with RMAN script using BLKSIZE=262144 with the allocate channel. For example :
allocate channel ch1 type 'SBT_TAPE' parms 'BLKSIZE=262144,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
The DP Oracle backup completed with the following statistics :
ANU2526I Backup details for backup piece <name> (database "dbname").
Total bytes sent: 1810890752.
Total processing time: 00:03:44.
Throughput rate: 7894.86Kb/Sec.
Compressed: Yes , 59%.
Encryption: AES_128BIT.
LAN-Free: Yes.
Resolving The Problem
In this example, after adjusting the DISKBUFFSIZE option from 32 to 256, the DP Oracle backup performance improved with the following statistics :
ANU2526I Backup details for backup piece <name> (database "dbname").
Total bytes sent: 1810890752.
Total processing time: 00:02:14.
Throughput rate: 13197.37Kb/Sec.
Compressed: Yes , 59%.
Encryption: AES_128BIT.
LAN-Free: Yes.
Adjust the DISKBUFFSIZE option value as needed, to be equal or lower than the Oracle BLKSIZE value. If not specified with the RMAN script, the BLKSIZE value defaults to 262144.
Document Information
Modified date:
17 June 2018
UID
swg21635104