ADSM-L

Re: Select Statement

2001-10-01 15:05:09
Subject: Re: Select Statement
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Mon, 1 Oct 2001 15:01:45 -0400
SELECT stgpool_name AS ["STORAGEPOOL"], sum(physical_mb) AS ["MB's"]
FROM occupancy
GROUP BY stgpool_name;

>>> jbassi AT IHWY DOT COM 09/28/01 05:17PM >>>
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
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>