Generating Netbackup throughput data reports

If you support Netbackup at your site, I’m sure you’ve had to look into issues with slow clients and failed backups. The nbstatus script I mentioned in a previous post is useful for identifying connection problems, but it doesn’t help you understand how well your clients are performing. To help me understand how much data my clients are pushing, I wrote the nbthroughput shell script:

$ nbthroughput

Top 5 hosts by data written

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
ZeusFileSystem        Full-Quarterly        med01-hcart3-    9199683296  39376  
VMWareMBackups        Full-Weekly           med01-hcart3-    1756762304  84219  
VMWareBackups         Cumulative-Increment  med01-hcart3-    1035153514  34155  
VMWareBackups         Cumulative-Increment  med01-hcart3-    879121280   68009  
ApolloFileSystem      Full-Weekly           med01-disk       771900576   19919  

Fastest 5 clients (processed 10MB+)

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
Oracle01FileSystem    Differential-Increme  med01-hcart3-    3609248     128365 
App01FileSystem       Differential-Increme  med01-hcart3-    3569984     128250 
Web01FileSystem       Differential-Increme  med01-hcart3-    3550592     126423 
VMWareBackups         Cumulative-Increment  med01-disk       335576832   100559
ZeusFileSystem        Default-Application-  med01-disk       104857632   93847

Slowest 5 clients (processed 10MB+)

Policy                Schedule              Storage Unit     Bytes       Bytes/s
--------------------  --------------------  ---------------  ----------  -------
W2k3-1FileSystem      Differential-Increme  med01-disk       1298912     333 
W2k3-2FileSystem      Differential-Increme  med01-disk       1482752     2000 
W2k3-3FileSystem      Differential-Increme  med01-disk       1095936     2083 
W2k3-4FileSystem      Differential-Increme  med01-disk       4114880     2425 
W2k3-5FileSystem      Differential-Increme  med01-disk       3496576     2483 

The script will display the fastest clients, the slowest clients, and how much data your clients are pushing to your media servers. I find it useful, so I thought I would post it here for others to use.

5 thoughts on “Generating Netbackup throughput data reports”

  1. Wow, what a wonderful script. I’m looking exactly for this script on a windows environment and i dont quite understand the scripting mentioned here. i got upto bpdbjobs – report, which lists everything but throughput. could u please guide me?

  2. hi, could you please reply to my e-mail id? I really would like to use it in the windows environment now. please please please…

  3. Can you also please post the file you use to select the columns that “bpdbjobs -report” outputs?

  4. what version of netbackup are you using? The 2nd and 3rd block, (fastest and slowest clients) is not working for me under ver 6.0

    When I mess with bpdbjobs -report, I don’t have an 11th and 12th field with bytes written, and -all_columns, -most_columns, and -gdm doesn’t seem to give me what I want. Any clues???

  5. I think i figured out what is going on. To get the script to work the way it’s shown above, you will need to add the following configuration directives to your bp.conf:

    BPDBJOBS_COLDEFS = Type 1 true
    BPDBJOBS_COLDEFS = State 1 true
    BPDBJOBS_COLDEFS = Status 1 true
    BPDBJOBS_COLDEFS = Policy 1 true
    BPDBJOBS_COLDEFS = Schedule 1 true
    BPDBJOBS_COLDEFS = Client 1 true
    BPDBJOBS_COLDEFS = DstMedia_Server 1 true
    BPDBJOBS_COLDEFS = Elapsed 1 true
    BPDBJOBS_COLDEFS = Kilobytes 1 true
    BPDBJOBS_COLDEFS = KbPerSec 1 true
    BPDBJOBS_COLDEFS = Files 1 true

    This will tell bpdbjobs to spit out a bit more data than it normally does.

    – Ryan

Leave a Reply

Your email address will not be published. Required fields are marked *