You achieved TSM redirection by virtue of having a space before and after the '>' in FILE_SIZE > 10000000000 If you remove the space before the '>', it will do what you want. This is described in ADSM QuickFacts, under entry ">".
The greater issue: Performing a Select against the Contents table is basically suicidal: it's the worst table to query, where a query could run for days and cripple your TSM server. I would instead recommend inspecting the accounting log for a session with data of that size, and 1 or few objects. Likewise you could scan the ANE messages in the Activity Log, or have a look at the Summary table, for recent sessions. You don't say how you know about that file having been backed up: that may lead to more concise ways to determine its origin. Richard Sims