ADSM-L

Re: Query Volumes for a Restore

2000-07-12 13:23:25
Subject: Re: Query Volumes for a Restore
From: Joe Faracchio <brother AT SOCRATES.BERKELEY DOT EDU>
Date: Wed, 12 Jul 2000 10:23:25 -0700
No join needed, try addomg :
                  ,status   & and status="UNAVAILABLE"

I also found the following two books very helpful: :-)

Sams Teach Yourself SQL in 10 Minutes. Ben Forta
and
Understanding the new (sic) SQL: A complete guide.  melton & simon

the latter is an old SQL book which fits purfect with ADSM since its
a SQL 92/93 reference


We use as a strict convention (without DRM) that any COPYPOOL that is
going offsite must be FULL and marked OFFSITE after we check them out.
The system marks tapes as READONLY or UNAVAILABLE depending on the error
it encounters (readonly=io hit; unavailable=tape outside 'bot requested)
both are no-nos we watch for and correct.

cheers ... joe.f.

Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Tue, 11 Jul 2000, France, Don (Pace) wrote:

> Thanx, Joe & John --- this is quite cool... would be even nicer if we could
> get just the list of tapes that are currently "NOT AVAILABLE" (ie, stored
> outside the silo)... Can we do a join with the volumes table so select will
> only display the unique volumes not in the silo???
>
> Ultimately, one wants to do that *and* limit the query results to the files
> that match a restore filespec pattern.  That's what...
>
>          restore x:\...\xyz\...\* -preview=yes
>
> might display, if we could get it -- IMHO.
>
> Regards,
> Don
>
> Don France
>
> Technical Architect, P.A.C.E.
> San Jose, CA
> mailto:dfrance AT pacbell DOT net
> PACE - http://www.pacepros.com
> Bus-Ph:   (408) 257-3037
>
> > -----Original Message-----
> > From: Joe Faracchio [mailto:brother AT socrates.Berkeley DOT EDU]
> > Sent: Monday, July 10, 2000 1:10 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Query Volumes for a Restore
> >
> > I tried this and found adding 'distinct' and 'where
> > stgpool_name='ONSITE'"
> > ( or ='OFFSITE' )   help cut down the noise.
> >
> > as in:
> >
> > select distinct node_name,volume_name,stgpool_name from
> > volumeusage where
> > node_name='$1' and stgpool_name='ONSITE'
> >
> >              ... joe.f.
> >
> > Joseph A Faracchio,  Systems Programmer, UC Berkeley
> >
> > On Fri, 30 Jun 2000, Price, John wrote:
> >
> > > Try this,
> > > select node_name,volume_name,stgpool_name from volumeusage where
> > > node_name='$1'
> > >
<Prev in Thread] Current Thread [Next in Thread>