Veritas-bu

[Veritas-bu] Drive Utilization

2002-03-28 16:16:17
Subject: [Veritas-bu] Drive Utilization
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Thu, 28 Mar 2002 14:16:17 -0700
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_01C1D69D.CC7258E0
Content-Type: text/plain

The "bpdbjobs -report" has all of this except which drive was utilized.  

Also checkout "bpdbjobs -report -all_columns".  

See the FAQ in Storage Mountain for a description of the columns.

http://www.backupcentral.com/cgi-bin/netbackup-fom?_highlightWords=bpdbjobs&;
file=194

Anyway, bpdbjobs has start time, stop times, KB transferred (calc to get
rates), server, class, etc.

To get the drive information, you have to go parse the database.

-Mark

-----Original Message-----
From: Jeff A. Earickson [mailto:jaearick AT colby DOT edu]
Sent: Thursday, March 28, 2002 1:40 PM
To: Gary Sperano
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Drive Utilization


Hi,
   Funny, but I needed the same info the other day, when I wanted to know
what machine/class was backing up to what drive, when, and what tape it
was writing to.  Hey Veritas, how come no nice report to tell you?

* start time of backup job
* stop time of backup job
* elapsed time and thruput rate
* what drive got used and what tape got written to

Really cool would be a GUI barchart that showed, on a per drive basis,
machine backups over time.

Anyway, I cooked up the attached shell script to go thru every class,
show what happened in the previous 24 hours (weeding out trivial messages),
and give me real timestamps as well.  The output is not pretty but the
info is all there for a backup or restore.  Output looks like:

============== diamond
Wed Mar 27 18:07:35 2002 added backup job for client diamond, class diamond,
schedule Full part 0 to NetBackup scheduler work queue
Wed Mar 27 18:25:25 2002 started backup job for client diamond, class
diamond, schedule Full on storage unit slate-dlt-robot-tld-0
Wed Mar 27 18:25:27 2002 client diamond handling path ALL_LOCAL_DRIVES
Wed Mar 27 18:25:39 2002 begin writing backup id diamond_1017271525, copy 1,
fragment 1, to media id QWC775 on drive index 1
Wed Mar 27 19:10:09 2002 successfully wrote backup id diamond_1017271525,
copy 1, fragment 1, 8677536 Kbytes at 3271.484 Kbytes/sec
Wed Mar 27 19:10:11 2002 CLIENT diamond CLASS diamond SCHED Full EXIT STATUS
0 (the requested operation was successfully completed)
Thu Mar 28 10:18:54 2002 Media id QZF816 is needed for the restore.
Thu Mar 28 10:24:28 2002 begin reading backup id onyx_1015153648 (restore),
copy 1, fragment 1 from media id QZF816 on drive index 1
Thu Mar 28 10:24:29 2002 successfully restored from backup id
onyx_1015153648, copy 1, 160 kbytes

** Jeff A. Earickson, Ph.D                         PHONE: 207-872-3659
** Senior UNIX Sysadmin, Information Technology    EMAIL: jaearick AT colby DOT 
edu
** Colby College, 4214 Mayflower Hill,               FAX: 207-872-3076
** Waterville ME, 04901-8842
----------------------------------------------------------------------------

On Thu, 28 Mar 2002, Gary Sperano wrote:

> Date: Thu, 28 Mar 2002 14:43:14 -0500
> From: Gary Sperano <gsperano AT powertel DOT com>
> To: veritas-bu AT mailman.eng.auburn DOT edu
> Subject: [Veritas-bu] Drive Utilization
>
>
>
> Does anybody have any good scripts (ksh, perl, etc) that reports drive(s)
> utilization or know where to obtain this type of process from?
>
> Gary A. Sperano Jr
> Technical Specialist
> VoiceStream
> PCS: 404-610-9566
> Desk: 770-604-3165
> Gsperano AT powertel DOT com
>
>
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>

------_=_NextPart_001_01C1D69D.CC7258E0
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] Drive Utilization</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>The &quot;bpdbjobs -report&quot; has all of this =
except which drive was utilized.&nbsp; </FONT>
</P>

<P><FONT SIZE=3D2>Also checkout &quot;bpdbjobs -report =
-all_columns&quot;.&nbsp; </FONT>
</P>

<P><FONT SIZE=3D2>See the FAQ in Storage Mountain for a description of =
the columns.</FONT>
</P>

<P><FONT SIZE=3D2><A =
HREF=3D"http://www.backupcentral.com/cgi-bin/netbackup-fom?_highlightWor=
ds=3Dbpdbjobs&file=3D194" =
TARGET=3D"_blank">http://www.backupcentral.com/cgi-bin/netbackup-fom?_hi=
ghlightWords=3Dbpdbjobs&file=3D194</A></FONT>
</P>

<P><FONT SIZE=3D2>Anyway, bpdbjobs has start time, stop times, KB =
transferred (calc to get rates), server, class, etc.</FONT>
</P>

<P><FONT SIZE=3D2>To get the drive information, you have to go parse =
the database.</FONT>
</P>

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

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jeff A. Earickson [<A =
HREF=3D"mailto:jaearick AT colby DOT edu">mailto:jaearick AT colby DOT 
edu</A>]</FONT>=

<BR><FONT SIZE=3D2>Sent: Thursday, March 28, 2002 1:40 PM</FONT>
<BR><FONT SIZE=3D2>To: Gary Sperano</FONT>
<BR><FONT SIZE=3D2>Cc: veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: Re: [Veritas-bu] Drive Utilization</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi,</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp; Funny, but I needed the same info the =
other day, when I wanted to know</FONT>
<BR><FONT SIZE=3D2>what machine/class was backing up to what drive, =
when, and what tape it</FONT>
<BR><FONT SIZE=3D2>was writing to.&nbsp; Hey Veritas, how come no nice =
report to tell you?</FONT>
</P>

<P><FONT SIZE=3D2>* start time of backup job</FONT>
<BR><FONT SIZE=3D2>* stop time of backup job</FONT>
<BR><FONT SIZE=3D2>* elapsed time and thruput rate</FONT>
<BR><FONT SIZE=3D2>* what drive got used and what tape got written =
to</FONT>
</P>

<P><FONT SIZE=3D2>Really cool would be a GUI barchart that showed, on a =
per drive basis,</FONT>
<BR><FONT SIZE=3D2>machine backups over time.</FONT>
</P>

<P><FONT SIZE=3D2>Anyway, I cooked up the attached shell script to go =
thru every class,</FONT>
<BR><FONT SIZE=3D2>show what happened in the previous 24 hours (weeding =
out trivial messages),</FONT>
<BR><FONT SIZE=3D2>and give me real timestamps as well.&nbsp; The =
output is not pretty but the</FONT>
<BR><FONT SIZE=3D2>info is all there for a backup or restore.&nbsp; =
Output looks like:</FONT>
</P>

<P><FONT SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =
diamond</FONT>
<BR><FONT SIZE=3D2>Wed Mar 27 18:07:35 2002 added backup job for client =
diamond, class diamond, schedule Full part 0 to NetBackup scheduler =
work queue</FONT></P>

<P><FONT SIZE=3D2>Wed Mar 27 18:25:25 2002 started backup job for =
client diamond, class diamond, schedule Full on storage unit =
slate-dlt-robot-tld-0</FONT></P>

<P><FONT SIZE=3D2>Wed Mar 27 18:25:27 2002 client diamond handling path =
ALL_LOCAL_DRIVES</FONT>
<BR><FONT SIZE=3D2>Wed Mar 27 18:25:39 2002 begin writing backup id =
diamond_1017271525, copy 1, fragment 1, to media id QWC775 on drive =
index 1</FONT></P>

<P><FONT SIZE=3D2>Wed Mar 27 19:10:09 2002 successfully wrote backup id =
diamond_1017271525, copy 1, fragment 1, 8677536 Kbytes at 3271.484 =
Kbytes/sec</FONT></P>

<P><FONT SIZE=3D2>Wed Mar 27 19:10:11 2002 CLIENT diamond CLASS diamond =
SCHED Full EXIT STATUS 0 (the requested operation was successfully =
completed)</FONT></P>

<P><FONT SIZE=3D2>Thu Mar 28 10:18:54 2002 Media id QZF816 is needed =
for the restore.</FONT>
<BR><FONT SIZE=3D2>Thu Mar 28 10:24:28 2002 begin reading backup id =
onyx_1015153648 (restore), copy 1, fragment 1 from media id QZF816 on =
drive index 1</FONT></P>

<P><FONT SIZE=3D2>Thu Mar 28 10:24:29 2002 successfully restored from =
backup id onyx_1015153648, copy 1, 160 kbytes</FONT>
</P>

<P><FONT SIZE=3D2>** Jeff A. Earickson, =
Ph.D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; PHONE: 207-872-3659</FONT>
<BR><FONT SIZE=3D2>** Senior UNIX Sysadmin, Information =
Technology&nbsp;&nbsp;&nbsp; EMAIL: jaearick AT colby DOT edu</FONT>
<BR><FONT SIZE=3D2>** Colby College, 4214 Mayflower =
Hill,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp; FAX: 207-872-3076</FONT>
<BR><FONT SIZE=3D2>** Waterville ME, 04901-8842</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------------</FONT>
</P>

<P><FONT SIZE=3D2>On Thu, 28 Mar 2002, Gary Sperano wrote:</FONT>
</P>

<P><FONT SIZE=3D2>&gt; Date: Thu, 28 Mar 2002 14:43:14 -0500</FONT>
<BR><FONT SIZE=3D2>&gt; From: Gary Sperano =
&lt;gsperano AT powertel DOT com&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; To: veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>&gt; Subject: [Veritas-bu] Drive Utilization</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Does anybody have any good scripts (ksh, perl, =
etc) that reports drive(s)</FONT>
<BR><FONT SIZE=3D2>&gt; utilization or know where to obtain this type =
of process from?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Gary A. Sperano Jr</FONT>
<BR><FONT SIZE=3D2>&gt; Technical Specialist</FONT>
<BR><FONT SIZE=3D2>&gt; VoiceStream</FONT>
<BR><FONT SIZE=3D2>&gt; PCS: 404-610-9566</FONT>
<BR><FONT SIZE=3D2>&gt; Desk: 770-604-3165</FONT>
<BR><FONT SIZE=3D2>&gt; Gsperano AT powertel DOT com</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; =
_______________________________________________</FONT>
<BR><FONT SIZE=3D2>&gt; Veritas-bu maillist&nbsp; -&nbsp; =
Veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>&gt; <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>
<BR><FONT SIZE=3D2>&gt;</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C1D69D.CC7258E0--

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