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