EXPIRE INVENTORY has two undocumented and unsupported parameters, BEGINNODEID=nn and ENDNODEID=nn where nn are decimal node numbers. These can be used to limit the amount of work the process does but please note, these parameters are UNSUPPORTED, you use them at your own risk.
The only really good reason to run a limited EXPIRE INVENTORY is if you’ve just deleted lots of data from a node and would like to get it deleted quickly from the database. The problem is that you need to find out the node number of the filespace you just deleted the data from.
The only way I know is to use undocumented SHOW commands. You need to start with the object number for the NODE table, then drill down the b-tree to find the Node number of the file space that you are after.
Start by using SHOW OBJDIR to find the node number of the Nodes table. This is normally 38.
Then use SHOW NODE 38 to see the top level tree structure of the NODE table.
SHOW NODE 38
(SERVVM57)
<- Subtree=<8344593>
Record 9 (KeyLen=9, DataLen=4):
Then finally do a SHOW NODE number for the subtree that contains the node you are interest in.
In the SHOW NODE against the subkeys, the KEY is the NODE_NAME. Field 1 is the node number and field2 is PLATFORM_NAME.
SHOW NODE 8344593
Key:
->(SERVVM3V)<-
Data: ->(00000134)(WinNT)(plus lots more fields..)
So from that you see the the client node that you are interested in, SERVVM3V has a node number of 134.
Roger Deschner has pointed out an error in the original text of this page ‘The node numbers you get out of the database with the SHOW NODE command are in hexadecimal. However, the node numbers you specify on the EXPIRE INVENTORY command must be decimal. You’ve got to convert them from hex to decimal yourself. To expire node SERVVM3V you must specify node number 308 (decimal), rather than 134 (hex)’.
So using the correct decimal number, to just expire data from that node you would use the command
EXPIRE INVENTORY BEGINNODEID=308 ENDNODEID=308
The EXPIRE INVENTORY process runs as an atomic transaction so if you need to cancel EXPIRE INVENTORY you should always use the CANCEL EXPIRATION command, as that will terminate the command cleanly and mark the transaction as complete. Next time you run the transaction, it will start up from where it left off. If you cancel with the ‘cancel process_number ‘ command or cancel using the GUI, TSM rolls back the transaction to the beginning, so next time you run the command it will start again from the beginning.
Ref: http://www.lascon.co.uk (nice job)