Speed of Processes

[johnsot]

Does anyone have a script that I can run to tell me how fast my processes are running. I believe I have a bottle neck in TSM. (MB/s) Also does anyone have the specs for LTO2 and LTO3 tape drives? How many MB/s they are suppose to be able to run?

Thanks,
Tracy Johnson

[GregE]

select process_num as PROC_NUM, process, current_timestamp-start_time as ELAPSED_TIME,(cast(files_processed as decimal(29,2)) /
cast((current_timestamp-start_time)seconds as decimal(29,2)))as "FILES/SEC", (cast(bytes_processed/1024 as decimal(29,2)) /
cast((current_timestamp-start_time)seconds as decimal(29,2))) as "KB/sec", cast(BYTES_PROCESSED/1024/1024/1024 as integer) as GB
from processes

http://www.ultrium.com/technology/generations.html