Veritas-bu

[Veritas-bu] Bpdbjobs database file ??

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

------_=_NextPart_001_01C4AC89.A72D8437
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Good point...thanks!
=20
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: Dingwell, Cuyler [mailto:cuyler.dingwell AT eds DOT com]=20
Sent: Thursday, October 07, 2004 10:03 AM
To: David Chapa; Hardy, Andrew; Netbackup managers
Subject: RE: [Veritas-bu] Bpdbjobs database file ??
=20
One minor note on bpdbjobs, if a line has a comma in it then the
bpdbjobs may appear to have an extra field.
=20
In the GUI is looks like:
        10/6/2004 9:03:04 PM - Warning bpbrm(pid=3D3156) from client
serverA: WRN - Skipping file /file.txt, it has mandatory locking enabled
and is currently locked
In the bpdbjobs -all_columns it will look like:
        10/6/2004 9:03:04 PM - Warning bpbrm(pid=3D3156) from client
serverA: WRN - Skipping file /file.txt\, it has mandatory locking
enabled=20
The issue is the value of trystatuslines only counts that as one line.
If you split based on commas you will find an extra field.  What I did
is I look for a comma followed by a space and add that to the
trystatuslines value if I want to get something at the end of the line.
Thanks!=20
- Cuyler Dingwell=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 David
Chapa
        Sent: Wednesday, October 06, 2004 12:13 PM
        To: Hardy, Andrew; Netbackup managers
        Subject: RE: [Veritas-bu] Bpdbjobs database file ??
        Oh its in there, but it is in utime.
        =20
        Here's an output from one of my tests.
        =20
        =20
=09
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
=09
(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,
=09
(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,
=09
(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
=09
  _____ =20

=09
        Registered Office:
        Marks and Spencer plc
        Waterside House
        35 North Wharf Road
        London
        W2 1NW
=09
        Registered No. 214436 in England and Wales.
=09
        Telephone (020) 7935 4422
        Facsimile (020) 7487 2670
=09
        www.marksandspencer.com
=09
        Please note that electronic mail may be monitored.
=09
        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.
=09
        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_01C4AC89.A72D8437
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//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:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40";>

<head>
<META HTTP-EQUIV=3D"Content-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>Message</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"date" downloadurl=3D""/>
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <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]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![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;}
@font-face
        {font-family:Papyrus;
        panose-1:0 0 0 0 0 0 0 0 0 0;
        mso-font-alt:"Times New Roman";
        mso-font-charset:0;
        mso-generic-font-family:roman;
        mso-font-format:other;
        mso-font-pitch:auto;
        mso-font-signature:0 0 0 0 0 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 Char\,Normal =
\(Web\) Char";
        mso-style-link:"Normal \(Web\)\,Normal \(Web\) Char Char\,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.NormalWeb
        {mso-style-name:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char Char";
        mso-style-link:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char";
        mso-ansi-font-size:12.0pt;
        mso-bidi-font-size:12.0pt;
        font-family:"MS Mincho";
        mso-ascii-font-family:"MS Mincho";
        mso-fareast-font-family:"MS Mincho";
        mso-hansi-font-family:"MS Mincho";
        mso-ansi-language:EN-US;
        mso-fareast-language:JA;
        mso-bidi-language:AR-SA;}
span.StyleNormalWebLatinArialComplexArial75ptCharChar
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        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.StyleNormalWebLatinArialComplexArial75ptChar, =
li.StyleNormalWebLatinArialComplexArial75ptChar, =
div.StyleNormalWebLatinArialComplexArial75ptChar
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char 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.StyleNormalWebLatinArialComplexArial75ptCharCxSpFirst, =
li.StyleNormalWebLatinArialComplexArial75ptCharCxSpFirst, =
div.StyleNormalWebLatinArialComplexArial75ptCharCxSpFirst
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt CharCxSpFirst";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char 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.StyleNormalWebLatinArialComplexArial75ptCharCxSpMiddle, =
li.StyleNormalWebLatinArialComplexArial75ptCharCxSpMiddle, =
div.StyleNormalWebLatinArialComplexArial75ptCharCxSpMiddle
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt CharCxSpMiddle";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char 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.StyleNormalWebLatinArialComplexArial75ptCharCxSpLast, =
li.StyleNormalWebLatinArialComplexArial75ptCharCxSpLast, =
div.StyleNormalWebLatinArialComplexArial75ptCharCxSpLast
        {mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt CharCxSpLast";
        mso-style-parent:"Normal \(Web\)\,Normal \(Web\) Char Char\,Normal =
\(Web\) Char";
        mso-style-link:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt Char 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.EmailStyle22
        {mso-style-type:personal;
        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.EmailStyle23
        {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;}
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 Char\,Normal =
\(Web\) 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 Char\,Normal =
\(Web\) 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 Char\,Normal =
\(Web\) 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 Char\,Normal =
\(Web\) 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";}
@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;}
-->
</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'>Good =
point...thanks!<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>

<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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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> Dingwell, Cuyler
[mailto:cuyler.dingwell AT eds DOT com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"10" Day=3D"7" Year=3D"2004"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
 10.0pt;font-family:Tahoma'>Thursday, October 07, =
2004</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"10" Minute=3D"3"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
 font-family:Tahoma'>10:03 AM</span></font></st1:time><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> David Chapa; Hardy, =
Andrew;
Netbackup managers<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: [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>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>One minor note =
on
bpdbjobs, if a line has a comma in it then the bpdbjobs may appear to =
have an
extra field.</span></font><o:p></o:p></p>

</div>

<div>

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

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>In the GUI is =
looks like:</span></font><o:p></o:p></p>

</div>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><st1:date Month=3D"10" =
Day=3D"6"
Year=3D"2004"><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;
 font-family:Arial;color:blue'>10/6/2004</span></font></st1:date><font =
size=3D2
color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><st1:time Hour=3D"21" Minute=3D"3"><font =
size=3D2
 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
 color:blue'>9:03:04 PM</span></font></st1:time><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> -
Warning bpbrm(pid=3D3156) from client&nbsp;serverA: WRN - Skipping file
/file.txt, it has mandatory locking enabled and is currently =
locked</span></font><o:p></o:p></p>

</div>

</blockquote>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>In the bpdbjobs =
-all_columns
it will look like:</span></font><o:p></o:p></p>

</div>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><st1:date Month=3D"10" =
Day=3D"6"
Year=3D"2004"><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;
 font-family:Arial;color:blue'>10/6/2004</span></font></st1:date><font =
size=3D2
color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> </span></font><st1:time Hour=3D"21" Minute=3D"3"><font =
size=3D2
 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
 color:blue'>9:03:04 PM</span></font></st1:time><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> -
Warning bpbrm(pid=3D3156) from client&nbsp;serverA: WRN - Skipping file
/file.txt\, it has mandatory locking enabled =
</span></font><o:p></o:p></p>

</div>

</blockquote>

<div>

<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>The issue is the =
value of
</span></font><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'>trystatuslines</span></font><font size=3D2
color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'> only counts that as one line.&nbsp; If you split based on =
commas
you will find an extra field.&nbsp; What I did is I look for a comma =
followed
by a space and add that to the trystatuslines value if I want to get =
something
at the end of the line.</span></font><o:p></o:p></p>

</div>

<p style=3D'margin-left:.5in'><font size=3D3 face=3DPapyrus><span =
lang=3DEN-CA
style=3D'font-size:12.0pt;font-family:Papyrus;mso-ansi-language:EN-CA'><!=
-- Converted from text/rtf format -->Thanks!</span></font><span
lang=3DEN-CA> </span><o:p></o:p></p>

<p style=3D'margin-left:.5in'><font size=3D3 face=3DPapyrus><span =
lang=3DEN-CA
style=3D'font-size:12.0pt;font-family:Papyrus;mso-ansi-language:EN-CA'>- =
Cuyler
Dingwell</span></font><span lang=3DEN-CA> </span><o:p></o:p></p>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>

<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;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>David Chapa<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"10" Day=3D"6" Year=3D"2004"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
 10.0pt;font-family:Tahoma'>Wednesday, October 06, =
2004</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"12" Minute=3D"13"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
 font-family:Tahoma'>12:13 PM</span></font></st1:time><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> Hardy, Andrew; =
Netbackup
managers<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: [Veritas-bu] =
Bpdbjobs
database file ??</span></font><o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><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
its in there, but it is in utime.<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><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 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Here's an output =
from one
of my tests.<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><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 =
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 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>13604,0,1,,specia=
l,Full,aprilia,aprilia,1097077672,0000000232,0000000000,disk,1,3,2902528,=
3000,/export/home/testdata/dfile002998,58,22655,root,0,0,0,0,other,aprili=
a,3,9,0,0,5001,1,/export/home/testdata,1,22655,disk,aprilia,1097077673,00=
00000231,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,<=
o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:.5in'><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 =
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 =
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 style=3D'margin-left:.5in'><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 style=3D'margin-left:.5in'><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>(1)jobid,(2)jobty=
pe,(3)state,(4)status,(5)class,(6)sched,(7)client,(8)server,(9)queuedtime=
,(10)elapsedfromqueuedtime,(11)endtime,(12)stunit,(13)backuptry,(14)opera=
tiontype,<o:p></o:p></span></font></pre><pre
style=3D'margin-left:.5in'><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>(15)kbytes,(16)fi=
les,(17)pathlastwritten,(18)percent,(19)jobpid,(20)owner,(21)subtype,(22)=
classtype,(23)schedule_type,(24)jobpriority,(25)group,(26)masterserver,<o=
:p></o:p></span></font></pre><pre
style=3D'margin-left:.5in'><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>(27)retentionunit=
s,(28)retentionperiod,(29)compression,(30)kbyteslastwritten,(31)fileslast=
written,(32)filelistcount,(33*)[files]...,(34*)trycount,[trypid,trystunit=
,tryserver,trystarted,tryelapsed,tryended,trystatus,trystatusdescription,=
trystatuscount,[trystatuslines]...,trybyteswritten,tryfileswritten]...<o:=
p></o:p></span></font></pre><pre
style=3D'margin-left:.5in'><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
style=3D'margin-left:.5in'><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
style=3D'margin-left:.5in'><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
style=3D'margin-left:.5in'><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Hope that =
doesn't scare you away...oh the way I got the output is bpdbjobs -report =
-all_columns.<o:p></o:p></span></font></pre><pre
style=3D'margin-left:.5in'><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
style=3D'margin-left:.5in'><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 style=3D'margin-left:.5in;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=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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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=3DStyleNormalWebLatinArialComplexArial75ptCharChar><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 style=3D'margin-left:.5in;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=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 - http://www.adic.com/gopathlightvx<o:p></o:p></span></font></p>

<p style=3D'margin-left:.5in;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=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 style=3D'margin-left:.5in;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=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 style=3D'margin-left:.5in;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=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:1.0in;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=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><st1:date
Month=3D"10" Day=3D"6" Year=3D"2004"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
 10.0pt;font-family:Tahoma'>Wednesday, October 06, =
2004</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"7" Minute=3D"32"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
 font-family:Tahoma'>7:32 AM</span></font></st1:time><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><o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-left:1.0in;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=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;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=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:1.0in;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=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 </span></font><st1:time Hour=3D"8" Minute=3D"0"><font =
size=3D2
 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>08:00am</span></font></st1:t=
ime><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'> &amp; =
</span></font><st1:time
Hour=3D"8" Minute=3D"0"><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
 font-family:Arial'>08:00am</span></font></st1:time><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'> every =
day.</span></font><o:p></o:p></p>

<p style=3D'margin-left:1.0in;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=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:1.0in;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=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:1.0in;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=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:1.0in;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=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 =
.......</span></font><o:p></o:p></p>

<p style=3D'margin-left:1.0in;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=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:1.0in;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=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:1.0in;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=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:1.0in;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=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.5in;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'><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:1.0in;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=3D3 color=3Dblue face=3DWingdings><span =
style=3D'font-size:12.0pt;font-family:
Wingdings;color:blue'>+</span></font> <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:1.0in;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=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div style=3D'margin-left:.5in'>

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

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

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

</div>

<p =
style=3D'mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:12.0pt;
margin-left:1.0in;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=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>

</blockquote>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C4AC89.A72D8437--

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