Veritas-bu
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[Veritas-bu] Bpdbjobs database file ??

2004-10-06 09:58:07
Subject: [Veritas-bu] Bpdbjobs database file ??
From: tlewick AT hrblock DOT com (Lewick, Taylor)
Date: Wed, 6 Oct 2004 08:58:07 -0500 
This is a multi-part message in MIME format.

------_=_NextPart_001_01C4ABAC.81DFFA5B
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Andy that parameter  can be a judgement call.  Just run bpdbjobs -report
-all_columns

Now the issue/judegement is do you want process start time, connect
time, beginning of the write time?

Some would argue they only want the write time for throughput
calculations, and others would argue that you need the total time i.e.
the start of the process time, because if the job spends two hours
waiting on a free drive then that affects the "real throughput".

=20

Either way, I get all of this info by parsing bpdbjobs -report
-all_columns and just use some perl regex to get what I want. =20

Let me know if you need some code samples...

=20

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Hardy,
Andrew
Sent: Wednesday, October 06, 2004 8:32 AM
To: Netbackup managers
Subject: [Veritas-bu] Bpdbjobs database file ??

=20

All,=20

I have a script which reports the number of all backup stream failures,
over a 24 hour period, between 08:00am & 08:00am every day.

However, in order for me to easily report on percentage failures of all
streams during that period, I need to be able to find out the total
number of streams (successful or failed) during that period.

Getting the failed jobs is easy, because there is a daily log file which
is created in /usr/openv/netbackup/db/failure_history.

Getting the total number of jobs which ran between these times, is
however proving a little more difficult !!  I have tried running the
bpdbjobs command with all the options, but cannot seem to find an output
which shows the start time of each stream.

I guess there must be a file somewhere which has this info, since the
GUI reports this from somewhere, but I cannot find out where it is
.......

Can anyone help=20

Many Thanks=20

Andy Hardy=20

=20

Andy Hardy=20
Technical Specialist, Data Storage Services,=20
Marks & Spencer PLC, 3 Longwalk Road,Room 1SW,=20
Stockley Park, Uxbridge,Middesex,UB11 1AW.=20
* 020 8718 5975=20
* 07733 333324=20

* mailto:andrew.hardy AT marks-and-spencer DOT com
<mailto:andrew.hardy AT marks-and-spencer DOT com> =20

=20

________________________________


Registered Office:
Marks and Spencer plc
Waterside House
35 North Wharf Road
London
W2 1NW

Registered No. 214436 in England and Wales.

Telephone (020) 7935 4422
Facsimile (020) 7487 2670

www.marksandspencer.com

Please note that electronic mail may be monitored.

This e-mail is confidential. If you received it by mistake, please let
us know and then delete it from your system; you should not copy,
disclose, or distribute its contents to anyone nor act in reliance on
this e-mail, as this is prohibited and may be unlawful.

The registered office of Marks and Spencer Financial Services PLC, Marks
and Spencer Unit Trust Management Limited, Marks and Spencer Life
Assurance Limited and Marks and Spencer Savings and Investments Limited
is Kings Meadow, Chester, CH99 9FB. These firms are authorised and
regulated by the Financial Services Authority.=20


------_=_NextPart_001_01C4ABAC.81DFFA5B
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Bpdbjobs database file ??</title>

<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:blue;
        text-decoration:underline;}
p
        {margin-right:0in;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.EmailStyle18
        {font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
 /* List Definitions */
 ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><!-- Converted from text/rtf format =
-->Andy
that parameter &nbsp;can be a judgement call.&nbsp; Just run bpdbjobs =
&#8211;report
&#8211;all_columns</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Now the issue/judegement is do you =
want
process start time, connect time, beginning of the write =
time?</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Some would argue they only want the =
write
time for throughput calculations, and others would argue that you need =
the
total time i.e. the start of the process time, because if the job spends =
two
hours waiting on a free drive then that affects the &#8220;real =
throughput&#8221;.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Either way, I get all of this info =
by
parsing bpdbjobs &#8211;report &#8211;all_columns an</span></font><font =
size=3D2
 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
 color:navy'>d j</span></font><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>ust use some =
perl regex
to get what I want.&nbsp; </span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Let me know if you need some code =
samples&#8230;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <b><span =
style=3D'font-weight:
bold'>On Behalf Of </span></b>Hardy, Andrew<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font =
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>Wednesday,
 October 06, 2004</span></font><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma'> </span></font><font size=3D2 =
face=3DTahoma><span
 style=3D'font-size:10.0pt;font-family:Tahoma'>8:32 =
AM</span></font><font size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> Netbackup =
managers<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Veritas-bu] =
Bpdbjobs
database file ??</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'>&nbsp;</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>All,</span></font> </p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>I have a script which reports the number of =
all
backup stream failures, over a 24 hour period, between 08:00am &amp; =
08:00am
every day.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>However, in order for me to easily report on
percentage failures of all streams during that period, I need to be able =
to
find out the total number of streams (successful or failed) during that =
period.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Getting the failed jobs is easy, because there =
is a
daily log file which is created in =
/usr/openv/netbackup/db/failure_history.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Getting the total number of jobs which ran =
between
these times, is however proving a little more difficult !!&nbsp; I have =
tried
running the bpdbjobs command with all the options, but cannot seem to =
find an
output which shows the start time of each stream.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>I guess there must be a file somewhere which =
has this
info, since the GUI reports this from somewhere, but I cannot find out =
where it
is &#8230;&#8230;.</span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Can anyone help </span></font></p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Many Thanks</span></font> </p>

<p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial'>Andy Hardy</span></font> </p>

<p class=3DMsoNormal =
style=3D'margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&nbsp;</span></font></p>

<p style=3D'margin-left:1.0in'><b><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt;font-weight:bold'>Andy Hardy</span></font></b> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Technical Specialist, =
Data Storage
Services,</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Marks &amp; Spencer PLC, =
3 Longwalk
Road,Room 1SW,</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Stockley Park,
Uxbridge,Middesex,UB11 1AW.</span></font> <br>
<font color=3Dmaroon face=3DWingdings><span =
style=3D'font-family:Wingdings;
color:maroon'>(</span></font> <font size=3D2><span =
style=3D'font-size:10.0pt'>020
8718 5975</span></font> <br>
<font color=3Dmaroon face=3DWingdings><span =
style=3D'font-family:Wingdings;
color:maroon'>(</span></font> <font size=3D2><span =
style=3D'font-size:10.0pt'>07733
333324</span></font> </p>

<p style=3D'margin-left:.5in'><font size=3D3 color=3Dblue =
face=3DWingdings><span
style=3D'font-size:12.0pt;font-family:Wingdings;color:blue'>+</span></fon=
t> <a
href=3D"mailto:andrew.hardy AT marks-and-spencer DOT com"><font size=3D2><span
style=3D'font-size:10.0pt'>mailto:andrew.hardy AT marks-and-spencer DOT 
com</spa=
n></font></a>
</p>

<p class=3DMsoNormal =
style=3D'margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&nbsp;</span></font></p>

<div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:.5in;text-align:center'><font
size=3D3 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D2 width=3D"100%" align=3Dcenter>

</span></font></div>

<p =
style=3D'margin-right:0in;margin-bottom:12.0pt;margin-left:.5in'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><br>
Registered Office:<br>
Marks and Spencer plc<br>
Waterside House<br>
35 North Wharf Road<br>
London<br>
W2 1NW<br>
<br>
Registered No. 214436 in England and Wales.<br>
<br>
Telephone (020) 7935 4422<br>
Facsimile (020) 7487 2670<br>
<br>
www.marksandspencer.com<br>
<br>
Please note that electronic mail may be monitored.<br>
<br>
This e-mail is confidential. If you received it by mistake, please let =
us know
and then delete it from your system; you should not copy, disclose, or
distribute its contents to anyone nor act in reliance on this e-mail, as =
this
is prohibited and may be unlawful.<br>
<br>
The registered office of Marks and Spencer Financial Services PLC, Marks =
and
Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance =
Limited
and Marks and Spencer Savings and Investments Limited is Kings Meadow, =
Chester,
CH99 9FB. These firms are authorised and regulated by the Financial =
Services
Authority. </span></font></p>

</div>

</body>

</html>

------_=_NextPart_001_01C4ABAC.81DFFA5B--
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [Veritas-bu] Bpdbjobs database file ??, Shahbaz Javeed
Next by Date:  [Veritas-bu] Bpdbjobs database file ??, Jerry
Previous by Thread:  [Veritas-bu] Bpdbjobs database file ??, Jerry
Next by Thread:  [Veritas-bu] Bpdbjobs database file ??, Chewning.Bruce
Indexes:  [Date] [Thread] [Top] [All Lists]