On May 16, 2008, at 10:02 AM, Choudarapu, Ramakrishna (GTS) wrote:
...
Am I right Richard?
Looks good.
Thanks for posting that - I had to run to a meeting.
Richard
lf Of
Loon, E.J. van - SPLXM
Sent: Friday, May 16, 2008 9:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Speeding up my SQL query
Hi Richard!
Thank you very much for your reply!
Since I'm not much of an SQL wizzard, could you please help met with
rebuilding the query?
Kindest regar
-Eric van Loon wrote: -
>Hi *SM-ers!
>My TSM Operational Reporter creates a daily report for our Windows
>guys.
>Part of this report is a SQL query which returns all missed files.
>This
>is the query:
>
>select -
> actlog.nodename as "Node Name", -
> substr(char(actlog.date_time), 1, 1
lf Of
Richard Sims
Sent: vrijdag 16 mei 2008 15:08
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Speeding up my SQL query
Eric -
One thing you can do is use the SQL clause IN rather than a succession
of OR conditions to improve the query performance of testing for
multiple values.
Richard
@VM.MARIST.EDU
Subject: Re: Speeding up my SQL query
Eric,
Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME
and ENDTIME parameters, which may be faster than the select, but the
resluts may not be as straight and detailed as your select...
Regards, Rama
-Original Message
PROTECTED] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Friday, May 16, 2008 9:01 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Speeding up my SQL query
Hi *SM-ers!
My TSM Operational Reporter creates a daily report for our Windows guys.
Part of this report is a SQL query which returns all missed
Eric -
One thing you can do is use the SQL clause IN rather than a succession
of OR conditions to improve the query performance of testing for
multiple values.
Richard Sims
Hi *SM-ers!
My TSM Operational Reporter creates a daily report for our Windows guys.
Part of this report is a SQL query which returns all missed files. This
is the query:
select -
actlog.nodename as "Node Name", -
substr(char(actlog.date_time), 1, 16) as "Date/Time", -
substr(actlog.messa
