ADSM-L

Re: Select Statement

2001-09-28 14:44:12
Subject: Re: Select Statement
From: Scotty Logan <swl AT STANFORD DOT EDU>
Date: Fri, 28 Sep 2001 11:40:01 -0700
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>