IBM Support

Data Protection for Oracle backup performance

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.

[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Data Protection for Oracle","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21635104