Throughput ration for db2 LAN-Free

[sunny19]

Hi,

I have a db2 node which is backing up through LAN-Free.I want to know the backup ratio from TSM server.Is there any way i can figure that out.

I have tried sta_nodename:q se(It gives me the sessions but am not able to figure out that throughput,I need something like backup ratio/hour)

I have also given a select command which we generally give for a LAN backup but this being LAN-Free its not showing the information requested.

 

[crazytsm]

Try this command...

select node_name,filespace_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from backups, summary where summary.activity='BACKUP' AND BACKUP_DATE='2009-10-07'