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