Troubleshooting
Problem
DB backups stay in Tivoli Storage Manager server although the backups have exceeded the defined DRMDBBACKUPEXPIREDAYS period.
Cause
DRMDBBACKUPEXPIREDAYS applies to both a snapshot and a full plus incremental database backup series. Any type of database backup series is eligible for expiration if all of the following are true:
- The age of the last volume of the series has exceeded the expiration value set by this command.
- For volumes that are not virtual volumes, all volumes in the series are in the VAULT state.
- The volume is not part of the most recent database backup series.
In this case, the issue is the DB Backup volumes are not in VAULT state.
Environment
Tivoli Storage Manager Server Disaster Recovery Manager
Diagnosing The Problem
- Run the following command to query the expiration days configured.
QUERY DRMSTATUS
For example :
DB Backup Series Expiration Days: 5 Day(s)
- Run the following commands to verify the database backups and snapshots that have not yet expired.
QUERY VOLHIST Type=DBB
QUERY VOLHIST Type=DBS
In this case, it showed many database backups and snapshots not expired. - Run the following commands to verify the mountable state of the backups
QUERY DRM Source=DBBackup
QUERY DRM Source=DBsnapshot
In this case, it showed all tapes were in MOUNTABLE state, instead of VAULT.
Resolving The Problem
Use the below steps.
- Run the following command to set the mountable volumes to vault.
MOVE DRM wherestate=mountable tostate=vault
- Verify step 1 is done successfully and run the following commands to verify the DB backups DRM status.
QUERY DRM Source=DBB
QUERY DRM Source=DBS
- Run the following command to expire DB backups:
EXPIRE INV Type=Other
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21584678