Even better... q actlog begind=-1 begint=00:00 endt=00:00 msg=4966 | (parsing script) > answerfile.txt This gives you the transfer speeds that were running at the end of the backup. You can parse the node name and speed out of the resultant flow. -- Mark Stapleton System engineer, CDW.
________________________________ From: ADSM: Dist Stor Manager on behalf of goc Sent: Tue 12/16/2008 6:06 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select output help oh, yea .. .thanks (going to see diff) // g On Tue, Dec 16, 2008 at 1:51 PM, Dwight Cook <coo...@cox.net> wrote: > You looking for something like this??? > > select session_id as "Sesija",cast(client_name as char(15)) as "Node", - > cont> cast(state as char(10)) as "Stanje", - > cont> current_timestamp-start_time as "Proteklo vrijeme", - > cont> cast((cast(bytes_sent as decimal(18,0)) / > cast((current_timestamp-start_time)seconds as decimal(18,0))) as > decimal(4,2)) as "Ba jtova poslano/sekunda", - > cont> cast((cast(bytes_received as decimal(18,0)) / > cast((current_timestamp-start_time)seconds as decimal(18,0))) as > decimal(4,2)) as "Bajtova primljeno/sekunda" - > cont> from sessions > > Sesija Node Stanje Proteklo vrijeme > Bajtova poslano/sekunda Bajtova primljeno/sekunda > ----------- --------------- ---------- ------------------------ > ----------------------- ------------------------- > 21206 ZDEC23 Run 0 00:09:15.000000 > 5.42 10.11 > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of goc > Sent: Tuesday, December 16, 2008 6:17 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] select output help > > hi all, > i have this script which shows me transfer speed of active nodes > > > tsm: TSM01>q scr active f=lines > > Name Line Command > Number > ---------- ------ > ------------------------------------------------------------ > ACTIVE 5 select session_id as > "Sesija",cast(client_name as char(15)) > as "Node",cast(state as char(10)) as > "Stanje", - > 10 current_timestamp-start_time as "Proteklo > vrijeme", - > 15 (cast(bytes_sent as decimal(18,0)) / - > 20 cast((current_timestamp-start_time)seconds > as > decimal(18,0))) - > 25 as "Bajtova poslano/sekunda", - > 30 (cast(bytes_received as decimal(18,0)) / - > 35 cast((current_timestamp-start_time)seconds > as > decimal(18,0))) - > 40 as "Bajtova primljeno/sekunda" - > 45 from sessions > > tsm: TSM01> > > which gives me this output for example > > > sm: TSM01>ru active > > Sesija Node Stanje Proteklo vrijeme > Bajtova poslano/sekunda Bajtova primljeno/sekunda > ----------- --------------- ---------- ------------------------ > --------------------------------- --------------------------------- > 5987 STA_5 IdleW 73 02:16:19.000000 > 0.3638666816354 0.1950267751151 > 103037 STA_5 IdleW 59 22:21:18.000000 > 1.4049512193520 0.4672689364663 > 368584 STA_4 IdleW 25 01:20:57.000000 > 0.1362852142196 0.1346342968611 > 368587 STA_4 IdleW 25 01:20:56.000000 > 0.4234309348982 0.2587922707099 > 398505 STA_4 IdleW 20 18:40:28.000000 > 1.9087213434728 0.9382646661036 > 508413 STA_3 IdleW 5 11:39:37.000000 > 1.4668159003495 0.5338001632990 > 521193 REPORTER Run 3 21:30:03.000000 > 25.6434167253411 0.0004218619560 > 542903 STA_4 IdleW 0 15:21:15.000000 > 0.0044866576209 1.7128720036182 > 543239 RADIUSH_TDPO IdleW 0 13:44:00.000000 > 0.0107200647249 0.0066747572815 > 544241 RADIUSH_TDPO Run 0 12:22:46.000000 > 0.1400170533590 0.0414890275097 > 544390 PROVH_TDPO IdleW 0 11:55:39.000000 > 0.0108293160064 0.0087798970632 > 545027 ASMPAT_TDPO IdleW 0 11:10:48.000000 > 0.0116030610216 0.0093669250645 > 545470 SDPSR_TDPO IdleW 0 10:03:00.000000 > 0.0128247650635 0.0103095632946 > 546084 DP7HR_TDPO IdleW 0 08:52:47.000000 > 0.0162354928520 0.0101980167047 > 546774 GORAN Run 0 07:41:43.000000 > 1.1873082337652 0.0113345125076 > 546992 DP7HR_TDPO Run 0 07:08:26.000000 > 0.2652688088384 0.0711507041157 > 547098 CISMK_TDPO IdleW 0 06:33:35.000000 > 0.0220199026042 0.0138047850942 > 547220 PROVH_TDPO IdleW 0 06:05:12.000000 > 0.0237312887915 0.0148776925885 > 547734 GORAN Run 0 03:42:08.000000 > 0.8217286914765 0.0607743097238 > 547950 PROVH_TDPO Run 0 03:04:05.000000 > 0.5133544590312 0.1652331371661 > 548335 CISMK_TDPO Run 0 01:18:38.000000 > 1.2030521407376 0.3872403560830 > 548647 ERHR_TDPO IdleW 0 00:03:11.000000 > 2.4659685863874 1.9842931937172 > 548649 TEMIP Run 0 00:02:17.000000 > 75662.5839416058394 11.6496350364963 > 548650 TEMIP RecvW 0 00:02:14.000000 > 9.2164179104477 4144573.5597014925373 > > > the question is --> how to get rid of so many decimals ? i need 2 or > even none ... i tried few variations but none of them work > thanks for help > > // > g > > -- > > Rita Rudner - "I was a vegetarian until I started leaning toward the > sunlight." > -- Stephen Leacock - "I detest life-insurance agents: they always argue that I shall some day die, which is not so."