Use these 8 commands to efficiently schedule TSM Expire Inventory Process

Tivoli Storage Manager Expire Inventory command might take several minutes to hours some times which results in slowness of the TSM Server. This process will removes client backup and archive file copies from server storage based on policy specified in the backup and archive copy groups of the management classes to which the files are bound. This command should be scheduled to run only when the TSM server is not busy. There are several ways to minimize the processing time of this EXPIRE INVENTORY command to make sure the TSM Server runs smoothly. With SQL queries you can actually know how many files are eligible for expiration at a particular time and also you can use NODE, DOMAIN, TYPE, DURATION, AND RESOURCE parameters along with this command according to your convenience. 

Managing IBM Tivoli Storage Manager EXPIRE INVENTORY Process

Some important tips to monitor or manager TSM Expire Inventory Process

1) It is always a best method to stop automatic TSM Expire Inventory Process everytime any client files are eligible for expiration. set EXPINTERVAL server option to zero to stop automatic expiration and define an admin schedule at times when the TSM server is less busy.
Setopt expinterval 0

2) You can kill a running EXPIRE INVENTORY process by using CANCEL PROCESS command and you can also start it manually by using EXPIRE INV command.
3) To run expiration only for one hour, use this command
expire inventory duration=60

4) If you want to know how many files are eligible for expiration, run the following sql command.
select activity,cast ((end_time) as date) as "Date",(examined/cast ((end_time-start_time) seconds as decimal (18,13))*3600) "Obj/Hr" from summary where activity='EXPIRATION' and days (end_time) - days (start_time) = 0

ACTIVITY                     Date                                       Obj/Hr
------------------                 ----------                       ---------------------------------
EXPIRATION             2013-11-14                               2829600
EXPIRATION             2013-11-14                               1224000
EXPIRATION             2013-11-15                               2984400

5) If you dont want to expire the directories but expire all the files in it, use the following command.
expire inventory skipdirs=yes

This will prevent deletion of directories, and expiration processing can occur more quickly

6) If you want to expire only particular nodes data or all nodes data in a domain, use
expire inventory node=nodename
expire inventory domain=domainname

7) If you want to expire inventory of all the archive data of all nodes in a particular domain, use 
expire inventory domain=domainname type=archive

Also Read: Run these commands to completely uninstall TSM Server

8) When expiring multiple nodes data you can set parallel expire inventory threads to minimize the processing time by using RESOURCE parameter. Multiple parallel threads will run by the server within the single expiration process (expiration still runs as a single process)
expire inventory node=node1,node2,node3 resource=3

The above expiration processing will start 3 threads within a single EXPIRE INVENTORY process.

3 Responses to "Use these 8 commands to efficiently schedule TSM Expire Inventory Process"

  1. Use this command to cancel a process with an unknown process number that is running as a result of an inventory expiration operation.

    Use the CANCEL EXPIRATION command if the expiration process number is not known, otherwise use the CANCEL PROCESS and specify the process number of the expiration process. Both commands call the same code to end the expiration process.

    You can use the CANCEL EXPIRATION command to automate the cancellation of an expiration process. For example, if you start inventory expiration at midnight and, due to the maintenance workload on the server, the process must finish at 03:00, you can schedule a CANCEL EXPIRATION command to run at 03:00 without knowing the process number.

  2. This comment has been removed by the author.

  3. Select command is not working
    select activity,cast ((end_time) as date) as "Date",(examined/cast ((end_time-start_time) seconds as decimal 18,13))*3600) "Obj/Hr" from summary where activity='EXPIRATION' and days (end_time) - days (start_time) = 0