ADSM-L

Re: Using select statements

2004-06-30 09:32:24
Subject: Re: Using select statements
From: Henrik Wahlstedt <shwl AT STATOIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 30 Jun 2004 15:32:05 +0200
Hi,

First, try to avoid select statements against backup table since it take
some time to run... (and nobody mentioned it...)
Second, look at http://people.bu.edu/rbs/ADSM.QuickFacts, there are alot of
SQL links at the end.
Third,  try select node_name, filespace_name, substr(cast(backup_end as
char(26)),1,10) as "Last Backup Date" from filespaces where backup_end
<current_timestamp - 24 hours order by "Last Backup Date". You can include
'and backup_end >current_timestamp -XYZ hours' if you want to narrow it.

//Henrik





                    Moses Show
                    <Moses.Show@S        To:     ADSM-L AT VM.MARIST DOT EDU
                    TPAUL.COM>           cc:     (bcc: Henrik Wahlstedt)
                    Sent by:             Subject:     Re: Using select 
statements
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    2004-06-30
                    13:58
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"






Hi,
I forgot to include the select statement that I have written. It takes the
following form.

"select node_name, filespace_name, date(backup_date) from backups where
((days(backup_date) - days(current_date))) >=-3"
==============================================================================

This communication, together with any attachments hereto or links contained
herein, is for the sole use of the intended recipient(s) and may contain
information that is confidential or legally protected. If you are not the
intended recipient, you are hereby notified that any review, disclosure,
copying, dissemination, distribution or use of this communication is
STRICTLY PROHIBITED.  If you have received this communication in error,
please notify the sender immediately by return e-mail message and delete
the original and all copies of the communication, along with any
attachments hereto or links herein, from your system.

==============================================================================

The St. Paul Travelers e-mail system made this annotation on 06/30/2004,
07:54:24 AM.




-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.

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