>select sum(physical_mb)/1024 as GBytes from occupancy
              GBYTES
--------------------
             1294.32
             1294.32

>select sum(num_files)      as Files  from occupancy
    FILES
---------
  1995091
  1995091

But you may want to subtotal by backup vs archive, storage pool etc.
NODE_NAME, TYPE, FILESPACE_NAME, STGPOOL_NAME, NUM_FILES, PHYSICAL_MB,
LOGICAL_MB

> -----Original Message-----
> From: Joshua S. Bassi [mailto:jbassi AT IHWY DOT COM]
> Sent: Friday, September 28, 2001 6:01 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Select Statement
> 
> 
> Thanks for the responses.  This query should not be per node 
> but per storage
> pool.  In a nutshell, I want to determine how much data TSM 
> is managing for
> 5 TSM servers.  Once I have this query figured out, I will 
> use a script I
> created to login to all 5 RS6K SP TSM server nodes and find 
> out the total
> storage each one has.
> 
> Tonight we are making a drastic change to the number of 
> versions maintained
> and after I run expiration, I am going to run the query again 
> to see how
> much space we recovered.
> 
> 
> --
> 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
> 
> -----Original Message-----
> From: Hervé CHIBOIS [mailto:herve.chibois AT orness DOT fr]
> Sent: Friday, September 28, 2001 11:35 AM
> To: jbassi AT IHWY DOT COM
> Subject: Re: Select Statement
> 
> 
> Hi Josh
> 
> I need more precisions to give you the right macro :
> 
> you want the total amount of data, for a particular NODE ? for night
> sessions (scheduled) ?
> 
> Here are some output of  personnal macros
> 
> Node occupancy
> -----------------
> NODE_NAME                                    PHYSICAL_MB      
>  NUM_FILES
> ------------------     ---------------------------------     
> -----------
> DONALD                                           1358.59      
>      38578
> PICSOU                                            1171.28     
>       22590
> NESTOR                                           1091.81      
>      79563
> 
> 
> Night sessions
> --------------
> NODE_NAME                 DATE  ACTIVITY       START       
> END  MEGABYTES
> FILES          SUCCESSFUL
> ------------------  ----------  ----------  --------  
> --------  ---------  -
> --------  ------------------
> NESTOR              2001-09-28  BACKUP      09:49:37  
> 11:50:39        346
> 16553                 YES
> DONALD              2001-09-28  BACKUP      09:51:43  
> 09:53:55        171
> 2333                 YES
> 
> 
> ----- Original Message -----
> From: "Joshua S. Bassi" <jbassi AT IHWY DOT COM>
> To: <ADSM-L AT VM.MARIST DOT EDU>
> Sent: Friday, September 28, 2001 11:17 PM
> 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
> >
>