Backup traffic 2

[J1gh2]

Hi Guys

I would like to work out the amount of traffic (in Mbps) that is being backed up (from all clients) over certain interfaces on my servers. Is there an easier way to do this without the tedious effort of analysing the activity log manually.

thanks

 

[LED888]

May want to check out TSM operational reporting.

ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/server/v5r2/WIN/LATEST/tsmcon5240_win.exe

You can find a presentation on it at:

ftp://service.boulder.ibm.com/storage/tivoli-storage-management/techprev/tsmopreport/latest/tsmrept_walk_through_d7.ppt

The TSM Operational Reporter can not be installed on the same system as the TSM Server.

Just install the TSM OR on a workstation or a laptop.

The TSM OR issue select statments against the TSM database.
If your TSM Server is very busy, do not run all of the reports. Due to the complexity of some of the select statment it can drop the TSM Server performance or crash the TSM Server.

Good Luck,
Sias

 

[J1gh2]

Thanks a lot, LED888

Our security setup would not allow for this to be installed but I managed to put together some sql to get the information that I required.

Best regards

 

[zaxxon]

Maybe a shell script comes handy? Shows you how much data counted in bytes was backed up or retrieved for a client (Our client in this example is "CMCLIENT").

#!/bin/ksh

query()
{
dsmadmc -id=admin -password=password "select bytes from summary where start_time>='$2 $3' and end_time<='$2 $4' and activity='$1' and entity='CMCLIENT'" | awk ' BEGIN{sum=0}; sum=sum+$1; END{print sum}' | tail -1 | xargs echo "Bytes processed: "
}

if [[ $1 != "RESTORE" && $1 != "BACKUP" ]]; then
echo; echo "qtsm <BACKUP|RESTORE> <DATE> <START_TIME> <END_TIME>"
echo "Example: qtsm RESTORE 2003-01-28 07:00 08:00"
echo "-------------------------------------------------"
exit
else
query $1 $2 $3 $4
fi
exit 0

laters
zaxxon

 

[J1gh2]

Thanks zaxxon
Sorry for not coming back to you earlier. I must have missed your post.

Thanks

 

[zaxxon]

Np

laters
zaxxon