Boy! When they say there's more than one way to skin a cat its true .
One more:
if you sometimes accidently checkin scratches as Private
you can find them, along with any truly Private tapes check'd in but not
mounted nor used even once with :
select volume_name,status from libvolumes
>Call me a Unix junkie, but I prefer this little Unix Command from a prompt
You're a Unix junkie.
If you run a 3494, you can do:
mtlib -l /dev/lmcp0 -qC -s ___
where the scratch category must be supplied, in hex.
Richard Sims, BU
old, but not that junky yet
er
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: Query Scratch Volumes
What would the syntax be for a query to only show scratch volumes?
This e-mail including any attachments is confidential and
respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: George Lesho/Partners/AFC)
Fax to:
Subject: Re: Query Scratch Volumes
select volume_name, status from libvolumes where (status='Scratch')
-Original Message-
From: S
Steve
This command may help you.
select count(*) from libvolumes where status='Scratch'
It may be worth your while to setup a server command script. We defined one as Q_TAPE
that runs the following commands. Now we get a fairly detailed look into our tape
situation by simply entering RUN Q_TAPE
select access as "Access (All Tapes)", count(*) as "# Tapes" from volumes where
devc
nt: Friday, February 23, 2001 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: Query Scratch Volumes
>
> What would the syntax be for a query to only show scratch volumes?
select volume_name, status from libvolumes where (status='Scratch')
-Original Message-
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 8:13 AM
To: [EMAIL PROTECTED]
Subject: Query Scratch Volumes
What would the syntax be for a query to only sh
select volume_name from libvolumes where status = 'Scratch'
will list all scratch volumes
We use
select count(*) from libvolumes where status = 'Scratch'
to get the number of scratch tape
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 02/23/01 10:13AM >>>
What would the syntax be for a query to
select volume_name,status from libvolumes where status='Scratch'
Or you can do select * from ... and get all info or decide on parameters you want.
Note carefully case of 'Scratch'.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.43
What would the syntax be for a query to only show scratch volumes?
11 matches
Mail list logo
