Veritas-bu

[Veritas-bu] tapes expiring

2002-06-25 21:54:13
Subject: [Veritas-bu] tapes expiring
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Tue, 25 Jun 2002 19:54:13 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C21CB4.5EDC44A0
Content-Type: text/plain

Field 20, I thought was image expiration date not tape expiration (aging)
date.  Testing proves it out:

Find an expendable tape.  Output is tape number, type, pool, expiration
(field 20) and status.
$ sudo vmquery -a -w | awk '$1==0000269 {print $1,$3, $12,$20,$28}'
000269 DLT Main 06/10/2002 0

Expire the images on that tape...
$ sudo bpexpdate -ev 000269 -d 0 -force

Query again...
$ sudo vmquery -a -w | awk '$1==0000269 {print $1,$3, $12,$20,$28}'
000269 DLT Main 00/00/0000 0

After I expired the tape, $20 became 00/00/0000

I don't know why you have 00/00/0000 on assigned tapes, it's not supposed to
be that way.

Do a vmquery on a tape that bpmedialist says is assigned by the vmquery
command has field 20 as 00/00/0000 and post the results - You also might do
one that is both assigned in both commands and unassigned in both commands
for comparison.

-Mark

-----Original Message-----
From: Darren Dunham [mailto:ddunham AT taos DOT com]
Sent: Tuesday, June 25, 2002 5:52 PM
To: Veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] tapes expiring


> Hey Mark and everyone else....
> 
> 
> We've got the same problem here.  I did a little poking around and vmquery
> returns an expiration date (field 20) of 00/00/000 for EVERY volume! 

I think that's normal.  That's the date to toss the volume in the trash.

> It's
> not a problem with your script except that you are running vmchange on
every
> tape whether it is active or not. I don't think that it will hurt the
active
> tapes but it will waste machine cycles. Since we have thousands of tapes,
> I'm not sure that I want to do this. 

But it also checks whether it is assigned (field 28), yes?  So it won't
run on assigned tapes.  Do you have thousands of unassigned tapes?

> You can get active expiration data on active volumes using bpmedialist.
But
> that won't give you squat on expired volumes.

I think you mean it doesn't give you anything on expired images
(different from expired volumes).

> So, can anyone tell me where I can easily get expiration data for my
tapes?
> This pool thing has killed us twice in a major way.

> # Note: vmquery col  1 is tape number 
> #               col  3 is tape type 
> #               col 12 is poolname 
> #               col 20 is "assigned" date 
> 
> tapelist=`vmquery -a -w |  awk '$3 !~ /CLN/ && \ 
>                                $20 == "00/00/0000" && \ 
>                                $12 != "'$SPname'" && \ 
>                                $28 == 0 {print $1}' ` 


Just run this command and see what the output is...

vmquery -a -w |  awk '$3 !~ /CLN/ && 20 == "00/00/0000" && $28 == 0 {print
$1}' | wc

What do you get?  That should only show unassigned tapes (including
those in the scratch pool).

-- 
Darren Dunham                                           ddunham AT taos DOT com
Unix System Administrator                    Taos - The SysAdmin Company
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

------_=_NextPart_001_01C21CB4.5EDC44A0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [Veritas-bu] tapes expiring</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Field 20, I thought was image expiration date not =
tape expiration (aging) date.&nbsp; Testing proves it out:</FONT>
</P>

<P><FONT SIZE=3D2>Find an expendable tape.&nbsp; Output is tape number, =
type, pool, expiration (field 20) and status.</FONT>
<BR><FONT SIZE=3D2>$ sudo vmquery -a -w | awk '$1=3D=3D0000269 {print =
$1,$3, $12,$20,$28}'</FONT>
<BR><FONT SIZE=3D2>000269 DLT Main 06/10/2002 0</FONT>
</P>

<P><FONT SIZE=3D2>Expire the images on that tape...</FONT>
<BR><FONT SIZE=3D2>$ sudo bpexpdate -ev 000269 -d 0 -force</FONT>
</P>

<P><FONT SIZE=3D2>Query again...</FONT>
<BR><FONT SIZE=3D2>$ sudo vmquery -a -w | awk '$1=3D=3D0000269 {print =
$1,$3, $12,$20,$28}'</FONT>
<BR><FONT SIZE=3D2>000269 DLT Main 00/00/0000 0</FONT>
</P>

<P><FONT SIZE=3D2>After I expired the tape, $20 became =
00/00/0000</FONT>
</P>

<P><FONT SIZE=3D2>I don't know why you have 00/00/0000 on assigned =
tapes, it's not supposed to be that way.</FONT>
</P>

<P><FONT SIZE=3D2>Do a vmquery on a tape that bpmedialist says is =
assigned by the vmquery command has field 20 as 00/00/0000 and post the =
results - You also might do one that is both assigned in both commands =
and unassigned in both commands for comparison.</FONT></P>

<P><FONT SIZE=3D2>-Mark</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Darren Dunham [<A =
HREF=3D"mailto:ddunham AT taos DOT com">mailto:ddunham AT taos DOT 
com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, June 25, 2002 5:52 PM</FONT>
<BR><FONT SIZE=3D2>To: Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: Re: [Veritas-bu] tapes expiring</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&gt; Hey Mark and everyone else....</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; We've got the same problem here.&nbsp; I did a =
little poking around and vmquery</FONT>
<BR><FONT SIZE=3D2>&gt; returns an expiration date (field 20) of =
00/00/000 for EVERY volume! </FONT>
</P>

<P><FONT SIZE=3D2>I think that's normal.&nbsp; That's the date to toss =
the volume in the trash.</FONT>
</P>

<P><FONT SIZE=3D2>&gt; It's</FONT>
<BR><FONT SIZE=3D2>&gt; not a problem with your script except that you =
are running vmchange on every</FONT>
<BR><FONT SIZE=3D2>&gt; tape whether it is active or not. I don't think =
that it will hurt the active</FONT>
<BR><FONT SIZE=3D2>&gt; tapes but it will waste machine cycles. Since =
we have thousands of tapes,</FONT>
<BR><FONT SIZE=3D2>&gt; I'm not sure that I want to do this. </FONT>
</P>

<P><FONT SIZE=3D2>But it also checks whether it is assigned (field 28), =
yes?&nbsp; So it won't</FONT>
<BR><FONT SIZE=3D2>run on assigned tapes.&nbsp; Do you have thousands =
of unassigned tapes?</FONT>
</P>

<P><FONT SIZE=3D2>&gt; You can get active expiration data on active =
volumes using bpmedialist.&nbsp; But</FONT>
<BR><FONT SIZE=3D2>&gt; that won't give you squat on expired =
volumes.</FONT>
</P>

<P><FONT SIZE=3D2>I think you mean it doesn't give you anything on =
expired images</FONT>
<BR><FONT SIZE=3D2>(different from expired volumes).</FONT>
</P>

<P><FONT SIZE=3D2>&gt; So, can anyone tell me where I can easily get =
expiration data for my tapes?</FONT>
<BR><FONT SIZE=3D2>&gt; This pool thing has killed us twice in a major =
way.</FONT>
</P>

<P><FONT SIZE=3D2>&gt; # Note: vmquery col&nbsp; 1 is tape number =
</FONT>
<BR><FONT SIZE=3D2>&gt; =
#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; col&nbsp; 3 is tape type </FONT>
<BR><FONT SIZE=3D2>&gt; =
#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; col 12 is poolname </FONT>
<BR><FONT SIZE=3D2>&gt; =
#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; col 20 is &quot;assigned&quot; date </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; tapelist=3D`vmquery -a -w |&nbsp; awk '$3 !~ =
/CLN/ &amp;&amp; \ </FONT>
<BR><FONT =
SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $20 =3D=3D =
&quot;00/00/0000&quot; &amp;&amp; \ </FONT>
<BR><FONT =
SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $12 !=3D =
&quot;'$SPname'&quot; &amp;&amp; \ </FONT>
<BR><FONT =
SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $28 =3D=3D 0 =
{print $1}' ` </FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Just run this command and see what the output =
is...</FONT>
</P>

<P><FONT SIZE=3D2>vmquery -a -w |&nbsp; awk '$3 !~ /CLN/ &amp;&amp; 20 =
=3D=3D &quot;00/00/0000&quot; &amp;&amp; $28 =3D=3D 0 {print $1}' | =
wc</FONT>
</P>

<P><FONT SIZE=3D2>What do you get?&nbsp; That should only show =
unassigned tapes (including</FONT>
<BR><FONT SIZE=3D2>those in the scratch pool).</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Darren =
Dunham&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ddunham AT taos DOT com</FONT>
<BR><FONT SIZE=3D2>Unix System =
Administrator&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Taos - The =
SysAdmin Company</FONT>
<BR><FONT SIZE=3D2>Got some Dr =
Pepper?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; San Francisco, CA bay area</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt; This line left intentionally blank to confuse you. &gt;</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>Veritas-bu maillist&nbsp; -&nbsp; =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu"; =
TARGET=3D"_blank">http://mailman.eng.auburn.edu/mailman/listinfo/veritas=
-bu</A></FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C21CB4.5EDC44A0--