Veritas-bu

[Veritas-bu] Bpdbjobs database file ??

2004-10-06 12:12:33
Subject: [Veritas-bu] Bpdbjobs database file ??
From: david.chapa AT adic DOT com (David Chapa)
Date: Wed, 6 Oct 2004 10:12:33 -0600
This is a multi-part message in MIME format.

------_=_NextPart_001_01C4ABBF.49BE3D73
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Oh its in there, but it is in utime.
=20
Here's an output from one of my tests.
=20
=20
13604,0,1,,special,Full,aprilia,aprilia,1097077672,0000000232,0000000000
,disk,1,3,2902528,3000,/export/home/testdata/dfile002998,58,22655,root,0
,0,0,0,other,aprilia,3,9,0,0,5001,1,/export/home/testdata,1,22655,disk,a
prilia,1097077673,0000000231,0000000000,,,6,10/06/04 09:47:56 - started
process bpbrm (22658),10/06/04 09:47:56 - connecting,10/06/04 09:47:56 -
started process bpdm (22661),10/06/04 09:47:57 - connected; connect
time: 000:00:01,10/06/04 09:47:57 - using NONE,10/06/04 09:47:57 - begin
writing,2902528,3000,0,13958,,,,,,,,,,,1,0,0,1,0,0,aprilia_1097077673,1,
=20
=20
The (comma delimited) 9th field is the time the job entered the queue,
the 10th field is total elapse time (including queue time), the 11th
will be end time.  If you want to get just the actual time it took for
the job (without including waiting in the queue) then the parsing of
this output becomes a bit more complicated.  This is a dynamic output
and requires a great deal of understanding.
=20
(1)jobid,(2)jobtype,(3)state,(4)status,(5)class,(6)sched,(7)client,(8)se
rver,(9)queuedtime,(10)elapsedfromqueuedtime,(11)endtime,(12)stunit,(13)
backuptry,(14)operationtype,
(15)kbytes,(16)files,(17)pathlastwritten,(18)percent,(19)jobpid,(20)owne
r,(21)subtype,(22)classtype,(23)schedule_type,(24)jobpriority,(25)group,
(26)masterserver,
(27)retentionunits,(28)retentionperiod,(29)compression,(30)kbyteslastwri
tten,(31)fileslastwritten,(32)filelistcount,(33*)[files]...,(34*)trycoun
t,[trypid,trystunit,tryserver,trystarted,tryelapsed,tryended,trystatus,t
rystatusdescription,trystatuscount,[trystatuslines]...,trybyteswritten,t
ryfileswritten]...
=20
Everything up to Field 32 is fixed beyond that the output is dynamic and
you will find out how many name files in the files list based on the
number in field 32.  If you add that number to 33 (next field) it will
take you to the number of tries the backup job attempted.  For the first
try move over 4 to get the start time of the first try, 5 for the elapse
time of the first try, 6 for the end time of the first try, etc.
=20
Hope that doesn't scare you away...oh the way I got the output is
bpdbjobs -report -all_columns.
=20
David
David A. Chapa | ADIC | 720.272.8452 cell | http://www.adic.com
<http://www.adic.com> =20
Sr. Technical Advisor=20
Pathlight VX - http://www.adic.com/gopathlightvx
=20
=20
=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 7: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
  _____ =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_01C4ABBF.49BE3D73
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40";>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:[email protected]">
<link rel=3DEdit-Time-Data href=3D"cid:[email protected]">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Bpdbjobs database file ??</title>
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:UseFELayout/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;
        mso-font-charset:2;
        mso-generic-font-family:auto;
        mso-font-pitch:variable;
        mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
        {font-family:"MS Mincho";
        panose-1:2 2 6 9 4 2 5 8 3 4;
        mso-font-alt:"\FF2D\FF33 \660E\671D";
        mso-font-charset:128;
        mso-generic-font-family:modern;
        mso-font-pitch:fixed;
        mso-font-signature:-1610612033 1757936891 16 0 131231 0;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;
        mso-font-charset:0;
        mso-generic-font-family:swiss;
        mso-font-pitch:variable;
        mso-font-signature:553679495 -2147483648 8 0 66047 0;}
@font-face
        {font-family:"Arial Black";
        panose-1:2 11 10 4 2 1 2 2 2 4;
        mso-font-charset:0;
        mso-generic-font-family:swiss;
        mso-font-pitch:variable;
        mso-font-signature:647 0 0 0 159 0;}
@font-face
        {font-family:"\@MS Mincho";
        panose-1:2 2 6 9 4 2 5 8 3 4;
        mso-font-charset:128;
        mso-generic-font-family:modern;
        mso-font-pitch:fixed;
        mso-font-signature:-1610612033 1757936891 16 0 131231 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {mso-style-parent:"";
        margin:0in;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"MS Mincho";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;
        text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
        {color:blue;
        text-decoration:underline;
        text-underline:single;}
p
        {mso-style-name:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Normal \(Web\) Char Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        mso-pagination:widow-orphan;
        font-size:12.0pt;
        font-family:"Times New Roman";
        mso-fareast-font-family:"MS Mincho";}
pre
        {margin:0in;
        margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 
=
412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
        font-size:10.0pt;
        font-family:"Courier New";
        mso-fareast-font-family:"MS Mincho";
        color:black;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        mso-style-noshow:yes;
        mso-ansi-font-size:10.0pt;
        mso-bidi-font-size:10.0pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        color:navy;}
span.NormalWebCharChar
        {mso-style-name:"Normal \(Web\) Char Char";
        mso-style-link:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-ansi-font-size:12.0pt;
        mso-bidi-font-size:12.0pt;
        font-family:"MS Mincho";
        mso-fareast-font-family:"MS Mincho";
        mso-ansi-language:EN-US;
        mso-fareast-language:JA;
        mso-bidi-language:AR-SA;}
span.StyleNormalWebLatinArialComplexArial75ptChar
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt";
        mso-ansi-font-size:7.5pt;
        mso-bidi-font-size:7.5pt;
        font-family:Arial;
        mso-ascii-font-family:Arial;
        mso-fareast-font-family:"MS Mincho";
        mso-hansi-font-family:Arial;
        mso-bidi-font-family:Arial;
        mso-ansi-language:EN-US;
        mso-fareast-language:JA;
        mso-bidi-language:AR-SA;}
p.StyleNormalWebLatinArialComplexArial75pt, =
li.StyleNormalWebLatinArialComplexArial75pt, =
div.StyleNormalWebLatinArialComplexArial75pt
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        mso-add-space:auto;
        mso-pagination:widow-orphan;
        font-size:7.5pt;
        font-family:Arial;
        mso-fareast-font-family:"MS Mincho";}
p.StyleNormalWebLatinArialComplexArial75ptCxSpFirst, =
li.StyleNormalWebLatinArialComplexArial75ptCxSpFirst, =
div.StyleNormalWebLatinArialComplexArial75ptCxSpFirst
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 ptCxSpFirst";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-style-type:export-only;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        mso-add-space:auto;
        mso-pagination:widow-orphan;
        font-size:7.5pt;
        font-family:Arial;
        mso-fareast-font-family:"MS Mincho";}
p.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle, =
li.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle, =
div.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 ptCxSpMiddle";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-style-type:export-only;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        mso-add-space:auto;
        mso-pagination:widow-orphan;
        font-size:7.5pt;
        font-family:Arial;
        mso-fareast-font-family:"MS Mincho";}
p.StyleNormalWebLatinArialComplexArial75ptCxSpLast, =
li.StyleNormalWebLatinArialComplexArial75ptCxSpLast, =
div.StyleNormalWebLatinArialComplexArial75ptCxSpLast
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 ptCxSpLast";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-style-type:export-only;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        mso-add-space:auto;
        mso-pagination:widow-orphan;
        font-size:7.5pt;
        font-family:Arial;
        mso-fareast-font-family:"MS Mincho";}
span.SpellE
        {mso-style-name:"";
        mso-spl-e:yes;}
span.GramE
        {mso-style-name:"";
        mso-gram-e:yes;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;
        mso-header-margin:.5in;
        mso-footer-margin:.5in;
        mso-paper-source:0;}
div.Section1
        {page:Section1;}
 /* List Definitions */
 @list l0
        {mso-list-id:355229773;
        mso-list-template-ids:-1969718024;}
@list l0:level1
        {mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:.5in;
        mso-level-number-position:left;
        text-indent:-.25in;
        mso-ansi-font-size:10.0pt;
        font-family:Symbol;}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
</style>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
        {mso-style-name:"Table Normal";
        mso-tstyle-rowband-size:0;
        mso-tstyle-colband-size:0;
        mso-style-noshow:yes;
        mso-style-parent:"";
        mso-padding-alt:0in 5.4pt 0in 5.4pt;
        mso-para-margin:0in;
        mso-para-margin-bottom:.0001pt;
        mso-pagination:widow-orphan;
        font-size:10.0pt;
        font-family:"Times New Roman";}
</style>
<![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue style=3D'tab-interval:.5in'>

<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 =
-->Oh <span
class=3DGramE>its</span> in there, but it is in <span =
class=3DSpellE>utime</span>.<o:p></o:p></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'><o:p>&nbsp;</o:p></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'>Here&#8217;s an output from one of =
my tests.<o:p></o:p></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'><o:p>&nbsp;</o:p></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'><o:p>&nbsp;</o:p></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'>13604,0,1,,special,Full,aprilia,apri=
lia,1097077672,0000000232,0000000000,disk,1,3,2902528,3000,/export/home/t=
estdata/dfile002998,58,22655,root,0,0,0,0,other,aprilia,3,9,0,0,5001,1,/e=
xport/home/testdata,1,22655,disk,aprilia,1097077673,0000000231,0000000000=
,,,6,10/06/04
09:47:56 - started process <span class=3DSpellE>bpbrm</span> =
(22658),10/06/04 09:47:56
- connecting,10/06/04 09:47:56 - started process <span =
class=3DSpellE>bpdm</span>
(22661),10/06/04 09:47:57 - connected; connect time: 000:00:01,10/06/04 =
09:47:57
- using NONE,10/06/04 09:47:57 - begin =
writing,2902528,3000,0,13958,,,,,,,,,,,1,0,0,1,0,0,aprilia_1097077673,1,<=
o:p></o:p></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'><o:p>&nbsp;</o:p></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'><o:p>&nbsp;</o:p></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'>The (comma delimited) =
9<sup>th</sup> field
is the time the job entered the queue, the 10<sup>th</sup> field is =
total
elapse time (including queue time), the 11<sup>th</sup> will be end =
time.<span
style=3D'mso-spacerun:yes'>&nbsp; </span>If you want to get just the =
actual time
it took for the job (without including waiting in the queue) then the =
parsing
of this output becomes a bit more complicated.<span
style=3D'mso-spacerun:yes'>&nbsp; </span>This is a dynamic output and =
requires a
great deal of understanding.<o:p></o:p></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'><o:p>&nbsp;</o:p></span></font></p>

<pre><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'>(1)<span =
class=3DSpellE>jobid</span>,(2)<span
class=3DSpellE>jobtype</span>,(3)state,(4)status,(5)class,(6)<span =
class=3DSpellE>sched</span>,(7)client,(8)server,(9)<span
class=3DSpellE>queuedtime</span>,(10)<span =
class=3DSpellE>elapsedfromqueuedtime</span>,(11)<span
class=3DSpellE>endtime</span>,(12)<span =
class=3DSpellE>stunit</span>,(13)<span
class=3DSpellE>backuptry</span>,(14)<span =
class=3DSpellE>operationtype</span>,<o:p></o:p></span></font></pre><pre><=
font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'>(15)<span class=3DSpellE>kbytes</span>,(16)files,(17)<span
class=3DSpellE>pathlastwritten</span>,(18)percent,(19)<span =
class=3DSpellE>jobpid</span>,(20)owner,(21)subtype,(22)<span
class=3DSpellE>classtype</span>,(23)<span =
class=3DSpellE>schedule_type</span>,(24)<span
class=3DSpellE>jobpriority</span>,(25)group,(26)<span =
class=3DSpellE>masterserver</span>,<o:p></o:p></span></font></pre><pre><f=
ont
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'>(27)<span class=3DSpellE>retentionunits</span>,(28)<span
class=3DSpellE>retentionperiod</span>,(29)compression,(30)<span =
class=3DSpellE>kbyteslastwritten</span>,(31)<span
class=3DSpellE>fileslastwritten</span>,(32)<span =
class=3DSpellE>filelistcount</span>,(33*)[files]...,(34*)<span
class=3DSpellE>trycount</span>,[trypid,trystunit,tryserver,trystarted,try=
elapsed,tryended,trystatus,trystatusdescription,trystatuscount,[<span
class=3DSpellE>trystatuslines</span>]...,<span =
class=3DSpellE>trybyteswritten,tryfileswritten</span>]...<o:p></o:p></spa=
n></font></pre><pre><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><o:p>&nbsp;</o:p></span></font></pre><pre><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Everything up to =
Field 32 is fixed beyond that the output is dynamic and you will find =
out how many name files in the files list based on the number in field =
32.<span style=3D'mso-spacerun:yes'>&nbsp; </span>If you add that number =
to 33 (next field) it will take you to the number of tries the backup =
job attempted.<span style=3D'mso-spacerun:yes'>&nbsp; </span>For the =
first try move over 4 to get the start time of the first try, 5 for the =
elapse time of the first try, 6 for the end time of the first try, =
etc.<o:p></o:p></span></font></pre><pre><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><o:p>&nbsp;</o:p></span></font></pre><pre><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Hope that =
doesn&#8217;t scare you away&#8230;oh the way I got the output is <span
class=3DSpellE>bpdbjobs</span> &#8211;report &#8211;<span =
class=3DSpellE>all_columns</span>.<o:p></o:p></span></font></pre><pre><fo=
nt
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><o:p>&nbsp;</o:p></span></font></pre><pre><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>David<o:p></o:p><=
/span></font></pre>

<div>

<p><font size=3D1 color=3Dnavy face=3D"Arial Black"><span =
style=3D'font-size:7.5pt;
font-family:"Arial =
Black";mso-bidi-font-family:Arial;color:navy;mso-no-proof:
yes'>David A. Chapa</span></font><span
class=3DStyleNormalWebLatinArialComplexArial75ptChar><font size=3D1 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:7.5pt;color:navy;mso-no-proof:yes'> | =
</span></font></span><font
size=3D1 color=3Dred face=3D"Arial Black"><span =
style=3D'font-size:7.5pt;font-family:
"Arial =
Black";mso-bidi-font-family:Arial;color:red;mso-no-proof:yes'>ADIC</span>=
</font><span
class=3DStyleNormalWebLatinArialComplexArial75ptChar><font size=3D1 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:7.5pt;color:navy;mso-no-proof:yes'> |
720.272.8452 cell | </span></font></span><font color=3Dnavy =
face=3DArial><span
style=3D'font-family:Arial;color:navy;mso-no-proof:yes'><a
href=3D"http://www.adic.com";><font size=3D1><span =
style=3D'font-size:7.5pt'>http://www.adic.com</span></font></a></span></f=
ont><font
size=3D1 color=3Dnavy><span =
style=3D'font-size:7.5pt;color:navy;mso-no-proof:yes'> <br>
</span></font><span =
class=3DStyleNormalWebLatinArialComplexArial75ptChar><font
size=3D1 color=3Dnavy face=3DArial><span =
style=3D'font-size:7.5pt;color:navy;
mso-no-proof:yes'>Sr. Technical Advisor</span></font></span><font =
size=3D1
color=3Dnavy><span =
style=3D'font-size:7.5pt;color:navy;mso-no-proof:yes'> =
<o:p></o:p></span></font></p>

<p><font size=3D1 color=3Dred face=3D"Arial Black"><span =
style=3D'font-size:7.5pt;
font-family:"Arial =
Black";mso-bidi-font-family:Arial;color:red;mso-no-proof:
yes'>Pathlight VX &#8211; =
http://www.adic.com/gopathlightvx<o:p></o:p></span></font></p>

<p><font size=3D1 color=3Dnavy face=3D"Times New Roman"><span =
style=3D'font-size:7.5pt;
color:navy;mso-no-proof:yes'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'><o:p>&nbsp;</o:p><=
/span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></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> Wednesday, October =
06, 2004
7:32 AM<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'><o:p>&nbsp;</o:p></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> <o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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> <o:p></o:p></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> <o:p></o:p></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;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'><o:p>&nbsp;</o:p></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> <o:p></o:p></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>
<o:p></o:p></p>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;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'><o:p>&nbsp;</o:p></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'mso-margin-top-alt:5.0pt;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. <o:p></o:p></span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C4ABBF.49BE3D73--