On Wednesday 23 July 2008, Loon, E.J. van - SPLXM wrote: > Hi *SM-ers! > I'm trying to create an SQL query to extract failed files from the > activity log. > When I do a select * from actlog all goes well, but as soon as I replace > the * with things like nodename, date_time, message to filter the > output, the query becomes slower and slower. > Is there a possibility in TSM to put the output of a slightly filtered q > actlog (eg. Select * from actlog where originator='CLIENT') in a > temporary table space which one can use in different queries later on? It is faster / easier to do a select * from actlog and dump the output to a file. I prefer perl to process the content of the file.
Stef
