ADSM-L

Re: Operation Report customized by contact question

2005-09-22 09:13:06
Subject: Re: Operation Report customized by contact question
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Sep 2005 09:12:48 -0400
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


<Prev in Thread] Current Thread [Next in Thread>