Question & Answer
Question
Is it possible to generate a list of backup objects that are pending expiration?
Answer
When a backup file becomes eligible for expiration, the server updates the object with a special deactivation date of 1900-01-01. During expiration, any objects with a deactivation date of 1900-01-01 are removed from the database. It is, therefore, possible to display objects that are pending expiration by querying the database for backup objects with a deactivation date of 1900-01-01, similar to the following:
select node_name,state,deactivate_date,backup_date,hl_name,ll_name from backups where deactivate_date='1956-09-05-00.00.00.000000' and type='FILE'
Note that the 'deactivate_date' specified in the select statement is '1956-09-05-00.00.00.000000', yet the date returned by the select statement is '1900-01-01 00:00:00.000000'. This is the expected behavior and is merely a result of how the timestamp is recorded in the database. The results from this query will resemble the following:
tsm: SERVER1>select node_name,state,deactivate_date,backup_date,hl_name,ll_name from backups where deactivate_date='1956-09-05-00.00.00.000000' and type='FILE'
NODE_NAME: CLIENTA
STATE: INACTIVE_VERSION
DEACTIVATE_DATE: 1900-01-01 00:00:00.000000
BACKUP_DATE: 2010-03-22 10:45:21.000000
HL_NAME: /NODE0000/
LL_NAME: FULL_BACKUP.20100322104520.1
NODE_NAME: CLIENTA
STATE: INACTIVE_VERSION
DEACTIVATE_DATE: 1900-01-01 00:00:00.000000
BACKUP_DATE: 2010-03-22 10:45:40.000000
HL_NAME: /NODE0000/
LL_NAME: FULL_BACKUP.20100322104520.2
Note: Running this select statement on a server that has a large number of backup objects can cause the query to take a very long time to complete and could potentially affect the performance of the server. It is strongly recommended that additional WHERE clauses be specified to reduce the number of objects returned by the query, as seen in the following example:
select node_name,state,deactivate_date,backup_date,hl_name,ll_name from backups where deactivate_date='1956-09-05-00.00.00.000000' and type='FILE' and node_name='CLIENTA' and hl_name='/tmp'
[{"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":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]
Product Synonym
TSM adsm spectrum protect
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21610521