This is a multi-part message in MIME format.
------_=_NextPart_001_01C4ABC4.B7A09C02
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
------_=_NextPart_001_01C4ABC4.B7A09C02
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]">
<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:"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:"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.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-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.StyleNormalWebLatinArialComplexArial75ptChar
{mso-style-name:"Style Normal \(Web\) + \(Latin\) Arial \(Complex\) =
Arial 7\.5 pt 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.EmailStyle22
{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.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;}
-->
</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> </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’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> </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> </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> </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> </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'> </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'> </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> </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)retentionunits,(28)retentionperiod,(29)compression,(30)kb=
yteslastwritten,(31)fileslastwritten,(32)filelistcount,(33*)[files]...,(3=
4*)trycount,[trypid,trystunit,tryserver,trystarted,tryelapsed,tryended,tr=
ystatus,trystatusdescription,trystatuscount,[trystatuslines]...,trybytesw=
ritten,tryfileswritten]...<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> </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'> </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'> </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> </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’t scare you away…oh the way I got the output is <span
class=3DSpellE>bpdbjobs</span> –report –<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> </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 style=3D'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=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 style=3D'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>
</div>
<p =
style=3D'mso-margin-top-alt:5.0pt;margin-right:0in;margin-bottom:12.0pt;
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 face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><span
style=3D'mso-spacerun:yes'> </span><o:p></o:p></span></font></p>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C4ABC4.B7A09C02--
|
