• 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.

Best sequence for DB Backup?

#1
I've inherited an existing TSM installation with DRM, which runs nicely and I'm learning fast. Here's my question: "When is the best time to perform the full database backup for DRM?"

Currently, the daily maintenance script does (among other things) the following:

Backs up the Disk pool to the Copy Pool
Backs up the Tape pool to the Copy pool
Performs a full DB backup to tape
...
...
Expires inventory
Reclaims the Tape pool
Reclaims the Copy pool

Once these are complete, we check out tapes and take them off site.

Does it make sense to backup the database before doing the expiration and reclaims? Won't the database backup have the wrong metadata about where files are located on the tapes unless it is done AFTER the expire and reclaim tasks? Thanks in advance for any enlightenment.
 

moon-buddy

ADSM.ORG Moderator
#2
I would have the DB backup after everything had completed:

Backs up the Disk pool to the Copy Pool
Backs up the Tape pool to the Copy pool
Expires inventory
Reclaims the Tape pool
Reclaims the Copy pool
Performs a full DB backup to tape
...
...
 
Last edited:

n9hmg

ADSM.ORG Senior Member
#4
I have chosen to ba stg to my DR pool, then immediately ba db, in order to minimize the time the data is unprotected. After the DR media is ejected, THEN I start the migrations, expiration, copy active, and reclamations.
 

ttrinh7975

ADSM.ORG Senior Member
#6
mi-court-buadmin-

It's really a personal preferrence...but this schedule seem to work for us...
- 21 LTO1 drives for onsite
- 12 1120 drives for offsite for Encryption.

* Daily Client scheduled 1700 - 0300 (5pm thru 3am)(Spread the work load)
* Expiration 0000 (midnight) until stop or scheduled to stop at 11am
* Storage pools and onsite backup to offsite (DR) starts at 2200 (10pm)
* 11am run the following via scheduled

1) Deletes expired DB entries
2) Backs up the DB (FULL)
3) Backs up the DB (SNAPSHOT)
4) Deletes old volhist entries
5) Backs up the device config
6) Backs up the volhistory
7) Resets the Log Maximum stat
8) Generates the DR script

* DR tapes pick up by courier at 2pm

* 2pm - 5pm storage pools migration to onsite tapes..
 

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

    Votes: 48 63.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.8%
  • Other (please comement)

    Votes: 7 9.2%

Forum statistics

Threads
31,344
Messages
133,509
Members
21,469
Latest member
guidocaffa
Top