Re: SQL statement help

Andy,

Thank you very much for your help, the results are exactly what I was
looking for.




Andrew Raibeck <storman AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/28/2005 04:06 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: [ADSM-L] SQL statement help






See http://msgs.adsm.org/cgi-bin/get/adsm0501/349/1.html for a suggested
workaround. Refer to APARs IC28825 and IC34609 (at http://www.ibm.com) for
more info describing limitations of querying the EVENTS table.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-02-28
14:40:48:

> The following command returns those backups that were missed or failed:
>
> select node_name,contact from nodes -
> where node_name in (select node_name from events where -
> (scheduled_start between '2005-01-31 15:39:26' and -
> '2005-02-27 15:39:25') and -
> LENGTH(domain_name) IS NOT NULL and -
> (status='Failed' OR status='Missed'))
>
> I have modified the sql select statement for the last week and nothing
is
> returned.
> select node_name,contact from nodes -
> where node_name in  -
> (select node_name from events where -
> (scheduled_start>=current_timestamp - 7 days) and -
> LENGTH(domain_name) IS NOT NULL and -
> (status='Failed' OR status='Missed'))
>
> OR
>
> select node_name,contact from nodes -
> where node_name in -
> (select node_name from events where -
> (substr(cast(scheduled_start as char(26)),1,19) between '2005-01-31
> 15:39:26' and -
> substr(cast(current_timestamp as char(26)),1,19) and -
> LENGTH(domain_name) IS NOT NULL and -
> (status='Failed' OR status='Missed')))
>
> Any ideas on why the 2nd/3rd sql statement does not return anything?
>
>
> thanks
>  JR