Ryan - Look into online SQL info regarding efficient queries:
some forms can be painful.
In your case, use the SQL clause IN rather than using a string of ORs:
...WHERE MSGNO IN (4005,4007,4018,4037,4987)...
Richard Sims
On Sep 21, 2005, at 6:07 PM, Ryan Cooper wrote:
Hey got a few questions.
First my goal is to deliver a report that contains Client
Schedules, and
Files missed to each person who is listed as a contact for a node.
This
report must only include data for nodes that they are a contact for.
So I create a Report with the following.
Client Schedule Status Select node_name from nodes where contact like
'%%Contact name%%'
Then I added a new item with the following statement select
nodename,substr(char(date_time), 1, 16) as TME,message from
actlog where
(msgno=4005 or msgno=4007 or msgno=4018 or msgno=4037 or
msgno=4987) and
(date_time between current_timestamp - 24 hours and
current_timestamp) and
nodename in (select node_name from nodes where contact like '%contact
name%') order by nodename asc
This works great but I'm wondering A: is this the best way to get this
report done? B: If this one report takes 15 minutes to run what is
going
to happen to the server if I run 25 of these reports at about the same
time?
Also does anyone know what process name this shows up on the server
as.
TSM Version 5.2 Level 4.1 On AIX
Thanks for any help or input.
Ryan Cooper
