|
Re: [ADSM-L] select output help
2008-12-19 16:19:32
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 AT VM.MARIST DOT 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 <cookde AT cox DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of goc
> Sent: Tuesday, December 16, 2008 6:17 AM
> To: ADSM-L AT VM.MARIST DOT 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."
|
| <Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] select output help, goc
- Re: [ADSM-L] select output help, Dwight Cook
- Re: [ADSM-L] select output help, goc
- Re: [ADSM-L] select output help,
Mark Stapleton <=
- [ADSM-L] Backupset media goes to Copypool too?, Cheung, Richard
- Re: [ADSM-L] Backupset media goes to Copypool too?, Richard Sims
- Re: [ADSM-L] Backupset media goes to Copypool too?, Cheung, Richard
- Re: [ADSM-L] Backupset media goes to Copypool too?, Nick Laflamme
- Re: [ADSM-L] Backupset media goes to Copypool too?, Cheung, Richard
- Re: [ADSM-L] Backupset media goes to Copypool too?, Remco Post
- Re: [ADSM-L] Backupset media goes to Copypool too?, Adrian C. Pardo
- Re: [ADSM-L] Backupset media goes to Copypool too?, Bos, Karel
- Re: [ADSM-L] Backupset media goes to Copypool too?, Bill Boyer
- Re: [ADSM-L] Backupset media goes to Copypool too?, Remco Post
|
|
|
