[Veritas-bu] DBBACKUP - available_media - produces erroneous info... (Fw

we should add this one to the FAQ! (oh yeah, there is no FAQ... I 
think I'm gonna start one!)

In any case, here's my response from the last time this question came 
up on the list:

>  Don't necessarily trust the available_media script when it says that
>  a tape's status is DBBACKUP.  It's certainly possible to have "extra"
>  tapes which are marked for DB backups, but more likely it's a bug in
>  the available_media script.  IIRC the bpmedialist call (which is
>  inefficiently called hundreds or thousands of times, depending on how
>  many tapes you have, see fix below) occasionally hits a snag and
>  doesn't return info on one of your tapes and in this case the tape
>  gets the "DBBACKUP" status assigned.
>
>  Here's what I suggest - not only is it a really simple fix for this
>  problem, but it will also happen to
>  tremendously speed up your available_media script if you have a lot
>  of tapes.  (e.g. surveying 600 tapes takes about 30 seconds instead
>  of 10 minutes)
>
>  Edit the available_media shell script like so:  (I'm looking at a box
>  running 3.1.1 at the moment, but the 3.2 available_media script is
>  identical or close enough)
>
>  =========
>  1--go to the line "cat $VMPOOL_OUTPUT |"
>      (line 152 for me)
>
>  2--BEFORE this line, add the following command:
>       /usr/openv/netbackup/bin/admincmd/bpmedialist -mlist -l >
>  /tmp/mvedialist.out
>
>     (this command should be all one line, and that's a
>      lowercase "L" flag, not the digit "1")
>
>  3--go to the line where bpmedialist is being piped to a while loop
>      (line 177 for me)
>
>  4--comment out the bpmedialist line, and replace it with the following:
>
>           grep $vmediaid /tmp/vmedialist.out 2>/dev/null |
>
>     (don't forget that pipe at the end....)
>  ===========
>
>  sorry, the above fix won't necessarily work on an NT Master server :))


HTH
rob


At 4:40 PM -0700 9/13/00, Eric Martens wrote:
>>----------------Begin Forwarded Message----------------<
>
>Date: Wed, 13 Sep 2000 16:33:00 -0700 (PDT)
>From: "William Large" <William.Large AT west.sun DOT com>
>Subject: DBBACKUP - available_media - produces erroneous info...
>To: netbackup_interest AT sun DOT com
>
>Hello,
>
>It appears the NetBackup script :
>
>
>    (/usr/openv/netbackup/bin/goodies/available_media)
>
>for NBU version 3.2a seems to report erroneous errors.  (running 
>under sol 2.6)
>  Currently, I run this script and produce the results to a web page that also
>runs a tape summary count by pool.  However, the results given reflect that
>the DBBACKUP counts are way off.  Actually, I only have 2 DBBACKUP tapes but
>the report generates numbers that are much higher.
>
>
>I decided to put a sanity_ck routine into my script that accounts for any
>DBBACKUP counts over 4 and rerun the report again.  Funny enough the report's
>continually spit out a variety of numbers for DBBACKUP that are irregular
>and not correct.  An example of the script execution reruns can be seen below
>as a result of my code.  Just ignore the line count stuff...
>
>Anyone know why this should be happening and how to fix it.
>
>Please advise,
>
>
>Thanks,
>
>
>At Your Service,
>
>
>      /\        W i l l i a m   L a r g e   /  x43929 -or- 1-858-626-3929
>     \\ \       Data Center and High Performance Group
>    \ \\ /      DHPG Information Services   -  Unix Systems and Network Admin.
>   / \/ / /     Sun Microsystems Inc.
>  / /   \//\    Eastgate Technology Park    -  MailStop : USAN05-101
>  \//\   / /    Towne Centre Drive, San Diego, Ca., 92121
>   / / /\ /     EMail                       :  william AT sysadm.West.Sun DOT 
> COM
>    / \\ \      Named Email                 :  william.large AT sun DOT com
>     \ \\       Fax                         :  1-(858)-625-0690
>      \/        Outside of California       :  1-(800)-555-9786 Ext x43929
>
>
>
>
>------------------------------------------------------------------------------
>
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       10
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       25
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       20
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       26
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       25
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       13
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       17
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       24
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       14
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       26
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       21
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       21
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       10
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       25
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       20
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       26
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       25
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       13
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       17
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       24
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       14
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       26
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       12
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       35
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       21
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>line count (208) should be less then 30
>DBACKUP count was       21
>Rerunning get_available_media...
>Cleaning out old file
>/dhpg/web/sdhelp/htdocs/sdhelp/reports/backup_info/hal/available_media_for_hal
>
>
>>----------------End Forwarded Message----------------<
>
>_______________________________________________
>Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

--
Rob Worman, Consultant
Collective Technologies           cell: 612/802-6850
"The Power of Many Minds"         alpha page: 1-800-946-4646, pin=1422494
[Veritas-bu] DBBACKUP - available_media - produces erroneous info... (Fwd)
