This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4AC87.1F73E84E
Content-Type: text/plain
One minor note on bpdbjobs, if a line has a comma in it then the bpdbjobs
may appear to have an extra field.
In the GUI is looks like:
10/6/2004 9:03:04 PM - Warning bpbrm(pid=3156) 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=3156) from client serverA: WRN -
Skipping file /file.txt\, it has mandatory locking enabled
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!
- Cuyler Dingwell
-----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.
Here's an output from one of my tests.
13604,0,1,,special,Full,aprilia,aprilia,1097077672,0000000232,0000000000,dis
k,1,3,2902528,3000,/export/home/testdata/dfile002998,58,22655,root,0,0,0,0,o
ther,aprilia,3,9,0,0,5001,1,/export/home/testdata,1,22655,disk,aprilia,10970
77673,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,
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.
(1)jobid,(2)jobtype,(3)state,(4)status,(5)class,(6)sched,(7)client,(8)server
,(9)queuedtime,(10)elapsedfromqueuedtime,(11)endtime,(12)stunit,(13)backuptr
y,(14)operationtype,
(15)kbytes,(16)files,(17)pathlastwritten,(18)percent,(19)jobpid,(20)owner,(2
1)subtype,(22)classtype,(23)schedule_type,(24)jobpriority,(25)group,(26)mast
erserver,
(27)retentionunits,(28)retentionperiod,(29)compression,(30)kbyteslastwritten
,(31)fileslastwritten,(32)filelistcount,(33*)[files]...,(34*)trycount,[trypi
d,trystunit,tryserver,trystarted,tryelapsed,tryended,trystatus,trystatusdesc
ription,trystatuscount,[trystatuslines]...,trybyteswritten,tryfileswritten].
..
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.
Hope that doesn't scare you away...oh the way I got the output is bpdbjobs
-report -all_columns.
David
David A. Chapa | ADIC | 720.272.8452 cell | <http://www.adic.com>
http://www.adic.com
Sr. Technical Advisor
Pathlight VX - http://www.adic.com/gopathlightvx
-----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 ??
All,
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
Many Thanks
Andy Hardy
Andy Hardy
Technical Specialist, Data Storage Services,
Marks & Spencer PLC, 3 Longwalk Road,Room 1SW,
Stockley Park, Uxbridge,Middesex,UB11 1AW.
* 020 8718 5975
* 07733 333324
* <mailto:andrew.hardy AT marks-and-spencer DOT com>
mailto:andrew.hardy AT marks-and-spencer DOT com
_____
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.
------_=_NextPart_001_01C4AC87.1F73E84E
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"; xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<TITLE>Message</TITLE>
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20
href=3D"cid:[email protected]" rel=3DFile-List><LINK=20
href=3D"cid:[email protected]" =
rel=3DEdit-Time-Data><!--[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]--><!--[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-face {
font-family: Wingdings;
}
@font-face {
font-family: MS Mincho;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Arial Black;
}
@font-face {
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; =
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "MS Mincho"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "MS Mincho"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "MS Mincho"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "MS Mincho"; mso-style-name: "Normal =
(Web),Normal (Web) Char"; mso-style-link: "Normal (Web) Char Char"; =
mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
PRE {
FONT-SIZE: 10pt; MARGIN: 0in 0in 0pt; COLOR: black; FONT-FAMILY: =
"Courier New"; mso-pagination: widow-orphan; mso-fareast-font-family: =
"MS Mincho"; 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
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; =
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
SPAN.NormalWebCharChar {
FONT-FAMILY: "MS Mincho"; mso-fareast-font-family: "MS Mincho"; =
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; mso-ansi-language: EN-US; =
mso-fareast-language: JA; mso-bidi-language: AR-SA
}
SPAN.StyleNormalWebLatinArialComplexArial75ptChar {
FONT-FAMILY: Arial; mso-style-parent: "Normal (Web),Normal (Web) =
Char"; mso-fareast-font-family: "MS Mincho"; 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; =
mso-ascii-font-family: Arial; 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 {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
pt"; mso-style-link: "Style Normal (Web) + (Latin) Arial (Complex) =
Arial 7.5 pt Char"; mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto; mso-add-space: auto
}
LI.StyleNormalWebLatinArialComplexArial75pt {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
pt"; mso-style-link: "Style Normal (Web) + (Latin) Arial (Complex) =
Arial 7.5 pt Char"; mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto; mso-add-space: auto
}
DIV.StyleNormalWebLatinArialComplexArial75pt {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
pt"; mso-style-link: "Style Normal (Web) + (Latin) Arial (Complex) =
Arial 7.5 pt Char"; mso-margin-top-alt: auto; mso-margin-bottom-alt: =
auto; mso-add-space: auto
}
P.StyleNormalWebLatinArialComplexArial75ptCxSpFirst {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpFirst"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
LI.StyleNormalWebLatinArialComplexArial75ptCxSpFirst {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpFirst"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
DIV.StyleNormalWebLatinArialComplexArial75ptCxSpFirst {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpFirst"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
P.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpMiddle"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
LI.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpMiddle"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
DIV.StyleNormalWebLatinArialComplexArial75ptCxSpMiddle {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpMiddle"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
P.StyleNormalWebLatinArialComplexArial75ptCxSpLast {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpLast"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
LI.StyleNormalWebLatinArialComplexArial75ptCxSpLast {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpLast"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
DIV.StyleNormalWebLatinArialComplexArial75ptCxSpLast {
FONT-SIZE: 7.5pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
Arial; mso-style-parent: "Normal (Web),Normal (Web) Char"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "MS Mincho"; =
mso-style-name: "Style Normal (Web) + (Latin) Arial (Complex) Arial 7.5 =
ptCxSpLast"; mso-style-link: "Style Normal (Web) + (Latin) Arial =
(Complex) Arial 7.5 pt Char"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto; mso-style-type: export-only; =
mso-add-space: auto
}
SPAN.SpellE {
mso-style-name: ""; mso-spl-e: yes
}
SPAN.GramE {
mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
page: Section1
}
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 style=3D"tab-interval: .5in" vLink=3Dblue =
link=3Dblue>
<DIV><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff size=3D2>One=20
minor note on bpdbjobs, if a line has a comma in it then the bpdbjobs =
may appear=20
to have an extra field.</FONT></SPAN></DIV>
<DIV><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff size=3D2>In the=20
GUI is looks like:</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>10/6/2004 9:03:04 PM - Warning bpbrm(pid=3D3156) from=20
client serverA: WRN - Skipping file /file.txt, it has mandatory =
locking=20
enabled and is currently locked</FONT></SPAN></DIV></BLOCKQUOTE>
<DIV dir=3Dltr><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>In the bpdbjobs -all_columns it will look =
like:</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV dir=3Dltr><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>10/6/2004 9:03:04 PM - Warning bpbrm(pid=3D3156) from=20
client serverA: WRN - Skipping file /file.txt</FONT></SPAN>\, it =
has=20
mandatory locking enabled </FONT></SPAN></DIV></BLOCKQUOTE>
<DIV><SPAN class=3D390575015-07102004><FONT face=3DArial =
color=3D#0000ff size=3D2>The=20
issue is the value of <SPAN class=3DSpellE><FONT=20
color=3D#000080>trystatuslines</FONT><FONT color=3D#0000ff> only counts =
that as one=20
line. If you split based on commas you will find an extra =
field. =20
What I did is I look for a comma followed by a space and add that to =
the=20
trystatuslines value if I want to get something at the end of the=20
line.</FONT></SPAN></FONT></SPAN></DIV><!-- Converted from text/rtf =
format -->
<P><SPAN lang=3Den-ca><FONT face=3DPapyrus>Thanks!</FONT></SPAN> </P>
<P><SPAN lang=3Den-ca><FONT face=3DPapyrus>- Cuyler =
Dingwell</FONT></SPAN> </P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B>On Behalf Of =
</B>David=20
Chapa<BR><B>Sent:</B> Wednesday, October 06, 2004 12:13 =
PM<BR><B>To:</B>=20
Hardy, Andrew; Netbackup managers<BR><B>Subject:</B> RE: [Veritas-bu] =
Bpdbjobs=20
database file ??<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><!-- =
Converted from text/rtf format -->Oh=20
<SPAN class=3DGramE>its</SPAN> in there, but it is in <SPAN=20
class=3DSpellE>utime</SPAN>.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here's an =
output from=20
one of my tests.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">13604,0,1,,special,Full,aprilia,aprilia,1097077672,0000000232,000=
0000000,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,aprilia,1097077673,0000000231,0000000000,,,6,10/06/04=20
09:47:56 - started process <SPAN class=3DSpellE>bpbrm</SPAN> =
(22658),10/06/04=20
09:47:56 - connecting,10/06/04 09:47:56 - started process <SPAN=20
class=3DSpellE>bpdm</SPAN> (22661),10/06/04 09:47:57 - connected; =
connect time:=20
000:00:01,10/06/04 09:47:57 - using NONE,10/06/04 09:47:57 - begin=20
=
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 face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">The (comma =
delimited)=20
9<SUP>th</SUP> field is the time the job entered the queue, the=20
10<SUP>th</SUP> field is total elapse time (including queue time), =
the=20
11<SUP>th</SUP> will be end time.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>If you want to get just the actual time it took for the job =
(without=20
including waiting in the queue) then the parsing of this output =
becomes a bit=20
more complicated.<SPAN style=3D"mso-spacerun: yes"> </SPAN>This =
is a=20
dynamic output and requires a great deal of=20
understanding.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P><PRE><FONT face=3DArial =
color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
FONT-FAMILY: Arial">(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 face=3DArial color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: =
10pt; COLOR: navy; FONT-FAMILY: Arial">(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><=
FONT face=3DArial color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
COLOR: navy; FONT-FAMILY: Arial">(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,tr=
yelapsed,tryended,trystatus,trystatusdescription,trystatuscount,[<SPAN =
class=3DSpellE>trystatuslines</SPAN>]...,<SPAN =
class=3DSpellE>trybyteswritten,tryfileswritten</SPAN>]...<o:p></o:p></SP=
AN></FONT></PRE><PRE><FONT face=3DArial color=3Dnavy size=3D2><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=3DArial =
color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
FONT-FAMILY: Arial">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 face=3DArial color=3Dnavy =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=3DArial =
color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
FONT-FAMILY: Arial">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><F=
ONT face=3DArial color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></PRE><PRE><FONT face=3DArial =
color=3Dnavy size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
FONT-FAMILY: Arial">David<o:p></o:p></SPAN></FONT></PRE>
<DIV>
<P><FONT face=3D"Arial Black" color=3Dnavy size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial Black'; =
mso-bidi-font-family: Arial; mso-no-proof: yes">David=20
A. Chapa</SPAN></FONT><SPAN=20
class=3DStyleNormalWebLatinArialComplexArial75ptChar><FONT =
face=3DArial color=3Dnavy=20
size=3D1><SPAN style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: =
yes"> |=20
</SPAN></FONT></SPAN><FONT face=3D"Arial Black" color=3Dred =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: red; FONT-FAMILY: 'Arial Black'; =
mso-bidi-font-family: Arial; mso-no-proof: yes">ADIC</SPAN></FONT><SPAN =
class=3DStyleNormalWebLatinArialComplexArial75ptChar><FONT =
face=3DArial color=3Dnavy=20
size=3D1><SPAN style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: =
yes"> |=20
720.272.8452 cell | </SPAN></FONT></SPAN><FONT face=3DArial =
color=3Dnavy><SPAN=20
style=3D"COLOR: navy; FONT-FAMILY: Arial; mso-no-proof: yes"><A=20
href=3D"http://www.adic.com";><FONT size=3D1><SPAN=20
style=3D"FONT-SIZE: =
7.5pt">http://www.adic.com</SPAN></FONT></A></SPAN></FONT><FONT=20
color=3Dnavy size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: yes">=20
<BR></SPAN></FONT><SPAN=20
class=3DStyleNormalWebLatinArialComplexArial75ptChar><FONT =
face=3DArial color=3Dnavy=20
size=3D1><SPAN style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: =
yes">Sr.=20
Technical Advisor</SPAN></FONT></SPAN><FONT color=3Dnavy =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: yes">=20
<o:p></o:p></SPAN></FONT></P>
<P><FONT face=3D"Arial Black" color=3Dred size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: red; FONT-FAMILY: 'Arial Black'; =
mso-bidi-font-family: Arial; mso-no-proof: yes">Pathlight=20
VX - http://www.adic.com/gopathlightvx<o:p></o:p></SPAN></FONT></P>
<P><FONT face=3D"Times New Roman" color=3Dnavy size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: navy; mso-no-proof: =
yes"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" color=3Dnavy =
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: navy; mso-no-proof: =
yes"><o:p> </o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Hardy, =
Andrew<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, October 06, =
2004 7:32=20
AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Netbackup=20
managers<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B>=20
[Veritas-bu] Bpdbjobs database file ??</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">All,</SPAN></FONT> =
<o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have a script which =
reports the=20
number of all backup stream failures, over a 24 hour period, between =
08:00am=20
& 08:00am every day.</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">However, in order for =
me to easily=20
report on percentage failures of all streams during that period, I =
need to be=20
able to find out the total number of streams (successful or failed) =
during=20
that period.</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Getting the failed jobs =
is easy,=20
because there is a daily log file which is created in=20
/usr/openv/netbackup/db/failure_history.</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Getting the total =
number of jobs=20
which ran between these times, is however proving a little more =
difficult=20
!! I have tried running the bpdbjobs command with all the =
options, but=20
cannot seem to find an output which shows the start time of each=20
stream.</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I guess there must be a =
file=20
somewhere which has this info, since the GUI reports this from =
somewhere, but=20
I cannot find out where it is .......</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can anyone help=20
</SPAN></FONT><o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Many =
Thanks</SPAN></FONT>=20
<o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Andy =
Hardy</SPAN></FONT>=20
<o:p></o:p></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; =
mso-margin-top-alt: 0in"><FONT=20
face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 1in"><B><FONT face=3D"Times New Roman" =
size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt">Andy =
Hardy</SPAN></FONT></B>=20
<BR><FONT size=3D2><SPAN style=3D"FONT-SIZE: 10pt">Technical =
Specialist, Data=20
Storage Services,</SPAN></FONT> <BR><FONT size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt">Marks & Spencer PLC, 3 Longwalk =
Road,Room=20
1SW,</SPAN></FONT> <BR><FONT size=3D2><SPAN style=3D"FONT-SIZE: =
10pt">Stockley=20
Park, Uxbridge,Middesex,UB11 1AW.</SPAN></FONT> <BR><FONT =
face=3DWingdings=20
color=3Dmaroon><SPAN=20
style=3D"COLOR: maroon; FONT-FAMILY: Wingdings">(</SPAN></FONT> <FONT =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt">020 8718 5975</SPAN></FONT> =
<BR><FONT=20
face=3DWingdings color=3Dmaroon><SPAN=20
style=3D"COLOR: maroon; FONT-FAMILY: Wingdings">(</SPAN></FONT> <FONT =
size=3D2><SPAN style=3D"FONT-SIZE: 10pt">07733 333324</SPAN></FONT>=20
<o:p></o:p></P>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DWingdings color=3Dblue =
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: =
Wingdings">+</SPAN></FONT>=20
<A href=3D"mailto:andrew.hardy AT marks-and-spencer DOT com"><FONT =
size=3D2><SPAN=20
style=3D"FONT-SIZE: =
10pt">mailto:andrew.hardy AT marks-and-spencer DOT com</SPAN></FONT></A>=20
<o:p></o:p></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; =
mso-margin-top-alt: 0in"><FONT=20
face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in; TEXT-ALIGN: =
center"=20
align=3Dcenter><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt">
<HR align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in; =
mso-margin-top-alt: 5.0pt"><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"><BR>Registered=20
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=20
Wales.<BR><BR>Telephone (020) 7935 4422<BR>Facsimile (020) 7487=20
2670<BR><BR>www.marksandspencer.com<BR><BR>Please note that =
electronic mail=20
may be monitored.<BR><BR>This e-mail is confidential. If you received =
it by=20
mistake, please let us know and then delete it from your system; you =
should=20
not copy, disclose, or distribute its contents to anyone nor act in =
reliance=20
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=20
Spencer Unit Trust Management Limited, Marks and Spencer Life =
Assurance=20
Limited and Marks and Spencer Savings and Investments Limited is =
Kings Meadow,=20
Chester, CH99 9FB. These firms are authorised and regulated by the =
Financial=20
Services Authority.=20
<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4AC87.1F73E84E--
|
