database backup retention setting

[pong3d]

Is there a setting to control how many db backups are kept? Thanks.

 

[fuzzballer]

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]

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]

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]

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]

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

 

[Bharanij]

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

 

[RajeshR]

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

yes, you can run a admin schedule or by a script.

 

[Bharanij]

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

 

[RajeshR]

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

yes this would be fine.

 

[Bharanij]

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

 

[marclant]

Today - 5 means current date/time minus 5 days. It will delete all those prior to that.

 

[Bharanij]

so it is like this

Get delete and 6th day data will be in backup for next fivedays right
(1D 2D 3D 4D 5D )6D

 

[Bharanij]

i have tested and i got it kindly ignore above comments