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

database backup retention setting

fuzzballer

ADSM.ORG Member
#2
In version 5.5.x you can query the drmstatus (q drmstat) to see the settings and you use the following command to set the days kept.

Set DRMDBBackupexpiredays--days
 

pappumobile

ADSM.ORG Member
#3
its little different for TSM database retension, if you use tape to backup database, this tape doen't come to scratch until you run 'delete volhistory' command.
Assume you are running database backup daily and its going to tape, and you are also running 'delete volhistory' command which is deleting volumes which are used for database backup older than 5 day. it means you are keeping 5 versions of TSM database.
 

tariq.kaifi

Active Newcomer
#4
its little different for TSM database retension, if you use tape to backup database, this tape doen't come to scratch until you run 'delete volhistory' command.
Assume you are running database backup daily and its going to tape, and you are also running 'delete volhistory' command which is deleting volumes which are used for database backup older than 5 day. it means you are keeping 5 versions of TSM database.
This can be fine only if you do not use DRM.

If DRM is in use, fuzzballer post is true.
 

jsasso

Active Newcomer
#5
This can be fine only if you do not use DRM.

If DRM is in use, fuzzballer post is true.
Depends. Even if you are use DRM, it´s recommended that use both of methods to backup database.

To control retention for DRM (offsite Database Backup) - Set DRMDBBackupexpiredays 3
To control retention for (Onsite Database Backup) - del volhist todate=today-5 t=dbb

The deletion it´s different because Offsite Database Backup have type=dbs and Onsite Database Backup have type=dbb

Regards,
 

rore

ADSM.ORG Senior Member
#6
Depends. Even if you are use DRM, it´s recommended that use both of methods to backup database.

To control retention for DRM (offsite Database Backup) - Set DRMDBBackupexpiredays 3
To control retention for (Onsite Database Backup) - del volhist todate=today-5 t=dbb

The deletion it´s different because Offsite Database Backup have type=dbs and Onsite Database Backup have type=dbb

Regards,
Not accurate. Offsite database backups can be dbs or dbb. It depends on how the TSM admin is doing the backup and how it is using the move drmedia command (source parameter).
DRMDBBackupexpiredays will expire any type database backup that reach the expiration retention AND (is in VAULT state or server volume) AND it is not part of the most recent backup series.

What you maybe tried to say is that it is a good idea to take dbb backups to keep them onsite and take dbs to send them offsite. That way by using 'del volhist t=dbb' will not mess with the offsite backups that should be managed by DRM (DRMDBBackupexpiredays).

Some reference: http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/topic/com.ibm.itsm.srv.ref.doc/r_cmd_volhistory_delete.html?resultof="DRMDBBackupexpiredays" "drmdbbackupexpiredai" "volhistory" "volhistori"

Rudy
 
Last edited:

Bharanij

ADSM.ORG Member
#7
is possible to do administrator schedule for "To control retention for (Onsite Database Backup) - del volhist todate=today-5 t=dbb" ?
 

Bharanij

ADSM.ORG Member
#9
then can i create like this or do i need to add some other steps

define schedule DB_expire type=administrative cmd="del volhist todate=today-5 t=dbb" active=yes description="DB Expire" dayofweek=any starttime=10:00 startdate=today
 

Bharanij

ADSM.ORG Member
#11
some explain this

del volhist todate=today-5 t=dbb

today-5 mean :- from today 5thday old volhist delet or it will delet today and 5day history

Rdgs,
Bharani
 

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

    Votes: 52 63.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.0%
  • Other (please comement)

    Votes: 7 8.5%

Forum statistics

Threads
31,385
Messages
133,681
Members
21,495
Latest member
patbel
Top