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 [EMAIL PROTECTED] ============= What if there were no rhetorical questions? ==============
