ADSM-L

Re: [ADSM-L] select output help

2008-12-16 07:52:23
Subject: Re: [ADSM-L] select output help
From: Dwight Cook <cookde AT COX DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 16 Dec 2008 06:51:33 -0600
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."