--=====================_539576129==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
If anyone wants to give a crack at this in Perl, the NBUX bpdbjobs()
function already returns
the fully-parsed information in an hash (associative array for you awk
folks.) The job start time,
end time, and everything else from the -all_columns output is all
accessible through hash keys.*
I might even try doing this, except that I'm slightly occupied with other
things at present.
--PLB
At 03:31 PM 03/28/2002 -0700, Donaldson, Mark wrote:
>Whoa - what a challenge!
>
>It's a cool idea - should be available from the bpdbjobs (all_columns)
>report since it contains all the positioning and mounting information on a
>per-job basis. Parse it for tape mount info & times, do some math. Easy,
>right? :)
>
>It's a cool idea - I'll let you know if I ever try it out - one trouble is
>line-length limitations in awk - this output is HUGE!.
>
>-Mark
>
>-----Original Message-----
>From: Dan Dobbs
>[<mailto:DDobbs AT mutualmaterials DOT com>mailto:DDobbs AT mutualmaterials
>DOT com]
>
>Is there a way to compute 'real' backup times, however? If I have 8
>streams that all start at the same time (different mount points), but four
>drives, I get something like:
>
>#./bpdbjobs -report | more
>
> 13291 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 01:14:27 03/19/2002 22:31:42 3725683
>
> 13290 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 02:01:47 03/19/2002 23:19:02 17798378
>
> 13289 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 00:11:44 03/19/2002 21:28:59 300266
>
> 13288 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 02:13:39 03/19/2002 23:30:54 8376030
>
> 13287 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 00:34:31 03/19/2002 21:51:46 4422003
>
> 13286 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 00:11:27 03/19/2002 21:28:42 245566
>
> 13285 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 02:17:51 03/19/2002 23:35:06 7742698
>
> 13284 Backup Done 0 MMORA1-Oracle MMORA1-O.Full
> mmora1 MMORA3 03/19/2002
> 21:17:15 00:04:19 03/19/2002 21:21:34 182804
>
>Obviously some didn't start really doing anything until a tape drive
>became available--can one figure out the 'true' backup time?
>
>-dd
>
> >>> "Donaldson, Mark" <Mark.Donaldson AT experianems DOT com> 03/28/02
> >>> 01:16PM >>>
>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&</A>
>
>
>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>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>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>
> >
--=====================_539576129==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<br>
If anyone wants to give a crack at this in Perl, the NBUX bpdbjobs()
function already returns<br>
the fully-parsed information in an hash (associative array for you awk
folks.) The job start time,<br>
end time, and everything else from the -all_columns output is all
accessible through hash keys.*<br>
<br>
I might even try doing this, except that I'm slightly occupied with other
things at present.<br>
<br>
--PLB<br>
<br>
At 03:31 PM 03/28/2002 -0700, Donaldson, Mark wrote:<br>
<br>
<blockquote type=cite class=cite cite><font size=2>Whoa - what a
challenge!</font> <br>
<br>
<font size=2>It's a cool idea - should be available from the bpdbjobs
(all_columns) report since it contains all the positioning and mounting
information on a per-job basis. Parse it for tape mount info &
times, do some math. Easy, right? :)<br>
</font><br>
<font size=2>It's a cool idea - I'll let you know if I ever try it out -
one trouble is line-length limitations in awk - this output is
HUGE!.<br>
</font><br>
<font size=2>-Mark</font> <br>
<br>
<font size=2>-----Original Message-----</font> <br>
<font size=2>From: Dan Dobbs
[<a href="mailto:DDobbs AT mutualmaterials DOT com">mailto:DDobbs AT
mutualmaterials DOT com</a>]</font>
<br>
<br>
<font size=2>Is there a way to compute 'real' backup times, however? If I
have 8 streams that all start at the same time (different mount points),
but four drives, I get something like:<br>
</font><br>
<font size=2>#./bpdbjobs -report | more</font> <br>
<br>
<font size=2> 13291
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 01:14:27
03/19/2002 22:31:42 3725683<br>
</font><br>
<font size=2> 13290
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 02:01:47
03/19/2002 23:19:02 17798378<br>
</font><br>
<font size=2> 13289
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 00:11:44
03/19/2002 21:28:59
300266<br>
</font><br>
<font size=2> 13288
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 02:13:39
03/19/2002 23:30:54 8376030<br>
</font><br>
<font size=2> 13287
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 00:34:31
03/19/2002 21:51:46 4422003<br>
</font><br>
<font size=2> 13286
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 00:11:27
03/19/2002 21:28:42
245566<br>
</font><br>
<font size=2> 13285
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 02:17:51
03/19/2002 23:35:06 7742698<br>
</font><br>
<font size=2> 13284
Backup Done
0 MMORA1-Oracle
MMORA1-O.Full
mmora1 MMORA3 03/19/2002
21:17:15 00:04:19
03/19/2002 21:21:34
182804<br>
</font><br>
<font size=2>Obviously some didn't start really doing anything until a
tape drive became available--can one figure out the 'true' backup
time?<br>
</font><br>
<font size=2>-dd</font> <br>
<br>
<font size=2>>>> "Donaldson, Mark"
<Mark.Donaldson AT experianems DOT com> 03/28/02 01:16PM
>>></font> <br>
<font size=2>The "bpdbjobs -report" has all of this except
which drive was utilized. <br>
</font><br>
<font size=2>Also checkout "bpdbjobs -report
-all_columns". <br>
</font><br>
<font size=2>See the FAQ in Storage Mountain for a description of the
columns.</font> <br>
<br>
<font size=2><a
href="http://www.backupcentral.com/cgi-bin/netbackup-fom?_highlightWords=bpdbjobs"
eudora="autourl">http://www.backupcentral.com/cgi-bin/netbackup-fom?_highlightWords=bpdbjobs</a>&</A>
</font><br>
<font size=2>file=194</font> <br>
<br>
<font size=2>Anyway, bpdbjobs has start time, stop times, KB transferred
(calc to get</font> <br>
<font size=2>rates), server, class, etc.</font> <br>
<br>
<font size=2>To get the drive information, you have to go parse the
database.</font> <br>
<br>
<font size=2>-Mark</font> <br>
<br>
<font size=2>-----Original Message-----</font> <br>
<font size=2>From: Jeff A. Earickson
[<a href="mailto:jaearick AT colby DOT edu">mailto:jaearick AT colby DOT
edu</a>]
</font><br>
<font size=2>Sent: Thursday, March 28, 2002 1:40 PM</font> <br>
<font size=2>To: Gary Sperano</font> <br>
<font size=2>Cc: veritas-bu AT mailman.eng.auburn DOT edu </font><br>
<font size=2>Subject: Re: [Veritas-bu] Drive Utilization</font> <br>
<br>
<font size=2>Hi,</font> <br>
<font size=2> Funny, but I needed the same info the other
day, when I wanted to know</font> <br>
<font size=2>what machine/class was backing up to what drive, when, and
what tape it</font> <br>
<font size=2>was writing to. Hey Veritas, how come no nice report
to tell you?</font> <br>
<br>
<font size=2>* start time of backup job</font> <br>
<font size=2>* stop time of backup job</font> <br>
<font size=2>* elapsed time and thruput rate</font> <br>
<font size=2>* what drive got used and what tape got written to</font>
<br>
<br>
<font size=2>Really cool would be a GUI barchart that showed, on a per drive
basis,</font> <br>
<font size=2>machine backups over time.</font> <br>
<br>
<font size=2>Anyway, I cooked up the attached shell script to go thru every
class,</font> <br>
<font size=2>show what happened in the previous 24 hours (weeding out trivial
messages),</font> <br>
<font size=2>and give me real timestamps as well. The output is not
pretty but the</font> <br>
<font size=2>info is all there for a backup or restore. Output looks
like:</font> <br>
<br>
<font size=2>============== diamond</font> <br>
<font size=2>Wed Mar 27 18:07:35 2002 added backup job for client diamond,
class diamond,</font> <br>
<font size=2>schedule Full part 0 to NetBackup scheduler work queue</font> <br>
<font size=2>Wed Mar 27 18:25:25 2002 started backup job for client diamond,
class</font> <br>
<font size=2>diamond, schedule Full on storage unit
slate-dlt-robot-tld-0</font> <br>
<font size=2>Wed Mar 27 18:25:27 2002 client diamond handling path
ALL_LOCAL_DRIVES</font> <br>
<font size=2>Wed Mar 27 18:25:39 2002 begin writing backup id
diamond_1017271525, copy 1,</font> <br>
<font size=2>fragment 1, to media id QWC775 on drive index 1</font> <br>
<font size=2>Wed Mar 27 19:10:09 2002 successfully wrote backup id
diamond_1017271525,</font> <br>
<font size=2>copy 1, fragment 1, 8677536 Kbytes at 3271.484 Kbytes/sec</font>
<br>
<font size=2>Wed Mar 27 19:10:11 2002 CLIENT diamond CLASS diamond SCHED Full
EXIT STATUS</font> <br>
<font size=2>0 (the requested operation was successfully completed)</font> <br>
<font size=2>Thu Mar 28 10:18:54 2002 Media id QZF816 is needed for the
restore.</font> <br>
<font size=2>Thu Mar 28 10:24:28 2002 begin reading backup id onyx_1015153648
(restore),</font> <br>
<font size=2>copy 1, fragment 1 from media id QZF816 on drive index 1</font>
<br>
<font size=2>Thu Mar 28 10:24:29 2002 successfully restored from backup
id</font> <br>
<font size=2>onyx_1015153648, copy 1, 160 kbytes</font> <br>
<br>
<font size=2>** Jeff A. Earickson,
Ph.D
PHONE: 207-872-3659</font> <br>
<font size=2>** Senior UNIX Sysadmin, Information Technology
EMAIL: jaearick AT colby DOT edu </font><br>
<font size=2>** Colby College, 4214 Mayflower
Hill,
FAX: 207-872-3076</font> <br>
<font size=2>** Waterville ME, 04901-8842</font> <br>
<font
size=2>----------------------------------------------------------------------------</font>
<br>
<br>
<font size=2>On Thu, 28 Mar 2002, Gary Sperano wrote:</font> <br>
<br>
<font size=2>> Date: Thu, 28 Mar 2002 14:43:14 -0500</font> <br>
<font size=2>> From: Gary Sperano <gsperano AT powertel DOT
com></font> <br>
<font size=2>> To: veritas-bu AT mailman.eng.auburn DOT edu </font><br>
<font size=2>> Subject: [Veritas-bu] Drive Utilization</font> <br>
<font size=2>></font> <br>
<font size=2>></font> <br>
<font size=2>></font> <br>
<font size=2>> Does anybody have any good scripts (ksh, perl, etc) that
reports drive(s)</font> <br>
<font size=2>> utilization or know where to obtain this type of process
from?</font> <br>
<font size=2>></font> <br>
<font size=2>> Gary A. Sperano Jr</font> <br>
<font size=2>> Technical Specialist</font> <br>
<font size=2>> VoiceStream</font> <br>
<font size=2>> PCS: 404-610-9566</font> <br>
<font size=2>> Desk: 770-604-3165</font> <br>
<font size=2>> Gsperano AT powertel DOT com </font><br>
<font size=2>></font> <br>
<font size=2>></font> <br>
<font size=2>> _______________________________________________</font> <br>
<font size=2>> Veritas-bu maillist - Veritas-bu AT
mailman.eng.auburn DOT edu </font><br>
<font size=2>> <a
href="http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu">http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu</a>
</font><br>
<font size=2>></font> </blockquote></html>
--=====================_539576129==_.ALT--
|