Try so (for TSM 5) for last 24 hours
select entity, activity, sum(bytes) as sum from summary where entity in
(select node_name from nodes) and cast((current_timestamp-end_time)hours
as decimal)<24 and activity in ('BACKUP','ARCHIVE','RESTORE','RETRIEVE')
Dmitry
http://www.s-iberia.com
group by activity, entity
On 12.10.2011 19:01, Lee, Gary D. wrote:
Could another approach be to check the actlog for ane4977i and ane4961i
message, dividing the total in 4977 by total in 4961?
That gives you what you inspected divided by what you changed.
Actually reverse the two and you'll get a decimal easily converted to a
percentage.
If I've missed something here, please let me know.
Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310
|