ADSM-L

Re: SQL Help

2006-06-05 06:52:38
Subject: Re: SQL Help
From: Henrik Wahlstedt <SHWL AT STATOIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 5 Jun 2006 12:52:15 +0200
Hi,

What information do you want?
To check if the backups are run: q ev * * begind=-3 endd=today
n=DOCCM_DB2

To check if some files are backuped, you can check backup table, but
your select will take a long time to compute... That is the fun 
part with the backup table.
Add filespace name in the select, "...from backups where
node_name='STO-W24-TDP' and filespace_name='STO-LNS01.DOMLOGS'..."


//Henrik





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Dourado
Sent: den 5 juni 2006 12:05
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL Help
Importance: High

Hi,

What do I need to add to this SQL statement,  to only list backups done
in the last  3 days ?

 select  *  from backups where node_name = 'DOCCM_DB2'

I have had several unsuccessful attempts .

Thanks in Advance.

Bill




******************************* Disclaimer
******************************* This email and any files transmitted
with it contains privileged and confidential information and is intended
for the addressee only. If you are not the intended recipient you must
not disseminate, distribute or copy this email. Please notify the sender
at once that you have received it by mistake and then delete it from
your system.

Any views expressed in this email are those of the sender and not
necessarily those of ALSTEC or its associated companies.

Whereas ALSTEC takes reasonable precautions to ensure this email is
virus free, no responsibility will be accepted by it for any loss or
damage whether direct or indirect which results from the contents of
this email or its attachments.

ALSTEC Group Limited - Registered in England No.3939840 - www.alstec.com
Registered office: Cambridge Road, Whetstone, Leicester. LE8 6LH.
England.
Telephone: +44 (0)116 275 0750


-------------------------------------------------------------------
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>