Re: [ADSM-L] select output help
2008-12-16 07:52:23
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."
|
<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
- [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
|
|
|