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

How Do You Handle Your DB Backup Volumes ?

buster99

ADSM.ORG Member
#1
Hello, I have an open PMR with IBM regarding a .DSS file issue and while researching the issue for us, the IBM Support Tech looked into our current tape volume setup and told us that we are handling our DBB and DBS tape volumes incorrectly. I wanted to check here and see if he is correct.

We currently run a DBS backup to tape and send it offsite everyday with a 7 day retention.
We also run a DBB backup daily that stays in our library with a 7 day retention.

He says that we should be sending the DBB backup offsite and keeping the DBS backup onsite. Is that correct ?

Thank you
 

buster99

ADSM.ORG Member
#3
OK, we have been sending the daily DBS backup offsite for years and keeping the DBB onsite. We run a DBS and then a DBB daily

This is from a TSM Disaster Recovery Manager Manual...


There are two types of database backups that are typically used for recovery; full


database backups and snapshot backups. Full database backups are typically done on a


daily basis after all copy storage pools have been updated and they are stored on-site.


Snapshot database backups are full database backups, but they do not reset the


recovery log. Snapshot database backups are typically used for off-site disaster recovery


purposes. They are made on a daily basis following production of a copy storage pool


and are sent off-site with the rest of the daily tapes.
 

moon-buddy

ADSM.ORG Moderator
#4
The key words here are:

Snapshot database backups are full database backups, but they do not reset the recovery log.

You can send them offsite if you wish but the FULL DB backup is the desired DR recovery mode. I never use snapshots as I see these as useless. I need the recovery logs reset.
 

marclant

ADSM.ORG Moderator
#5
But, if you do a DR at an alternate location because the primary location is down, you don't have the logs anyway, so backup or snapshot, both contain the same thing and both without the logs.
 

Rigido

ADSM.ORG Senior Member
#6
I remember when IBM introduced DBS on TSM and I'm pretty sure colleagues told me that it was introduced just for DR purposes. Some sort of a "different full db backup" (I always thought to a dump/export) that do not interfere with every day backup (incremental and full) activity, that's why it doesn't reset logs.
Every DR test I did I always used DBS with no issues at all.
 

buster99

ADSM.ORG Member
#7
Thank you all for the replies to my DB Backup question. For now we are going to keep our process steps the same...DBB onsite and DBS offsite since that has been working for us. I'm going to be making some changes that allow us to automatically delete the unnecessary .DSS files from our storage directories and volhist.

Thanks again
 

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

    Votes: 16 53.3%
  • Let's be formal and just say Spectrum Protect

    Votes: 4 13.3%
  • Other (please comement)

    Votes: 3 10.0%

Forum statistics

Threads
30,888
Messages
131,415
Members
21,194
Latest member
jamesmacd40