The TSM QUERY FILESPACE command, with a wildcard for nodename, takes
FOREVER. On our system, a big TSM server with about 1000 nodes, a Q
FILESPACE * * can take 20 minutes to an hour, depending on how busy the
server is doing other things.

I finally got tired of this sluggishness, and put together a simple SQL
SELECT that asked the same question, just to see what would happen. It
was fast.

What is going on here? Why should the performance difference be about
two orders of magnitude? (100x) (As I recode a bunch of scripts I have
to change Q FILESPACE into SELECT.)

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
============= What if there were no rhetorical questions? ==============