• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Speed up db backup of TSM

DavrosDalek

ADSM.ORG Member
Joined
Jan 15, 2009
Messages
23
Reaction score
1
Points
0
Hi All

I run a maintenance script that backs up the tsm db, devconf, volh and then protects my stgpool/replicates to a remote server.

Is there any way to speed up the tsm db backup ? Is it possible to stripe it like a sql tdp backup ?

My current command within the maintenance script to back the tsm db is as follows

backup db type=full devc=dbfulldevc scratch=yes wait=yes

Craig
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,703
Reaction score
611
Points
0
Location
Canada
Website
www.ibm.com
You can increase the NUMStreams, the default is 1. You can either do it within the backup command, or set it permanently using SET DBRECOVERY.

NUMStreams

Specifies the number of parallel data movement streams to use when you back up the database. The default value is 1, and the maximum number is 32. Increasing this value causes a corresponding increase in the number of database backup sessions to be used and in the number of drives to be used for the device class. A NUMSTREAMS value that is specified in the BACKUP DB command overrides any value set in the SET DBRECOVERY command. The NUMSTREAMS value is used for all types of database backups.​
If a value is specified that is greater than the number of drives available for the device class, the number of available drives are used. The available drives are defined to the device class by the MOUNTLIMIT parameter or by the number of online drives for the specified device class. The session is displayed in the QUERY SESSION output.​
If you increase the number of streams, more volumes are used from the corresponding device class for this operation. Using more volumes might improve the speed of the database backups, but at the cost of more volumes that are not fully used.​
 

erwanns

ADSM.ORG Senior Member
Joined
Mar 29, 2006
Messages
141
Reaction score
10
Points
0
Location
France
If network bandwidth is the bottleneck, you may also consider using compression (compress=yes) option.
 

mikeymac

ADSM.ORG Moderator
Joined
Jun 20, 2003
Messages
960
Reaction score
33
Points
0
Location
Syracuse, NY
Website
Visit site
Also, if the database has undergone lots of growth and lots of reduction in objects stored, you may find that you're in need of a formal maintenance window to run some reorganization tasks against the database. Can shave an hour or two off a large TSM DB backup.
 

Trident

TSM/Storge dude
ADSM.ORG Moderator
Joined
Apr 2, 2007
Messages
546
Reaction score
64
Points
0
Location
Oslo, Norway
Website
www.basefarm.no
Hi,
For some table reorg:


And in particular, look at

 

Attachments

janhoelscher

Newcomer
Joined
Aug 19, 2019
Messages
3
Reaction score
0
Points
0
Hey, maybe you want to use Shared Memory. In my case it helped speed up DB Backup.

I have written this down in German and on AIX as an OS.

 

RecoveryOne

ADSM.ORG Senior Member
Joined
Mar 15, 2017
Messages
307
Reaction score
68
Points
0
Hey, maybe you want to use Shared Memory. In my case it helped speed up DB Backup.

I have written this down in German and on AIX as an OS.

I've been using shared memory for the database backup for a while now. It has greatly reduced the backup time of the database. It also helped reduce network congestion when clients were trying to backup to the server during the database backup window (I know not perfect).
 

janhoelscher

Newcomer
Joined
Aug 19, 2019
Messages
3
Reaction score
0
Points
0
Hey folks,

i have translated this article to EN, maybe its helpful.

Reg. Jan

 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 20 19.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 63 60.0%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.4%
  • Other (please comement)

    Votes: 9 8.6%

Forum statistics

Threads
31,828
Messages
135,735
Members
21,789
Latest member
Fred49
Top