Re: Select Statement
2001-09-28 14:44:12
How about:
tsm: ADSM_4>select stgpool_name as "Pool", -
cont> cast((est_capacity_mb*pct_utilized/100.0)/1024 as numeric(8,2)) as
"GB Used" -
cont> from stgpools
Pool GB Used
------------------ ----------
...
...
DESK_BU 0.00
DESK_BU_PRI 3395.19
...
and
tsm: ADSM_4>select cast(sum(est_capacity_mb*pct_utilized/100.0)/1024 -
cont> as numeric(8,2)) as "Total GB Used" from stgpools
Total GB Used
-------------
6031.16
6031.16
Scotty
--
Scotty Logan <swl AT stanford DOT edu>
Scotty Logan <swl AT stanford DOT edu>
ITSS-CSS http://www.stanford.edu/group/itss/css/
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> Behalf Of
> Joshua S. Bassi
> Sent: Friday, September 28, 2001 14:17
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Select Statement
>
>
> All,
>
> I am looking for a select statement that will enable me to
> determine the
> total amount of
> data backed up (disk and tape). I know I can use 'select *
> from stgpools'
> and see 1) est_capacity_mb and 2) the pct_utilized. Is there an SQL
> function where I can do the math and get the 1) capacity used for each
> stgpool and 2) capacity used for all stgpools.
>
>
>
> --
> Joshua S. Bassi
> Independent IT Consultant
> IBM Certified - AIX/HACMP, SAN, Shark
> Tivoli Certified Consultant- ADSM/TSM
> Cell (408)&(831) 332-4006
> jbassi AT ihwy DOT com
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: Select Statement, (continued)
- Re: Select Statement, Guan, Phillip
- Re: Select Statement, Marc Levitan
- Re: Select Statement, Alan Davenport
- Re: Select Statement, Guan, Phillip
- Select Statement, Matthew Large
- Re: Select Statement, Alan Davenport
- Re: Select Statement, Ford, Phillip
- Re: Select Statement, PINNI, BALANAND (SBCSI)
- Select Statement, Joshua S. Bassi
- Re: Select Statement,
Scotty Logan <=
- Re: Select Statement, Joshua S. Bassi
- Re: Select Statement, Richard Cowen
|
|
|