Veritas-bu

[Veritas-bu] Bpdbjobs database file ??

2004-10-06 10:18:45
Subject: [Veritas-bu] Bpdbjobs database file ??
From: Bruce.Chewning AT suntrust DOT com (Chewning.Bruce)
Date: Wed, 6 Oct 2004 10:18:45 -0400
This is a multi-part message in MIME format.

------_=_NextPart_001_01C4ABAF.63FD3D86
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: 7bit

work "bpdbm -ctime date_code" in to your script.

 -> /user/openv/netbackup/bin/admincmd/bperror | tail -1
1097072117 1 4 4 xxxxxxxx 0 0 0 *NULL* bpsched no drives up on storage
unit <xxxxxxxx-hcart2-robot-acs-0>

  -> bpdbm -ctime 1097072117                            
1097072117 = Wed Oct  6 10:15:17 2004


        -----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 9: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. 
************************************************ 
The information transmitted is intended solely 
for the individual or entity to which it is  
addressed and may contain confidential and/or 
privileged material. Any review, retransmission, 
dissemination or other use of or taking action 
in reliance upon this information by persons or 
entities other than the intended recipient is 
prohibited. If you have received this email in 
error please contact the sender and delete the 
material from any computer. 
************************************************ 

------_=_NextPart_001_01C4ABAF.63FD3D86
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk";>
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR></HEAD><BODY =
><DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D920561114-06102004>work=20
"bpdbm -ctime date_code" in to your script.</SPAN></FONT></DIV>
<DIV><BR><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D920561114-06102004>&nbsp;</SPAN>-&gt;=20
/user/openv/netbackup/bin/admincmd/bperror | tail -1<BR><FONT=20
color=3D#000000>1097072117 1 4 4&nbsp;<SPAN=20
class=3D920561114-06102004>xxxxxxxx</SPAN> 0 0 0 *NULL* bpsched no =
drives up on=20
storage unit &lt;<SPAN=20
class=3D920561114-06102004>xxxxxxxx</SPAN>-hcart2-robot-acs-0&gt;<BR></FO=
NT><BR>&nbsp;=20
-&gt; bpdbm -ctime=20
1097072117&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR><FONT color=3D#000000>1097072117 =3D Wed Oct&nbsp; 6 10:15:17=20
2004<BR></FONT></FONT></FONT></FONT></DIV>
<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>Hardy,=20
  Andrew<BR><B>Sent:</B> Wednesday, October 06, 2004 9:32 =
AM<BR><B>To:</B>=20
  Netbackup managers<BR><B>Subject:</B> [Veritas-bu] Bpdbjobs database =
file=20
  ??<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
  <P><FONT face=3DArial size=3D2>All,</FONT> </P>
  <P><FONT face=3DArial size=3D2>I have a script which reports the =
number of all=20
  backup stream failures, over a 24 hour period, between 08:00am &amp; =
08:00am=20
  every day.</FONT></P>
  <P><FONT face=3DArial size=3D2>However, in order for me to easily =
report on=20
  percentage failures of all streams during that period, I need to be =
able to=20
  find out the total number of streams (successful or failed) during =
that=20
  period.</FONT></P>
  <P><FONT face=3DArial size=3D2>Getting the failed jobs is easy, =
because there is a=20
  daily log file which is created in=20
  /usr/openv/netbackup/db/failure_history.</FONT></P>
  <P><FONT face=3DArial size=3D2>Getting the total number of jobs which =
ran between=20
  these times, is however proving a little more difficult !!&nbsp; I =
have tried=20
  running the bpdbjobs command with all the options, but cannot seem to =
find an=20
  output which shows the start time of each stream.</FONT></P>
  <P><FONT face=3DArial size=3D2>I guess there must be a file somewhere =
which has=20
  this info, since the GUI reports this from somewhere, but I cannot =
find out=20
  where it is &#8230;&#8230;.</FONT></P>
  <P><FONT face=3DArial size=3D2>Can anyone help </FONT></P>
  <P><FONT face=3DArial size=3D2>Many Thanks</FONT> </P>
  <P><FONT face=3DArial size=3D2>Andy Hardy</FONT> </P><BR><BR>
  <UL>
    <P><SPAN lang=3Den-us><B><FONT face=3D"Times New Roman" =
size=3D2>Andy=20
    Hardy</FONT></B></SPAN> <BR><SPAN lang=3Den-us><FONT face=3D"Times =
New Roman"=20
    size=3D2>Technical Specialist, Data Storage Services,</FONT></SPAN> =
<BR><SPAN=20
    lang=3Den-us><FONT face=3D"Times New Roman" size=3D2>Marks &amp; =
Spencer PLC, 3=20
    Longwalk Road,Room 1SW,</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT=20
    face=3D"Times New Roman" size=3D2>Stockley Park, =
Uxbridge,Middesex,UB11=20
    1AW.</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT face=3DWingdings=20
    color=3D#800000>(<FONT face=3D"Courier New"></FONT></FONT> <FONT=20
    face=3D"Times New Roman" size=3D2>020 8718 5975</FONT></SPAN> =
<BR><SPAN=20
    lang=3Den-us><FONT face=3DWingdings color=3D#800000>(<FONT=20
    face=3D"Courier New"></FONT></FONT> <FONT face=3D"Times New Roman" =
size=3D2>07733=20
    333324</FONT><B></B></SPAN> </P></UL>
  <P><SPAN lang=3Den-us><FONT face=3DWingdings color=3D#0000ff>+<FONT=20
  face=3D"Courier New"></FONT></FONT> </SPAN><A=20
  href=3D"mailto:andrew.hardy AT marks-and-spencer DOT com"><SPAN=20
  lang=3Den-us><U></U><U><FONT face=3D"Times New Roman" color=3D#0000ff=20
  =
size=3D2>mailto:andrew.hardy AT marks-and-spencer DOT 
com</FONT></U></SPAN></A><=
SPAN=20
  lang=3Den-us></SPAN> </P><BR><BR>
  <HR>

  <P><BR>Registered Office:<BR>Marks and Spencer plc<BR>Waterside =
House<BR>35=20
  North Wharf Road<BR>London<BR>W2 1NW<BR><BR>Registered No. 214436 in =
England=20
  and 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=20
  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. <BR><BR></P></BLOCKQUOTE></DIV>
<PRE>************************************************<BR>The information =
transmitted is intended solely<BR>for the individual or entity to which =
it is <BR>addressed and may contain confidential and/or<BR>privileged =
material. Any review, retransmission,<BR>dissemination or other use of =
or taking action<BR>in reliance upon this information by persons =
or<BR>entities other than the intended recipient is<BR>prohibited. If =
you have received this email in<BR>error please contact the sender and =
delete the<BR>material from any =
computer.<BR>************************************************</PRE></BODY=
></HTML>

------_=_NextPart_001_01C4ABAF.63FD3D86--