• 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
21
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,660
Reaction score
597
Points
0
Location
Canada
Website
www-947.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
140
Reaction score
9
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
959
Reaction score
32
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
536
Reaction score
61
Points
0
Location
Oslo, Norway
Website
www.basefarm.no
Hi,
For some table reorg:


And in particular, look at

 

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: 19 18.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 61 59.8%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.7%
  • Other (please comement)

    Votes: 9 8.8%

Forum statistics

Threads
31,795
Messages
135,569
Members
21,775
Latest member
oscar
Top