SAP DB2 TSM expired backup

[Former Member]

Hi Gurus,

We are using TSM to taking SAP online backup weekly basis.Storage team wants to delete some old backup from TSM due to space constrain.Please let us know how to delete the old backup in TSM from DB2 level also provided the configuration details below,

Number of database backups to retain   (NUM_DB_BACKUPS) = 12

Recovery history retention (days)     (REC_HIS_RETENTN) = 60

Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

Also when i execute LIST HISTORY BACKUP ALL FOR DB <SID>"  Showing old backup from 29th June. I able to see Timestamp+Sequence from 20140629043003001  - 20140629043003012. Why same backup image showing 12 sequence.Please help me on this.

Number of matching file entries = 193

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID

-- --- ------------------ ---- --- ------------ ------------ --------------

  B  D  20140629043003001   N    O  S0111900.LOG S0112016.LOG

Regards,

MK

[maria_shen]

Hello

1. Please set AUTO_DEL_REC_OBJ to ON.

2. Normally the 12 sequence means there were 12 sessions opened for the backup.

Kind regards
Maria 

[Former Member]

Hi,

Please let me know the use of below parameter.

Number of database backups to retain   (NUM_DB_BACKUPS) = 12

Recovery history retention (days)     (REC_HIS_RETENTN) = 60

Auto deletion of recovery objects    (AUTO_DEL_REC_OBJ) = OFF

Also how to delete expired backup in TSM.

Regards,

MK

[Former Member]

Hi Manikandan Kamatchichettiyar,

First of all you have to decide whether you do a manual or automatic backup deletion for obsolete backups which you can run with

db2adutl delete...

or setting AUTO_DEL_REC_OBJ = ON.

For the other parameter of auto pruning read the document carefully.

Both deletion depends on your backup and recovery scenario with the SLA's how long you would keep your backups.

Best regards

Joachim